December 26, 2008 at 2:08 am
I have a parameterized report created using SSRS.
How will I call the report from Visual Basic 6.0?
Please give me the details.
Thanks in advance,
Arup
December 26, 2008 at 6:11 am
You can simply pass the parameters to the report through the URL and display the results in a web browser control.
Using URL Access from a Windows Application
Passing parameters and other options directly through a URL in Reporting Services
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 26, 2008 at 2:05 pm
The bigger question is how many reports are you talking about. If it's just one or two and they aren't going to change much you can pretty much just make a simple interface to capture the parameters and pass them via the URL as stated by a previous poster.
If, however you have numerous reports with varying parameter requirements all of which you want to pass in the URL, you'll need to look at using the ReportingServices Web Service. This is pretty easy to do and implement in .Net, much more difficult to do in vb6. You'd want to lookup the GetParameters and listchildren methods to get lists of reports and the parameters associated with them. Using the above you can add or remove or change existing reports and not have to worry about changing your VB6 app.
MSDN: Calling a web service from VB6
-Luke.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply