How to pass parameters to custom SSRS reports activated to print from the Dynamics GP windows

Viswanathan Neelakantan - Click for blog homepageRecently 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