Crystal Report, Group based Summary at report footer

crystal-reports

HI,

Is it possible to display summary of a group at the report footer ? Let me explain the scenario. I've to create the following kind of report:

Client    Amount    Currency 

Customer 123:

WWWW       300         SGD
XXXX       400         SGD
YYYY       200         USD
ZZZZ       300         USD


Customer 456:

W1W1       300         SGD
X1X1       400         SGD
Y1Y1       200         USD
Z1Z1       300         USD

.
.
.
.
.

At the report footer, I need to show the following:

Grand total: USD        1000
Grand total: SGD        1400

Need to display grand total of amount by Currency at Report footer.Is it possible to do in Crystal report? I'm using crystal report version 11. Could anyone suggest me a solution ?

Best Answer

I think the only way to do this is to add a Sub Report to the footer. Use the same query as the original report and then Group everything by Currency and sum the Amount.

Related Solutions

Crystal reports shared variable in sub report not displaying in page header of main report

The problem is that while the use of WhilePrintingRecords in your second formula forces Crystal to evaluate it later than normal during the final evaluation pass, this is also when subreports are evaluated. This means that any formulas in the main report are processed relative to the subreport. In your case, the formula in the header is evaluated before the subreport in the details section, even with the WhilePrintingRecords keyword. This diagram is awesome for understanding the different passes: Multi-Pass Reporting Process.

You could try using a SQL Expression to do a simple aggregate summation for each details section. Not knowing anything about your data source or schema it's hard to give an example, but here's the general idea. You can use any valid SQL for your data source as long as it returns a scalar.

select sum(weight)
from table
where table.orderID="table"."orderID"

An alternative would be to use an additional inner grouping level per order, get rid of the subreports altogether, and use Crystal's sum() function or a global variable to get the weight per inner group.

How to add a conditional grand total in Crystal Reports

Thanx Lee, using a running total formula worked, I added following formula to the report footer,

numbervar Samples; 
if {product.sku}="card-sample" then 
   Samples := Samples + {@num_qty}; 

Samples;

Then I use this formula to calculate column 2

Best Answer

Related Solutions

Crystal reports shared variable in sub report not displaying in page header of main report

How to add a conditional grand total in Crystal Reports

Related Topic