Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roy mm
Yak Posting Veteran
62 Posts |
 Posted - 2008-07-24 : 08:41:42
|
| Hi,I have a report which getting a parameter value base on the user id.There is a situation that that the parameter isn't getting any value (I remove the option for null value) and then when the user run it, he get an error: The 'my_param' parameter is missing a value'.I want the report to stop now but I don't want the user to see the error (since he can see my parameter name).Is there a way to show the user a costume message instead?Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-24 : 10:03:26
|
| Supposed you are giving the userId via expression to the Default Values.I think the only way to handle this wood be inside expression via Iif and IsNothing() and a "dummyuser".WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-24 : 10:16:37
|
quote:
Originally posted by roy mm
Hi,I have a report which getting a parameter value base on the user id.There is a situation that that the parameter isn't getting any value (I remove the option for null value) and then when the user run it, he get an error: The 'my_param' parameter is missing a value'.I want the report to stop now but I don't want the user to see the error (since he can see my parameter name).Is there a way to show the user a costume message instead?Thanks
not sure if you can handle this in standard report viewer. however you could do this if you're using a custom report viewer by including a client side validation to see if parameter has a valid value in url and if not show a customised error message. |
|
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2008-07-24 : 14:48:12
|
| [/quote]not sure if you can handle this in standard report viewer. however you could do this if you're using a custom report viewer by including a client side validation to see if parameter has a valid value in url and if not show a customised error message.[/quote]Hi.I'm showing the reports in a web browser (http://sqlserver/reportserver).Its pretty sad to think that there is no way to redirect the server to another error page when an error occur :(Thanks for your help. |
|
|
|
|
|
|
How to hide RS error from cliant?