April 12, 2011 at 10:58 am
I have a report and I have to use a stored procedure to display final output.
now i have to use four parameters and the report will be generated on the basis of these parameter values.
Now the problem is that one of the parameter of the four should be displayed as a dropdown on my preview page as i want them use to select only one value.
The values in the dropdown are 1,2,3.
now the challange:-(the other parameters should be textbox and not dropdown where user will fill there value)
1) the textbox should be displayed on basis of dropdown value selected.
2) only one of the parameter textbox should be displayed at a time.
ex:
if(dropdown value=1) then
display parameter1 textbox
if(dropdown value=2) then
display parameter2 textbox
if(dropdown value=3) then
display parameter3 textbox
This means at a time only one textbox will be displayed on paramter one dropdown value selection.
How to get this done.?
April 29, 2011 at 8:51 pm
Are you expecting users to select each item from the drop down box, populate each text box, THEN run the report? Or do they select 1,2, or 3, fill in the appropriate text box and run the report?
If it's the latter, consider just using one text box parameter and passing that value to all 3 parameters required for your query. You would determine which value the query was expecting by looking at the value in your drop down box.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply