SSRS Report business logic with Report Data Provider class as Data Source type with same table dataset.

(0) Share

Report

Posted on by Community Member

Is it possible to create more than one report under the same project node in visual studio by using 1 Report data provider class as the data source and 1 table dataset? There are business logic that we need to implement.

1. There is a form and on the form there is this logic that must follow.

If Employee type A is picked from a drop down list then only show section 1 and 2 of the form will be displayed and so forth and so on. We've implemented this logic by overriding init and initDesign(switch case statement) method on the form. Main goal of implementing this logic is so that only necessary fields are shown on the form since there are lots of fields on the form.

2. Our requirement is to follow this exact logic on the SSRS report.

3. I'm not so how to implement this logic by create 1 SSRS report so I'm thinking about create 3 reports but with one class.

Any thoughts/suggestions/example within AX or any links that I can research on would be greatly appreciated.

Running AX 2012 R2. Created customized project.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Is it possible to create more than one report under the same project node in visual studio by using 1 Report data provider class as the data source and 1 table dataset?

yes its possible to create more than one reports under same model project

Its also possible to use same class for multiple reports but in every report you have to go and select it.

1. There is a form and on the form there is this logic that must follow.

The same logic of form you can apply on SSRS Reports by hiding textboxes, rectangles or tablix using expressions

Notes:

SSRS reports are lacking at few places. Sometimes if you hide an area by using expression, it results in wastage of space, as area is hided by space is not utilized. instead it remains empty and unused

How you are managing Employee Type??? if there is any field which defines the type of employee, you can also use another approach which is as under

Create One report.

Add 3 design for same single report (No need to re-add dataSources or DP Class)

Now as user clicks to open report open a different design of same report using if condition

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sohaib,

Thanks for your kind guidance. Actually your second approach sounds like a better fit for our requirement.

1. Created a report with DP class & table dataset along with precision design.

2. Issue I'm having is I'm not sure as to where to place "if then condition". Where would I write this method?

3. Under report properties, there are ways to add references. Is this how I would add class name and instance name for the "if then conditional logic"?

Thanks again!

Was this reply helpful? Yes No
Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please have a look on the document attached on this blog post to get idea about RDP classes and how to use them in report development, syedbaber.wordpress.com/.../reports-development-for-dynamics-ax-2012

There can be different ways to hide/show your controls on report design. Either you can control is in you RDP class logic in X++ by using temp table fields OR you can set expressions on each text box on report design which you want to hide/show based on parameters or field values.

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

2. Issue I'm having is I'm not sure as to where to place "if then condition". Where would I write this method?

A SSRS report consists of different elements like tablix, textbox, rectangle etc. to hide or show any element on report, all we need to do is to right click that specific element and go to its properties, set show/hide or hideen property by expression

https://msdn.microsoft.com/en-us/library/dd220590.aspx

http://www.sqlchick.com/entries/2010/12/21/visibility-settings-in-ssrs-drill-down-to-showhide-report-da.html

3. Under report properties, there are ways to add references. Is this how I would add class name and instance name for the "if then conditional logic"?

No need to add any references to show/hide elements

Was this reply helpful? Yes No
Abhishek_mishra 405 on at

Like (0)

Report
Copy link

Link copied!

You could try create separate tables (In SSRS design) for each section and display them passed on parameters. Apply hidden expression at table level rather than table cells/rows.This way hidden tables will not occupy space.

Was this reply helpful? Yes No