Hi all
I've got a question and after many attempts at googling, I can find any solutions to this. I've got two queries relating to two different entity data sets. There is no relationship between the two entities (no 1:N, N:1 or N:N relationships) but I've set the fields in each entity to match each other exactly.
What I want to do is bring those two datasets into an SSRS report via Microsoft Visual Studio but I don't want to have it as two different tables but have one overlay their data on top of the other in a union of sorts in 1 table. This is so that we can then sort or group both datasets in a single table. As an example the two queries I've got contain:
Query 1 - Entity 1
Entity 1-name field Entity 1-Subject field Entity 1-Organisation Lookup field
Name value 1 Subject value 1 Organisation lookupvalue 1
Query 2 - Entity 2
Entity 2-name field Entity -Subject field Entity 2-Organisation Lookup field
Name value 2 Subject value 2 Organisation lookupvalue 2
I want to merge/append the two datasets together in SSRS so that it produces a single table via SSRS so the final output in SSRS will be:
Combined-Name field Combined-Subject field Combined-Organisation Lookup field
Name value 1 Subject value 1 Organisation lookupvalue 1
Name value 2 Subject value 2 Organisation lookupvalue 2
As noted there isn't a entity relationship link between the two and I simply need to append/overlay one on top of each other so that I can do a row grouping on a single table as opposed to two.
I understand Fetch does not allow unions and some of the outer join solutions listed require a connecting data point. Is there a easy way of doing this.
Any help will be greatly appreciated and thanks in advanced!
Kind regards,
Mike
