all groups > sql server reporting services > august 2004 >
You're in the

sql server reporting services

group:

VBScript


VBScript TimS
8/27/2004 7:03:02 PM
sql server reporting services: Can anyone tell me if VBScript is supported in this product? I have
developed a report that takes one parameter. I have removed the checkboxes
for allowing nulls and blanks for the parameter, yet when I execute the
report and do not enter anything into the parameter field - nothing happens.
No, I mean nothing happens at all - no error messages, no input validation,
etc. I even have a message coded on the norows property for the report, but
that only works if you enter a parameter and nothing is found. I am running
SP1 of Reporting Services.

I would like to write a VBScript routine to do some input validation on my
one parameter, but cannot figure out how to do so. Any advice would be
appreciated!

Re: VBScript Ravi Mumulla (Microsoft)
8/27/2004 8:43:42 PM
Expressions can be written in VB.NET. As for parameter validation, consider
doing it in your stored procedure if you're extracting data using a stored
procedure OR writing a custom wrapper. Take a look at
http://odetocode.com/Articles/156.aspx for an example of the latter.

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

Re: VBScript TimS
8/27/2004 10:09:16 PM
Thanks Ravi. I appreciate your help and will give your suggestions a try.

Tim

[quoted text, click to view]
Re: VBScript anonymous NO[at]SPAM discussions.microsoft.com
8/27/2004 10:54:16 PM
I have another suggestion ,but dont know if it will work,
just try it out.
Have hidden text box with the following expression:
=IIF(parameters!<parametername>.Value = "",MsgBox("Please
enter some value for the parameter"),"")

[quoted text, click to view]
AddThis Social Bookmark Button