main report sequencing of subreport calculations

[Neil23]

I'm new to Crystal Reports, and have been thrown into the deep end of the pool.

I'm building a report which centers on a master file with several daughter files. A master record may or may not have a matching record in any daughter, so to list everything, I'm using several subreports; one for each daughter.

My problem is coordinating some of the calculations. I need to subtotal numbers from several daughters/subreports in the master, but the master is calculated before the subreports, so I'm getting zeroes. In another place, I have to divide a number in the master by a number from a subreport, but the master calculates before the subreport.

I welcome any suggestions for getting this to work. The mess to get values from the subreports back up to the master was cockamamie enough!


Thanks all,
Neil

 

[synapsevampire]

Provide examples of the tables, the data and the intent.

If these *daughter* (child?) tables only have rows which are linked to the *Master* (Parent?) table, you should be able to use a Left Outer Join to display all rows in the Master table, and any rows in the daughters that have links.

If you have daughter tables which have rows that do not link to the master, and you want to display these orphaned rows, create all subreports to have the daughter tables with a left outer to the master table.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Neil23]

Thanks, but before the current mess, I tried simply relating the several child tables to the parent with Left Outer Joins, and Crystal barfed. If there is some trick to getting it to accept several Left Outers at the same time, it sould solve my problem.