Asked by:
Can more than 1 View be used to create DSV in SSRS Report Model

-
Hi
Please let me know if there is a possibilty to use more than 1 view while creating the DATA SOURCE VIEW in Report Model.
Actually when i added data from 2 views the report data does not get populated if fields from both the views are added. Instead if the fields from a single view is selected the report is showing correct data. Could you please explain this.
Thanks
Ajit
Question
All replies
-
Hi Ajit,
Thank you for your question.
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.Thank you for your understanding and support.
Thanks,
Alisa Tang -
-
Hello Ajit,
To answer your question, you cant use more than 1 view while creating the DATA SOURCE VIEW in Report Model.
The relationship's can be defined only within the objects in the Data Source View.
Having said that, Report models are deprecated with SQL 2012 and this will not be supported in future versions.
Please refer http://technet.microsoft.com/en-us/library/ms143509.aspx for more details.
Regards
Durai Murugan
-
Hi Durai,
I used 2 views in my DSV and defined logical primary keys on both the views.After done that I set up the relationship between the views based on a identical coloumn name and it worked in the report Model.
Please let me know if my understanding is incorrect.
Thanks
Ajit
-