Two different tables data in one report

Question

Hi Gurus,

I need to show data from 2 different tables in a report in SSRS. These table does not have any relationship between them.

If I use two different datasets, the second dataset should have some aggregate function or atlease "First" or last. Even users dont want to go for Sub reports.

Kindly help me to resolve this issue. Your valuable responses would be greatly appreciated.

Thansk, Sengwa

 

Answer 1

Sometimes using a subreport is the best way to federate data from different data sources but there are other options, depending on your requirements.

When you say there are no relationships between the tables, you can still join records in a query for tables in different databases on the same server or by using a linked server object defined in SQL Server.  If the data is not related, you can place different data regions on a single report.

Where do these two tables reside?

How is this the data related (assuming that it is)?

---

Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com

Answer 2

As the tables have NO RELATIONSHIP and assuming that you want to show it in single tabular report, how bad will it be to cross join those tables (its really bad performancewise)  and get the data in single dataset.

Answer 3

Assuming that you have two unrelated tables

Table1: Col1, Col2, Col3

Table2: ColA, ColB, ColC

let us know how do you want to present the data in the report.

Thsi will help us in trying to get an appropriate solution matching your requirement.