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.
| Author |
Topic |
|
rmk108
Starting Member
1 Post |
 Posted - 2007-12-05 : 18:36:14
|
| Hi, I want to generate a report in using SQL server 2000 reporting services. I will be passing a parameter(VendorID) as part of the URL.the report should show the info related ot that particular vendor only.Thanks in advance.RMK |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-05 : 18:39:35
|
| That's simple enough. What part are you having a problem with?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
jhermiz
3564 Posts |
Posted - 2007-12-06 : 11:32:48
|
quote:
Originally posted by rmk108
Hi, I want to generate a report in using SQL server 2000 reporting services. I will be passing a parameter(VendorID) as part of the URL.the report should show the info related ot that particular vendor only.Thanks in advance.RMK
Your report should be based on a stored procedure that takes one parameter namely the vendorid. Not sure what type your parameter is int, varchar, etc. you didn't state.So:PROCEDURE rspMySproc @VendorID int BEGIN SELECT blah1, blah2 FROM YourTable WHERE VendorID = @VendorID ORDER BY blah3 ENDThen when you call this report you can do:http://myBox/ReportServer?%2fNameOfFolder%2fNameOfReport&VendorID=YourParameterValueSomething to this effect, you basically just call the report by getting to the report manager and passing the report name and the parameter value for the VendorID.JonPS: You may have one additional data set (another sproc) that displays all your vendors, that way you can use this as a parameter on the actual report interface.Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
|
|
|
generat a reprt basd on paramter pased SSRS2000