Is it possible to create a union query within Crystal reports?

[shabbaranks]

Hi,

I currently have 2 separate crystal reports which I would like to join as one. Can I create a Union query within crystal as I can within Access or is there a better method to achieve joining the two?

Thanks

 

[kevlray]

If you know how to create a command (Crystal Reports 9 and above), then you should be able to create a union query.

 

[shabbaranks]

Thanks yeah I managed to get it going - forgot to close this post.