Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)

Interview Question :: Multiple datasets in MS SQL Server 2005 Reporting Services

I am trying to work with multiple datasets in Microsoft SQL Server 2005 Reporting Services. Is there a way to join two tables when each one is in a different dataset?

Answers to "Multiple datasets in MS SQL Server 2005 Reporting Services"

RE: Multiple datasets in MS SQL Server 2005 Reporting Services?
If you need to display information from two sources in one table, the best way is usually to have one dataset. Depending on your exact needs, you can fudge around to either make it look like one table -- two tables jammed up next to each other -- or use aggregate functions to display as a field in a table for the first dataset. For instance, if you know the rows that you are going to have in your first dataset, you could have a second dataset have different columns for the values that are going to go into those rows (for an inconvenient aggregate, for instance), and then use an if to assign the aggregates to the correct row. It's not pretty, and it is inflexible, but if it needs to be done, it can get the job done.
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)

Interview Question :: Multiple datasets in MS SQL Server 2005 Reporting Services

Top Tags