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.