This is one of those topics that always seem to confuse me. I've got notes saying I should do something like this:
http://ourreportmanagerserver/Reports/Pages/Pharmacy+Inventory+Reports&InvoiceByInventoryOutID=28512
and I've also got notes that specify this:
http://ourreportmanagerserver/ReportServer?/Pharmacy+Inventory+Reports&InvoiceByInventoryOutID=28512
Now, to complicate things further, I've made a selection report, so that a user, if they user the Report Manager server, can select a InvoiceByInventoryOutID value from a list of values. Looking at that URL I've got this:
That ExecID=(etc.) is very complicated. I've no idea at all how that's being generated. And we need to know, if that's the correct syntax. The issue is that this report must be launchable from a Microsoft Access app. So, the user will select an invoice, click on a button, and it goes to the Report Manager website to bring up the report in the user's browser.
So, how is it done correctly?
Kindest Regards, Rod Connect with me on LinkedIn.
August 1, 2020 at 4:16 pm
I would start here:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 2, 2020 at 2:25 pm
I believe that, down the road, we'll be able to do that as we bring the new, replacement app online. But given how slowly we move at getting something in place, I'm sure that new app won't be in place until next year sometime. The user's need the report much sooner, so they still need it available as a launch from the MS Access app. It's because of the need to launch the report from the SSRS Report Manager website, that I need the correct format for the SSRS querystring.
Kindest Regards, Rod Connect with me on LinkedIn.
There are ways to add code to an Access database that call out to .NET code - which is why I would start there...if you can instantiate the report viewer from code in Access then it is just a matter of setting and passing parameters to that code.
If you just want to setup a link: https://docs.microsoft.com/en-us/sql/reporting-services/url-access-ssrs?view=sql-server-ver15 and from there you can get to this: https://docs.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url?view=sql-server-ver15
As for your second example - the URL is encoded to prevent viewing of the passed parameters. That is expected, but when you build the link to call the URL you use the format specified in the above documents. You should also be aware of the prefix commands: https://docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-server-ver15
With those you can control how the report is rendered - what toolbars are available, headers, etc...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply