how to summarize a maximize group totals 1

[hex6007]

im making a daily collection report of clients group per product.wherein, there are clients with more than 1 product.

Collection Date: August 15, 2008

Client Product Prin Due TotalPayment

Group A
Jorge B. XL 100 50 150.00
YL 100 100.00
Debbie G. XL 100 50 150.00
--------------------------------------------
Group Total 400.00
--------------------------------------------
Group B
Ana Y. WL 100 50 150.00
ZL 100 100.00
Herman D. XL 100 50 150.00
--------------------------------------------
Group Total 400.00
--------------------------------------------
Grand Total 800.00
============================================

hence:

Priority per Product
WL
XL
YL
ZL
- the Due will be only added to Prin based on product they have per priority set.

Problem:
1.how will i set the priority per product?

 

[dgillz]

This takes 2 formulas, in the group footer:

WhilePrintingRecords;
Numbervar Maxtot:=Maxtot+Maximum({YourField},{YourGroup});

In the report footer to display the sum of maximums:

WhilePrintingRecords;
Numbervar Maxtot;

You need to replace {YourField} and {YourGroup} with real field names of course, and you'll probably want to suppress the first formula.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[hex6007]

hi dgillz,

WhilePrintingRecords;
Numbervar Maxtot:=Maxtot+Maximum({YourField},{YourGroup});
-On this formula on the group total the result is = BOOLEAN


- While on the footer the result is = 0
WhilePrintingRecords;
Numbervar Maxtot;

can you please help?

 

[dgillz]

Did you notice the colon equals := and not just an equals?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[hex6007]

hi dgillz,

sorry i didnt. but i now changed it error says "A number is required here"

 

[hex6007]

hi dgillz,

does it matter on how i made the priority per product. coz i used a running total on determining the the priority of the product?

i set a value per product. where 1,2,3,4,and 5 as to product WL,XL,YL,and ZL respectively. then i use the running total to do the loop:
field to summarize = {PerProduct}
type of summary = count
evaluate
on change of groupp = {PerProduct}
reset
on change of groupp = {PerClient}

this is how i do the loop. any suggestions on this? although i wanted to do the do..loop if possible can you help pls...

best

 

[dgillz]

A running total would work, but that is not the path I suggested. Which of these are you using, running total or variables?

Please show a sample of your desired output.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[hex6007]

Hi dgillz,

Name Product Payment Dues TotalPymt
Rhodora Dayon General 202.80 50.00 252.80
Special 202.80 202.80
Trinidad Abayon General 202.80 50.00 252.80
Letecia Singson Special 202.80 50.00 252.80
Irene Dao Asset 202.80 50.00 252.80
Merlita Chiu General 202.80 50.00 252.80

Thats the sample output i wanted to be and i wanted to us ethe variables instead. please help.

thanks in advance.

 

[dgillz]

It is not clear from your sample what data is being summarized. Please elaborate.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?