Can anybody please suggest the best practice to achieve the following.
Using SQL Server 2008 Reporting services and Parameters.
1. Created a dataset (Districts) which is having fields ID and Name.
2. Used both fields in the report, which is working fine.
3. I want to create 2 parameters on the report, a textbox for ID and a drop down list displaying district names.
4. I want to generate report for all the below scenarios.
a) Entered only ID in the textbox.
b) Selected only district name from the drop down list
c) Entered both the data ID and district name.
if i used "AND" and "OR", i'll not the accurate data for the above scenarios to work.
Please suggest. Is there a way to take the parameter only if user entered.
View Complete Post