AX2012 SSRS Reports

masina.kishore · February 23, 2012, 11:21am

Hi Friends,

How to filter the data in SSRS?

I add CustTable Query in VisualStudio Report DataSet.I want to display data based on Account numbers

raj.verma · February 23, 2012, 11:28am

Hello Kishore,

You can do it in two ways.

Add Accountnum field into range node in AX query
You can also add parameter in visual studio in parameter node .

masina.kishore · February 23, 2012, 11:34am

Hi Rajkumar,

How to add parameter in visual studio?

I try to add but i confused to set the properties in parameter

Regards,

Kishore

raj.verma · February 23, 2012, 11:57am

Hello Kishore,

First go to the parameter node and click Add new parameter and rename it then go to values in the properties then click fromdataset and choose a dataset and into data field select Accountnum. After that u have to add a filter also go to the filter node in the design and add a filter here u can see 4 properties in the expression select AccountNum and in the value property select parameter which u add early for AccountNum u can find it at last in the dropdown of value property.

hope it will help.

masina.kishore · February 23, 2012, 12:23pm

Hi Rajkumar,

Thanks a lot for giving replay.it is very helpful for me.