Report Parameters [AX 2012]
Updated: June 28, 2011
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
The parameters passed to the SSRS report are important in controlling how the report is processed. The following sections describe issues that you should consider when you are working with parameters for SSRS reports that are displayed in Enterprise Portal.
When you add a report to a page in Enterprise Portal, the SSRS Report Web Part will use the default values for any available parameters. However, the report may not have default values for the parameters. If you decide to use the default values, but the report does not have any defined, the report will not be displayed. Check the report definition in the Report Builder or Visual Studio to verify whether specific parameters have default values.
Before you add a report to an Enterprise Portal page, you may want to try the actual parameter values that you want to use with the report. In the Report Manager it is easier to change the parameters and then view the report that has modified parameter values.
You may want users to input the parameter values before they display the report. To do this, you can create a User Control that has fields that let the user supply the parameter values. Typically the User Control will have a button that adds the parameters to the report, and then displays the report. The User Control must have the AxReportViewer component to display the report. The report will not display until it has all of the required parameter values.
The SalesRankingReport is an example of a report in Enterprise Portal that uses this technique.
In another example of this technique, the Cash inflow vs. cash outflow report takes one optional parameter that specifies the end date for the report. In a User Control, the following markup code uses the AxReportViewer component to reference this report.
<dynamics:AxReportViewer ID="AxReportViewer1" runat="server" MenuItemName="CustCashInflowvsCashOutflow" AsyncRendering="False" />
The following markup code adds a calendar control to the User Control.
<asp:Calendar ID="Calendar1" runat="server" Caption="End Date" onselectionchanged="Calendar1_SelectionChanged"></asp:Calendar>
The following code is the Calendar1_SelectionChanged event. This event occurs when the user selects a new date from the calendar. In the event, the value of the date selected is used as the value for the P1CashInflowvsCashOutflow_EndDate parameter for the report.