Is there a possibility to have a full outer join in SSRS datasets?

Question

Is there a possibility to have a full outer join in SSRS datasets?

noorrocks 86488

SSC Enthusiast

Points: 197
More actions
February 23, 2019 at 11:59 pm

#373910

Is there a possibility to have a full outer join in SSRS datasets?
I would like to have full outer join created b/w two datasets and would like to show in tablix

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

drew.allen SSC Guru Points: 76985 More actions · Answer 1

noorrocks 86488 - Saturday, February 23, 2019 11:58 PM
Is there a possibility to have a full outer join in SSRS datasets?
I would like to have full outer join created b/w two datasets and would like to show in tablix

Since datasets contain SQL statements and SQL statements can contain full outer joins, datasets can contain full outer joins.

I'm not aware of any joins between datasets. You should do this in the SQL portion of your dataset instead of trying to combine two separate datasets.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

noorrocks 86488 SSC Enthusiast Points: 197 More actions · Answer 2

drew.allen - Monday, February 25, 2019 1:24 PM
noorrocks 86488 - Saturday, February 23, 2019 11:58 PM
Is there a possibility to have a full outer join in SSRS datasets?
I would like to have full outer join created b/w two datasets and would like to show in tablix
Since datasets contain SQL statements and SQL statements can contain full outer joins, datasets can contain full outer joins.
I'm not aware of any joins between datasets. You should do this in the SQL portion of your dataset instead of trying to combine two separate datasets.
Drew

Hi Drew,

I am working on a fetch based report so no sql :(. Fetch doesn't support Full outer join so I have brought two datasets to the report and now looking for a way to join them together.
I tried lookup but it acts as a left join...

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 3

Since you apparently have a product limitation against full outer joins, you could try creating a view that does the full outer join for you and then report against the view.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

noorrocks 86488 SSC Enthusiast Points: 197 More actions · Answer 4

The Dixie Flatline - Wednesday, February 27, 2019 3:02 PM
Since you apparently have a product limitation against full outer joins, you could try creating a view that does the full outer join for you and then report against the view.

if product has limitation then how can I create a view. And there's no view concept in fetchXML

sgmunson SSC Guru Points: 110640 More actions · Answer 5

noorrocks 86488 - Thursday, February 28, 2019 6:59 AM
The Dixie Flatline - Wednesday, February 27, 2019 3:02 PM
Since you apparently have a product limitation against full outer joins, you could try creating a view that does the full outer join for you and then report against the view.
if product has limitation then how can I create a view. And there's no view concept in fetchXML

There's just no way around the fact that the only viable solution is to use the SQL from each existing dataset, and create a new query that uses a FULL OUTER JOIN between the two queries. Anything less just isn't going to work.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

noorrocks 86488 SSC Enthusiast Points: 197 More actions · Answer 6

noorrocks 86488

SSC Enthusiast

Points: 197

March 8, 2019 at 5:59 am

#2023930

Ok.. thanks for your reply

misskelly1020 Newbie Points: 1 More actions · Answer 7

i'm curious to know if you found a way around this? I am using MDX & need a full outer join between 2 datasets.