April 12, 2011 at 10:57 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 12, 2011 at 1:17 pm
I don't think you can do that. If someone else has a way I would love to see it.
What I would try is to have only one text based parameter be visible. That would be the textbox where they would enter their data. Then I would have some internal parameters where they were populated or not depending on the 1,2,3 choice and the text in the one visible textbox parameter. Then pass the appropriate parameters and values to the SP.
April 12, 2011 at 1:45 pm
Daniel Bowlin (4/12/2011)
I don't think you can do that. If someone else has a way I would love to see it.What I would try is to have only one text based parameter be visible. That would be the textbox where they would enter their data. Then I would have some internal parameters where they were populated or not depending on the 1,2,3 choice and the text in the one visible textbox parameter. Then pass the appropriate parameters and values to the SP.
I agree with Daniel.
You can not control a parameter's visiblity at run time without creating your own custom interface.
You should be able to work some magic and have two parameters. One for the (1,2,3) and one for the textbox and just have your procedure handle what that textbox should represent depending on the first parameter's selection
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply