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"
<(E-Mail Removed)> wrote in message
news:B893810C-34AC-464F-863B-(E-Mail Removed)...
> 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,

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



"Mark Andrews" wrote:

> 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"
> <(E-Mail Removed)> wrote in message
> news:B893810C-34AC-464F-863B-(E-Mail Removed)...
> > 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.
>
> .
>

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"
<(E-Mail Removed)> wrote in message
news:84DD16C6-CAE9-4CB6-8959-(E-Mail Removed)...
> Mark,
>
> Thanks for your reply. Any idea how to pass the variables for the report?
>
>
>
> "Mark Andrews" wrote:
>
>> 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"
>> <(E-Mail Removed)> wrote in message
>> news:B893810C-34AC-464F-863B-(E-Mail Removed)...
>> > 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.
>>
>> .
>>

Great. Thanks Mark.

"Mark Andrews" wrote:

> 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"
> <(E-Mail Removed)> wrote in message
> news:84DD16C6-CAE9-4CB6-8959-(E-Mail Removed)...
> > Mark,
> >
> > Thanks for your reply. Any idea how to pass the variables for the report?
> >
> >
> >
> > "Mark Andrews" wrote:
> >
> >> 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"
> >> <(E-Mail Removed)> wrote in message
> >> news:B893810C-34AC-464F-863B-(E-Mail Removed)...
> >> > 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.
> >>
> >> .
> >>
> .
>