I need to generate report whre I take the data from Two tables but need to show in the details one by one. e.g. I have to pull the data from Purchase Order and Purchase Order History table. the data is sorted by date and It should look like -

 

Report Header

Report footer

 

The Records appearing in the Details section shown above are sorted by date and can be from any of the two tables based on date. I cannot join the two tables as that would not be helpful in above scenario. THe two tables have to be separate.

 I am using CR9

Thanks in advance!!

Detail section A - Put Purchase order

Details Section B - Put Subreport for Purchase Order History

 

But in this case isn't the report will print all the records in one section and then start printing the records from second section (i.e. from sub-report?)

Please corrct me if my consideration is wrong...

 

I need to print the mixed records from both the tables (with some own logic)....