CatNGT
December 7th, 2008, 02:52 PM
I have two transactions tables, TRAN and YTRN that contain OPEN and ARCHIVED data respectively. The fields in these two tables are, for all intensive purposes, identical. I need to be able to write reports based on data in both of these tables (eg. Sales History per Salesman) where the transactions come from both tables based on dates, etc.
I have tried subreports and other functions, but maybe I'm doing it wrong. I am using Crystal Reports 11 and the data is from SBT Pro (a foxpro based accounting system).
I have been beating my head on my desk for over a week on this one. Thanks for any help you can offer.
I have tried subreports and other functions, but maybe I'm doing it wrong. I am using Crystal Reports 11 and the data is from SBT Pro (a foxpro based accounting system).
I have been beating my head on my desk for over a week on this one. Thanks for any help you can offer.