cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal report summary of two running total

Former Member
0 Kudos

Hi Please help me on my report. i do have 2 groups on my report which are group1 = company group2 = DR#.

i do have a running total for maximum of number_of_box. and its working fine.

1 company can have multiple DR. showing of maximum number_of_box per DR is ok.

but i wish to summary those running fields and show it in the GF1 (company).

please help and thanks

-karlo

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Karlo,

Here's what you need to do:

1) Create a formula with this code and place this on the GH2:

WhilePrintingRecords;

numbervar gmax := gmax + Maximum({No_of_box}, {DR#_field});

"";

2) Create another formula and place this on GF1:

WhilePrintingRecords;

numbervar gmax;


3) Create one last formula and place this on GH1:


WhilePrintingRecords;

numbervar gmax := 0;


-Abhilash


Former Member
0 Kudos

Hi Sir Abhilash,

     I did what you have said but im having wrong output. i have attached my report can you help me out what could be the problem?

thanks sir

-karlo

abhilash_kumar
Active Contributor
0 Kudos

Hi Karlo,

Move the @box1 formula that is currently on GH2 to GF2.

-Abhilash

Former Member
0 Kudos

Hi Sir, Thanks for your help. i just put my reset formula in group footer 1. why did it worked?

reset must be always in headers right?

Former Member
0 Kudos

very thanks for all karlo medina !!

Former Member
0 Kudos

This message was moderated.

Answers (0)