SQL Server 2008 Reporting Services - Report Model (Data source view) - by mitkush

Status : 


Sign in
to vote
ID 424477 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 3/17/2009 11:52:16 AM
Access Restriction Public


Reporting services is a great tool. Report Model is the best features in the Reporting services but the biggest problem with report model (Data source view) you can use only "Inner Join". you can not use outer/full/right/left joins. 

This is a biggest drawback of the report model. I hope they will fixed this issue as hot fix. Many users and communinty complaints about that. If this issue will fix in near future then lots of new customer will like to have this product in their environment.

I am sure you heard about this issue, if not please search on google so many post out there, where you will find users and developer are not happy with this drawback.

If there is way to use outer/left/right/full join then please post a update at microsoft technet or msdn website.
Sign in to post a comment.
Posted by Microsoft on 3/23/2009 at 12:10 PM
Thanks for your feedback on this. Other customers have requested the same functionality. We are working on adding this for a future release.
Posted by mitkush on 3/17/2009 at 11:53 AM
I am sure microsfot development team will look into this request and fix or get KB article.