Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Parameter drop down list

Author  Topic 

urpalshu
Starting Member

21 Posts

Posted - 2006-04-21 : 14:08:37
Hello,

I am fairly new to Reporting Services Report.

>> I have one Parameter to be entered in the report which is Invoice #

>> I have the second parameter Box which shows a list of numbers, which is related to that particular invoice number entered.

>> I put a default invoice number (I don't know if it is the right thing to do though)

>> For the first time I view the report and type in the parameter. The second parameter drop down list gets populated. (That is what I want)

>> Then when I try to enter another invoice number, it does'nt work, seems like the application hangs or something

Please could you help me with resolving this issue.

Thank you,

snktheone
Starting Member

20 Posts

Posted - 2006-04-24 : 02:31:11
u need to create separate datasets for each of the drop downs and then keep the query so that for teh selected invoice humber which would be a parameter , ur second drop down would be selected on the basis of this query
Go to Top of Page
   

- Advertisement -