How to create Advanced Filtering on SSRS reports

(0) Share

Report

Posted on by nadiah sukerman

Hi, this is my first time to create an Advanced Filtering, the filtering screen same like when we're printing the view form, example as attached below. Usually I'm using Controller Contract UIBuilder and DP class and the screen was just like the left side. Now I want to add another thing like Select button, then go to the right screen advanced filtering. so we can select and filter. Is there anyone could give me some guidance and process how to create it?

3554.filter.PNG

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Sefa Duman 1,167 on at

Like (0)

Report

RE: How to create Advanced Filtering on SSRS reports

Hi Nadiah,

Advenced filtering is provided via "Dynamic Parameter". If you develop a report based on AOT Query, you can easily add a range to any data source you want. You should select "True" in "Dynamic Filters" property for your dataset in Visual Studio SSRS project. So that you will have Dynamic Parameter on your SSRS report.

You can refer for Dynamics Parameter in AX from links below:

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/how-to-define-a-report-with-dynamic-filters

https://dynamicsaxinsight.wordpress.com/2014/12/08/ax-2012-add-report-parameter-to-ssrs-query-report/

Best regards,

Sefa Duman.

Was this reply helpful? Yes No