How to pass parameters to custom SSRS reports activated to print from the Dynamics GP windows
Recently there was a question on the forums regarding passing parameters to custom SSRS reports assigned to Dynamics GP windows.
In Dynamics GP 2013, SSRS reports can be printed directly from Forms. Each window will pass a default set of parameters to the assigned reports.
For an example from the Customer Master the ‘Customer Number’ will be passed as a parameter. When the assigned SSRS report is selected to print, Dexterity will build the URL for the report and assign the parameter value (Customer Number) passed from the window to the SSRS Report. In the case of custom SSRS reports to have the parameter values getting passed from the Dynamics GP windows, the Parameter(s) name should exactly match with the Parameter(s) name passed from the window.
For an example: if you have a custom SSRS report which accepts SOP Number and SOP Type as a parameter. The Parameter names in the SSRS report should be SOPNUMBE and SOPTYPE for SOP Number and SOP Type respectively.
Once you specify the Parameter Names correctly, the Dexterity code will build the URL and assign the parameter values from the window.
In the next post we will see how it can be customized if we want to pass custom parameters.
Until then
Viswa
Comments
Anonymous
August 12, 2014
SSRS reports can be ran using the run report keywords in Dex?Anonymous
August 12, 2014
Hi, No SSRS reports can't be run using the "run report" keyword. In the next article I will walkthrough how SSRS reports can be called from dex using Sanscript. -ViswaAnonymous
September 02, 2014
How can one find out what Parameters are possible to pass from each window in GP for these SSRS reports. Thanks JoelAnonymous
September 02, 2014
The comment has been removed- Anonymous
October 25, 2016
Hi.I am trying to print a custom SSRS reports from the Receivings Transaction Entry. As a parameter in my SSSR report I have a parameter called poprctnm of type Text with parameter visibility set as hidden. The primary key of the POp10300 table is poprctnm.When I try run the assigned report from GP I get an error "The 'poprctnm' parameter is missing a value"Any ideas please.Thank you
- Anonymous
Anonymous
September 03, 2014
Viswa, Thanks for the response, exactly what I was looking for. Looking forward to seeing your next article. Thanks JoelAnonymous
October 23, 2014
This is really great. Thank you for writing the article.Anonymous
November 25, 2014
Blog post from Mark Polino at DynamicAccounting.net mpolino.com/.../pass-parameters-custom-ssrs-reports-activated-print-dynamics-gp-windows-developing-dynamics-gp-site-home-msdn-blogsAnonymous
March 17, 2015
Hi Viswa, Thanks for posting this. I am really curious how to pass other parameters from the GP windows (other than the defaults).