July 23, 2008 at 1:21 pm
Is it possible to code to not run a report based on report parameter selection and display an error message?
July 23, 2008 at 1:44 pm
You could put a textbox on the report and set the visibility (Hidden Property) by checking the value of the parameter like this =IIF(Parameters!test.Value = "x", False, True) and set the visibility of the rest of the report items to the opposite. You would also want to use an expression in your dataset to not go get the data based on the parameter
Or
You could dummy it by setting your datasource query to check the parameter and return no data. Then for the no rows message check the parameter again and set the message that you want there.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 23, 2008 at 2:41 pm
Jack Corbett (7/23/2008)
You could put a textbox on the report and set the visibility (Hidden Property) by checking the value of the parameter like this =IIF(Parameters!test.Value = "x", False, True) and set the visibility of the rest of the report items to the opposite. You would also want to use an expression in your dataset to not go get the data based on the parameterOr
You could dummy it by setting your datasource query to check the parameter and return no data. Then for the no rows message check the parameter again and set the message that you want there.
Thanks Jack! I used the dummy version and it works great!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply