Pass a Parameter to an SSRS Report from Dynamics GP Window

(0) Share

Report

Posted on by Community Member

I have added a button to the Sales Transaction Entry window in GP. It launches the SSRS report URL just fine. I want to pass the CustomerID as a parameter to the report and have it execute immediately as opposed to the user having to enter the Customer Number. The code is below. Is this possible? How do I set the parameter value and pass it to the report?

Thanks!

Private Sub PushButtonM233_Changed()
    Dim objExplorer

    Set objExplorer = CreateObject("InternetExplorer.Application")
    'objExplorer.Navigate "http://somewbsite/" & SalesTransactionEntry.DocumentNo & ""
    objExplorer.Navigate "uksql3.intl.lcl/.../ReportViewer.aspx" & SalesTransactionEntry.CustomerID & ""
    objExplorer.Visible = 1
End Sub

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

Obviously, I am using VBA to do this. The name of the Parameter on the SSRS report is @Customers. And that first objExplorer.Navigate line of code is commented out. Thanks!

Was this reply helpful? Yes No