Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Union Query Crystal Reports 8.5 Post Reply Post New Topic
Author Message
John2Chr
Newbie
Newbie
Avatar

Joined: 11 Apr 2012
Online Status: Offline
Posts: 10
Quote John2Chr Replybullet Topic: Union Query Crystal Reports 8.5
     Posted: 22 Mar 2013 at 9:14am
I haven't used union queries in crystal 8.5 and am wondering if this is possible.  I tried putting in the record selection formula editor and had the tables fields selected but the union wouldn't turn blue.  Could someone point me to a step by step setting up union query with crystal 8.5?
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 25 Mar 2013 at 10:13pm
Hi

Union or Union All are not crystal syntex, these are used to join two select queries.

There is a union function in crystal but it works for only OLAP.

You need to use these at Add command level to join two queries.

You may get more help on database online help
Thanks,
Sastry
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum