Can I total numbers in 4 subreports for grand total for each record 1

[mvalley]

I have a report that has 4 subreport based on different clinical roles. Each subreport has a formula to show that role as a number(example: circulator field has 2 names, name field is converted to display as Maximum 2 on the report)

My manager wants the 4 roles(subreports) to total at the end of the line based on cr_urn. All subreports are displayed in the detail section of the report.

Can a formula display the total for these 4 subreports?

 

[lbass]

Why are you using four separate subreports in the detail section--this will likely be a slow report. You would have to set up a shared variable in the report footer of each subreport set to the number you want to sum in the main report, e.g.

whileprintingrecords;
shared numbervar sub1 := <yournumberfieldhere>;

Repeat for each sub. Then in the main report, in the detail_b section, add a formula like this:

whileprintingrecords;
shared numbervar sub1;
shared numbervar sub2;
shared numbervar sub3;
shared numbervar sub4;
sub1+sub2+sub3+sub4

You can format the detail_a section to "underlay following sections" so that the calculation will appear on the same line as the subs.

-LB

 

[mvalley]

Suggestion works some of the time, but doesn’t always add fields correctly.

Sub1 detail = Maximum({v_CRA_scrub.cd_seq})

Sub2 detail = Maximum({v_CRA_circulator.cd_seq})

Sub 3 detail = Maximum({v_CRA_cr_assistant.cd_seq})

Sub 4 detail = if({v_CRA_other_personnel.cr_other_personnel_role} = "2ND SCRUB")then 1 else 0

Added your formula to the sub footer
Whileprintingrecords;
Shared numbervar sub1 := Maximum({v_CRA_scrub.cd_seq})
Etc.

Added detail B as described in your post, some records added correct, but some records that should be 2 are totaling 3, records that should be 5 are totaling 6, fields totaling 2 are totaling 4 and greater. Thoughts on how to fix?

 

[lbass]

Try adding a detail_c section with the following reset formula. The section can be suppressed:

whileprintingrecords;
shared numbervar sub1 := 0;
shared numbervar sub2 := 0;
shared numbervar sub3 := 0;
shared numbervar sub4 := 0;

It may be that you have some null results which would cause the previous row value to be incorporated.

-LB

 

[mvalley]

Works GREAT!! one last request,
can I total the info for all subreports (detail b) for each day?{cr_prdate}

 

[lbass]

You haven't explained how any date fits in. Do you have a group on date?

-LB

 

[mvalley]

Yes. Group 1 is cr_prdate
Group 2 is cr_urn
All subreports share cr_urn

 

[lbass]

I don't know what you mean by cr_urn. I thought your subs were in the detail section, and that you wanted a row total for the detail section--which is what my earlier formulas would show.

If you want to total the detail level results at the date level, you would change your row total formula to:

whileprintingrecords;
shared numbervar sub1;
shared numbervar sub2;
shared numbervar sub3;
shared numbervar sub4;
numbervar rowtot := sub1+sub2+sub3+sub4;
numbervar dttot := dttot + rowtot;
rowtot

Add a new reset formula for the date group header:
whilepringtingrecords;
numbervar dttot;
if not inrepeatedgroupheader then
dttot := 0;

Add a display formula for the date group footer:
whilepringtingrecords;
numbervar dttot;

-LB

 

[mvalley]

All set. As always, thank you so much for your expertise.