processing data in subreport

[atarrqis]

Oracle and CR 11
The main report has group 1 = Project, group 2 = Part No
Records show on group 2 footer as Part No, Units Complete, etc.
The subreport is in group1 footer linked by Project and Part No
The subreport has sub-group 1 = Part No, sub-group 2 = Dept
Records show on sub-group 2 footer as Part No, Actuals, Current, Std Cost, etc.
Like:
Project XYZ
Part A, 12
Part B, 20
Part C, 2

Part A Actuals Current Std Cost
Dept 2 22 1
Dept 3 12 0
Part B
Dept 2 2 5
Dept 5 7
Part C
Dept 4 2 6 2
Dept 5 1 3

This looks close but it is not consistent. All Part Nos appear on the subreport but data for some columns on the subreport only appear for the last part no (Part C).
For instance there is data in the 3rd column (Std Cost) for all parts but it only appears on the last part - yet other data appears correct.

If I preview the subreport by itself I get the Std Cost on the first Part No (Part A) only.
I assume I need some sort of While...formula or something but I don't know where. ??

 

[Madawc]

I'm unclear what you're asking. But obvious points to check are:

a) Did you generate unwanted tests on the subreport when passing values to it? Mostly it creates a rule when you add a field, and you may have to edit this in the subreport record selection

b) When you link A to B to C, if C is missing you will get nothing unless you use Left Outer for the B to C link.

c) If you have Left Outer, you will negate it if you do a test on C, unless you first check for nulls. NULLS stop everything without warning.

d) If all else fails, show the data without selection and check if it is maybe different from what you thought it was.



Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[atarrqis]

Sorry, but your response is as unclear to me as I apparently was to you.
My subreport is on the footer of the top group so I am passing a Project with multiple Part Nos
On the subreport it has to process formulas for each Dept within each Part No for that one Project.
It does not do this consistently so I thought maybe it has something to do with the timing of how it receives the multiple Part Nos from the main report and how it processes the formulas on the subreport.
I'll keep working on it.

 

[atarrqis]

I figured out my problem with the incosistent column data but I'm only getting the last part no from the main report into the subreport instead of all part nos for the project. I don't normally need to put the subreport in the top group (Project) but in this case I need the subreport to print after all of the data in the main report.

 

[atarrqis]

Never mind, I read a post from LBASS for a different user and as usual, LBASS was extremely helpful. I changed my subreport and it works well.