Call Report from SSRS

[Scott Whetsell, A.S. - WVSP]

I am seeking guidance on being able to pass parameter data gathered from a
form and call a report available on SQL Server Reporting Services.

Front end uses Access 2003 SP3.
Back End and Report Server uses SQL Server Enterprise 2008.

Do to a reconfiguration of our network, we are moving away from Access
generated reports, but still need to be able to call reports from SSRS from
within Access as well as from the Report Server website.

 

[Mark Andrews]

You could just open a browser and pass in the correct URL to call your SSRS
report.
Build the url in code as a string.

Hopefully you can achieve what you need to by calling a URL.

Public Sub OpenWebPage(url As String)

Dim browser As Variant

Set browser = CreateObject("InternetExplorer.Application")
browser.Navigate (url)
browser.StatusBar = False
browser.Toolbar = False
browser.visible = True
browser.Resizable = True
browser.AddressBar = False


End Sub

HTH,
Mark

"Scott Whetsell, A.S. - WVSP"

 

[Scott Whetsell, A.S. - WVSP]

Mark,

Thanks for your reply. Any idea how to pass the variables for the report?

 

[Mark Andrews]

It's been a few years since I used SSRS. I did a quick search, this article
might help:
http://www.mssqltips.com/tip.asp?tip=1336

Mark

"Scott Whetsell, A.S. - WVSP"

 

[Scott Whetsell, A.S. - WVSP]

Great. Thanks Mark.

It's been a few years since I used SSRS. I did a quick search, this article
might help:
http://www.mssqltips.com/tip.asp?tip=1336

Mark

"Scott Whetsell, A.S. - WVSP"

.