Call Report from SSRS

  • Thread starter Thread starter Scott Whetsell, A.S. - WVSP
  • Start date Start date
S

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.
 
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"
 
Mark,

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