35 pts.
0
Q:
SQL 2000 Reporting Services - Using embedded code to guide user on input parameters?
I'm working on a report which has these input parameters:

StartDate (textbox, data type is datetime)
EndDate (textbox, data type is datetime)
AccountNumber (dropdown, data type is string)

I need to set up logic where if the user viewing the report has input only date values, they'll be prompted to select an AccountNumber, or if they select an AccountNumber they'll be required to select a valid date range.

I've successfully created functions for purposes of validating the fields, and put these on the Code tab of the Report Properties, but now I'm not clear on how to make this work from the report itself.

Can I pop up a messagebox that fires if the user hasn't input the required info and they try to View the report? Or can I just populate a textbox with some error text like "Hey dummy, you forgot the AccountNumber"?
ASKED: Feb 27 2008  1:23 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Change the properties of the input parameters to now accept null values. The UI will then require value be selected.
Last Answered: Sep 20 2008  11:24 PM GMT by Mrdenny   47070 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0