Running totals for Formulas

[pmella2000]

Hello All,

I have a report that can have single line items with multiple values. I need to sumarize these values in the footer of the report.

For example:

Serial #12345 - Annual Billing
- Loyalty
- Discretionary

Serial #4567 - Annual Billing


Summary Of VAlues: Annual Billing, Loyalty, Discretionary

TIA,

PAmela

 

[MrBillSC]

Are the three values shown above in 3 records in a detail table linked to a primary table or are they all in the same field of the same record or are they in different fields of the same record?
It makes a big difference.
MrBill

 

[synapsevampire]

What MrBill is alluding to is that you should post technical information:

Crystal version
Database/connectivity used
Example data (not an example of what the report looks like, rather the fields and their contents)
Expected output (what the report needs to look like)

Using terms like line items doesn't help either, do you mean a field, or?

If it's a field, you might use a formula to concatenate them in the details section:

stringvar MyData;
if not({table.field}}) in MyData then
MyData:=MyData+{table.field}+","

Then in the report footer you can display it:

stringvar MyData;
left(MyData,len(MyData)-1)

-k

 

[lbass]

Depending upon your fields, you might be able to use a crosstab where {table.serialno} is your row field. If Annual Billing, Loyalty, and Discretionary are different values of the same field, you could use that field as a column field, and {table.amt} as your summary field. It would probably help if you explained what fields are available and supplied some sample data.

-LB