how to remove default parameter in ax 2012 R2 query based report

Finance and Operations/AX Developer Forum
1

Hi all

I am not using a query based report and using no parameter to open the report how ever when i open the report it shows a default window

0121.error1.jpg
0121.error1.jpg1280×720 55.3 KB

6825.error2.jpg
6825.error2.jpg1280×720 83 KB

this issue got resolve yeasterday when i tried now throwing error messages when ever i am using my menu item button to open the report it shows error1 and error 2 is the visual studio properties

2

Sorry I am not getting any error message just that window pop’s up…

3

any help guys…

4

On your SSRS report’s dataset, when you set the property “Dynamic Filters = True”, it uses AX’s SysQuery Form like functionality.

It adds the implicit indexes when you don’t have any ranges setup on your Query I believe. Throw a breakpoint in the code that does it:

\Classes\SysQueryForm\buildRange which is called by

\Classes\SRSReportRunBuilder\populateQueryGroupControl

5

To disable those fields though just override the “showQueryValues()” method on your controller.

For more info see https://community.dynamics.com/ax/f/33/t/83017.aspx

6

Hi Rohit,

Try to override ShowQueryValues() and ShowQueryButton() method of the controller class of the report. Return false value from these method and then try to run the report using this controller class. You need to create an Action menu item and then call the controller class from this menu item. Please find the reference as well.

https://community.dynamics.com/ax/b/dynamics101trainingcenterax/archive/2014/01/30/using-controller-class-in-developing-ssrs-reports-in-microsoft-dynamics-ax-2012.aspx

I hope this will resolve your issue.

Thanks,

Vijay Solanki.