Skip to Content
0
May 09, 2012 at 10:33 AM

Can we use UNION ALL in Crystal Reports?

946 Views

Dear All,

I sometimes use UNION ALL in SQL Queries to join the results of 2 similar queries together.

Like:

SELECT ... etc

FROM ...

WHERE ...

union all

SELECT ...

FROM ...

WHERE ...

I am writing a report in Crystal Report (for the 1st time),and incorporate SQL commands in

Crystal Reports.

I find that UNION ALL does not work.

Could anybody explain how I could do the equivalent of UNION ALL in Crystal Reports 2008 (ver 12.1.3.1028)?

Best Regards,

Leon Lai

---------------------------------

PS

If I am not following the SCN rules strictly, please be forgiving and answer my question here all the same.

I am having a very bad time finding my way in this new web site.

It will take me some time to get accustomed.

I do not even know where to award points to the experts, so if I don't award points, this is not intentional.