Joining two Views and Missed DisplayMethods of their Datasources

(0) Share

Report

Posted on by Community Member

I am trying to create a SSRS report. For that, I needed a Query which I have built by joining two different views and created a combined view. Now the problem is that all display methods belonging to the child views are not accessible now and can not be selected.

However, If I use just a single view as my Report's Datasource then its Datasources' display methods would appear as depicted in the figures.

1447.view.PNG

4162.View2.PNG

Is there anything I can do to have the Display Methods back?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Joining two Views and Missed DisplayMethods of their Datasources

One possible solution is to recreate the display methods as computed columns for your combined view if they do not contain any special business logic, so for SSRS they would look like as regular fields.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Joining two Views and Missed DisplayMethods of their Datasources

They are really difficult to recreate. most of them have huge dependancy on other tables.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Joining two Views and Missed DisplayMethods of their Datasources

I do not have AX in front of me right now, but maybe you could try to drag the display method to the Views' field list and see if that works. I remember that with regular tables, you could add display methods to Field groups and they would be automatically shown on the forms.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Joining two Views and Missed DisplayMethods of their Datasources

Unfortunatly it doesn't work this way :(

Was this reply helpful? Yes No
Suggested answer

Rachit 4,015 User Group Leader on at

Like (0)

Report

RE: Joining two Views and Missed DisplayMethods of their Datasources

If you cant create computed columns then you may need to take a different approach of using a data provider class for your report.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Joining two Views and Missed DisplayMethods of their Datasources

As mentioned by Rachit, if the above tip did not work, then your only option is to either recreate the methods, use computed columns, or work your way around by using a Data Provider class, where you add the two views' contents to a single Tmp table.

Can you please make sure you tick the checkboxes for helpful answers next to each post, so the topic gets resolved? Thank you.

Was this reply helpful? Yes No