O'Reilly logo

Microsoft Dynamics AX 2012 R3 Reporting Cookbook by Deepak Agarwal, Chhavi Aggarwal, Kamalakannan Elangovan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding filters to data regions

This recipe will use the parameters added in the previous recipe and influence the report. From the two parameters added, the Boolean type will be used to show or hide the chart data region while the string type will be used to restrict the data shown in the table data region.

How to do it…

  1. Select the CustTransPie chart data region and open its properties.
  2. In the visible property, key in the following expression. This links the first parameter to control the visibility of the data region:
    =IIF(Parameters!ShowPieChart.Value, True, False)
  3. Navigate to the Filters node of CustTransTable and create a new filter.
  4. In the new filter node, set the following properties:

    Property

    Value

    Name

    CustGroup

    Value

    =1

    Expression ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required