Union In SSRS , SQL Reporting Services

Gabe Lebron
Gabe Lebron used Ask the Experts™
on
I have a question on unions for SSRS .. I can do them on access not sure how to on SSRS.  Can someone point me in the right dircetion?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Not exactly what you are looking for, but this should help - http://forums.asp.net/t/1152551.aspx
The answer is yes you can.

SSRS passes the SQL to SQL Server to evaluate it.  
Senior Database Architect
Commented:
This is the general format, the number of columns must be the same and the datatypes must be implicitly compatable (can't union numbers to text and such)

Select Col1, Col2, Col3
From Table1
Union
Select ColA, ColB, ColC
From Table2

Author

Commented:
I will try this out.. will let you know  

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial