SQL 2000 Reporting Services – Using embedded code to guide user on input parameters?

35 pts.
Tags:
Microsoft
Microsoft SQL Server 2000
Reporting Services
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"?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Change the properties of the input parameters to now accept null values. The UI will then require value be selected.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: