How to pass parameters to custom SSRS reports activated to print from the Dynamics GP windows
This is a reposting of an article Viswanathan Neelakantan originally wrote on my Developing for Dynamics GP blog.
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
This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on https://www.winthropdc.com/blog.
SSRS reports can be ran using the run report keywords in Dex?
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.
-Viswa
How can one find out what Parameters are possible to pass from each window in GP for these SSRS reports.
Thanks
Joel
Hi,
Dynamics GP out of the box passes parameters related to the primary keys of the table associated with the form to the report.
If you want to pass a different set of parameters other than the default ones from the window you may need to customize the SSRS printing logic of Dynamics GP.
I will be posting an article covering that here.
Based on the filtering you have designed for the SSRS Report, you can pass any filed values from the window.
Thanks,
Viswa
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
Viswa,
Thanks for the response, exactly what I was looking for. Looking forward to seeing your next article.
Thanks
Joel
This is really great. Thank you for writing the article.
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-blogs
Hi Viswa,
Thanks for posting this. I am really curious how to pass other parameters from the GP windows (other than the defaults).