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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL 2000 Reporting Services

Author  Topic 

miranwar
Posting Yak Master

125 Posts

Posted - 2004-08-26 : 06:21:06
Hello,

Can anyone tell me if it is possible if you can send multiple parameters to a SP within SQL 2000 Reports Builder. For example selecting multiple values from a listbox and passing those values to a StoredProcedure? So far I can only pass single params

Thanks in Adnance

gpl
Posting Yak Master

195 Posts

Posted - 2004-08-26 : 10:52:47
Yes - and no, we had to create a custom page to get the parameters, we then passed these as a comma-delimited string in the query string.

Hope this helps
Graham
Go to Top of Page

Sitka
Aged Yak Warrior

571 Posts

Posted - 2004-08-26 : 12:31:20
Sure does help Graham. I had it installed made a few reports and froze at that point. Haven't been back since! Nice start though and one would like to think native support is just moments away.

Possessing a wide range of watered down skills.
Go to Top of Page
   

- Advertisement -