Can Crystal Report merge two datasets together?

[Tianjin]

Hi

I have two datasets, one is from PO and the other one is MO. I would like to Merge these two datasets together with their common fields (Id, Item, Date) and sort merged list by date. I wonder if crystal can manipulate this type of operation.

Thanks

tianjin

 

[Turkbear]

Hi,
If you can access the datasets within crystal then link them by those common fields. You will then have all the fields available and can work on sorting/grouping/displaying them.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[IdoMillet]

Use a Command (or View or Stored Procedure) as a data source and a UNION ALL sql statement to merge the data from the two SELECT statements.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com