Am I crazy, or is there no form validation for report parameters?

Am I crazy, or is there no form validation for report parameters?

Post by UGF1b » Thu, 08 Mar 2007 02:51:08


Maybe I am just not using the correct search strings, but it really appears
that there is no server side validation available for parameters in Reporting
Services generated reports? Is this true (so then I can stop looking)?

Thanks for your help.

--
Paul
Web Developer
 
 
 

Am I crazy, or is there no form validation for report parameters?

Post by Bruce L-C » Thu, 08 Mar 2007 03:01:05

You can do multiple things. First, in layout tab, Report Menu-> Report
Parameters you can set the data type of the parameter. This is a big help
off the bat. Next, realize that you have two different things: query
parameters and report parameters. RS kindof blurs the difference because it
automatically creates report parameters and maps them to the query
parameter. Your query parameter does not have to map directly to a report
parameter. Click on the ... in the dataset tab, parameters. You can map your
query parameter to an expression. This expression could do some additional
massaging of the data, however, it doesn't allow validation per se.

I agree, a validation expression and text that could be associated with a
parameter would be very nice to have.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services