I'm new to RS, I've got SQL2005 installed and I'm trying to use the multiple select report parameter. I'm using a report filter to = database.field IN =Parameter.value(0) etc and even though I'm select more than one in the drop down it's only returning values for one of the options!
Helps what else do I need to do?
Thanks!Fixed, I removed the (0) from the .value filter expressions and it worked.
Hi
I'm trying to send email from my rss script. It seems that the script cannot create an SmtpClient instance because of SmtpPermission problems, but I just can't find where I need to enable the SmtpPermission. I've tried many things, including web.config and rssrvpolicy.config.
Here's a code sample:
Public Sub Main
Dim smtpClient As New System.Net.Mail.SmtpClient
End Sub
and here's the output when I execute the above script under rs.exe against my local report server
Unhandled exception:
Request for the permission of type 'System.Net.Mail.SmtpPermission, System, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089' failed.
Any ideas?
Many thanks
Tony
i have the same problem but with a console application....I read on an MSDN blog that SQL Server 2005 Express has "Basic reporting services".
Where can I find out exactly what this means?
As usual, the MS site is unhelpful.
Thanks,
MH&SOoh.
Found it now.
<Eats words>
It's right there on the MS site.
Great stuffings.|||Said site is: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
Buggrit. Buggrem.
