Page header Section of report 1

[wgg]

Page header Section of report
bfw total: 300.00
current day total:200.00
Grand total :500.00

Detail section of report
amount($)

today 100.00

today 100.00



records in the table
date amount

date 1 100.00

date 2 200.00

today 100.00

today 100.00

Hi all
I am trying to get the above senario replicated in crystal reports 8.0. The brought forward total is a summary of date 1 and date 2 amounts (i.e. 300.00). Today's total is a summary of the today's date totals (i.e. 200.00). The bfw total, the today's total and the grand total have to be placed in the page header section. However the detail section must have the individual records for today. I am getting trouble getting the bfw total when using a filter condition for the today's transaction. How is it possible to produce this type of report? If I am not clear I will be glad to try explaining some more. Thank you

wgg

 

[kenhamady]

You have to select all of the records, but only display the ones that you want to see. You use the invisible (suppressed) details to do your calculations.

YOu do that by using conditional totals, which are described in my FAQ on common formulas. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[wgg]

Hello Ken

Thanks for your suggestion, I am giving it a try right away.

WGG

 

[wgg]

I got the detail section to work using the invisible (suppressed) details. However I am not getting the formula to work for the brought forward total and the current day total in the header section.

I am using conditional totals for the bfw total:
i.e.
if {processdate} < {?TransactionDate} then
sum({amount})
else
0

and I am using conditional totals for the current day total:
i.e.
if {processdate} = {?TransactionDate} then
sum({amount})
else
0

I am missing out something? Please help. Thanks.

WGG



bfw total: 300.00
current day total:200.00
Grand total :500.00

 

[kenhamady]

Yes, you can't do the sum in the formula. It takes two separate steps. Fist use this formula without the sum:

if {processdate} < {?TransactionDate}
then {amount}
else 0

Save this formula, and add a grand total of this column. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[wgg]

Ken

Thank you for your assistance, that worked fine. My 3 totals are in the report footer.

Sorry to be a bother, Is there anyway that I can get the 3 totals in the page header. The grand total solution works but the totals only show in the report footer. If there is no way around this, I will tell the users that the report has to be printed with the totals to the bottom.

WGG

 

[kenhamady]

They can be moved to the Report Header. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[wgg]

Ken

It worked!!

Thanks a million. I certainly appreciate your assistance.

wgg