Share
ReportI need to call a custom SSRS report on click event of a print button in GP, (and also send parameters if possible). How can we do that?
*This post is locked for comments
You’re offline. This is a read only version of the page.
3,208
I need to call a custom SSRS report on click event of a print button in GP, (and also send parameters if possible). How can we do that?
*This post is locked for comments
Hello.
I am launching this report directly from a button on the Sales Transaction Entry window. The report launches but the parameter is not passed in and the report does not execute.
Can someone reply with the block of code where they were successfully able to accomplish this? Thanks again.
Private Sub PushButtonM233_Changed()
Dim objExplorer
Set objExplorer = CreateObject("InternetExplorer.Application")
objExplorer.Navigate "uksql3.intl.lcl/.../Report.aspx;rs:Command=Render&Customers=00001 "
objExplorer.Visible = 1
End Sub
Thank you (Victoria and Tim) for your responses.
I would definitely consider it if we ever have multiple custom reports.
Thank you Tim, your solution gave me an idea which resolved my issue.
The solution we needed was just for one single scenario and the purpose was just to display some additional calculated information from the data.
So we just used the win form-report viewer instead of IE window to run the report.
It also allowed me to pass the parameters.
Victoria's answer is the best way to accomplish what you want.
I have used VBA to run a custom report rather than a report writer report.
The problems with doing this are many and in certain cases you could damage data (think Posting Reports when you Cancel the Report Writer report).
In VBA, you prepare an Internet Explorer window (you need to include a reference in your project), build the URL with or without parameters, submit the URL to the IE window and show the IE window.
Tim
Hi Zain,
We have an add-on product for Dynamics GP called GP Reports Viewer that will do exactly this. Here is more information on it:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (