Custom SSRS query parameter dialog without RDP class

(0) Share

Report

Posted on by Greg's Mom

Hello all!

Is it possible to create a custom SSRS query parameter dialog in AX 2012 without creating the report data provider class? The SSRS report that I've created pulls data from an AX query and works perfectly with the exception that I need to create a custom lookup for one of my report parameters. The report parameter is working correctly but I need to apply some custom filtering on the parameter that I can't get simply through the extended data type relation.

I'd like to avoid creating the report data provider class because I don't need to modify the way the report fetches the data, I just need to modify the way the parameter form is generated. Is it possible to just create a new UI for the report parameters with custom lookups without creating the data provider class? If so, could anyone point me in the direction of a native AX report that is doing that or give me some idea how it can be done?

I highly appreciate any input on this!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

if you add range to the Query using which report is developed then automatically Report Dialog Box with parameters will appear, you dont have to do any thing.

Add Range to AX query

Refresh the Query in SSRS report deginer

and run the report.

Please verify and update if you need any technical support related to this.

Was this reply helpful? Yes No
Verified answer

Greg's Mom on at

Like (0)

Report

Thank you for your reply, Nitesh. I should have been more specific. In this case I need to create a custom lookup on the report parameters window and unfortunately the standard query range filter won't work in this case. The lookup that I need to display on the report parameters window needs ot have special filtering capabilities as defined in my requirements that are not available via the standard query range filter.

I believe I found the solution to this is to create a class that extends the SRSReportDataContractUIBuilder class and handle the user interface here. When I posted this question, my research had led me to believe that I also needed to create a data provider class in conjuction iwth the UIBuilder class. I wanted to avoid creating the data provider class as my report already fetches the data correctly, it simply needs a different interface for prompting the user for parameters. After searching more, it looks like I can just create the UI Builder, Data Contract, and Controller classes and pass my custom parameters to the report query.

I have not implemented this yet so I will report back and confirm once I have completed it.

Was this reply helpful? Yes No
Brandt Fundak 2,007 on at

Like (0)

Report

Brawndo,

This is precisely how SSRS Reporting in AX 2012 is supposed to work and in my opinion is a much more elegant way of handling reporting than in AX2009. Since reporting in AX 2012 takes on a more traditional Model-View-Controller model, my understanding is that the parent classes (SRSReportRunController, SRSReportDataContract, SRSReportDataContractUIBuilder) will always run when you run an SSRS report and you should only override them when you need to. In your scenario, you may only need to override the UIBuilder class, although given what you are trying to do, there is probably validation logic that you will need to override the DataContract as well.

Brandt

Was this reply helpful? Yes No
Evan Adamson 105 on at

Like (0)

Report

Hi Brawndo, I have a very similar requirement. Were you able to implement this the way you suggested?

Was this reply helpful? Yes No