Skip to Content
0
Jan 22, 2023 at 12:48 PM

Crystal XI Union/ Merging 2 reports

103 Views Last edit Jan 25, 2023 at 10:14 PM 4 rev

Hi! I am new to crystal reports so bare with me.

I have successfully created a report that generates a pretty simple invoice based on billing information.

It includes invoice number, invoice date, due date, line items, invoice total etc.

The issue is that as of now I have to create a separate report for billed in unbilled invoices(using Sage 300 CRE as data source). The data structure of billing_unbilled and billing_billed is virtually identical, so i know there must be a way to merge these.. yet i cant quite figure it out. Sage 300 has canned that do exactly this, so i know it is possible.

I read about editing the SQL, but i dont think i can do that on the newest version of crystal reports.

Can anyone point me in the right direction? This is driving me mad..

Thanks so much in advance.