Formula's on groups?

[DeviousDi]

Hi,

I don't know if I'm going to explain this right, but I'll give it a go!

I have a report that is based on invoice number, and has various other fields such as invoice total, days outstanding, query amounts etc. The problem being is that for each query / formula / different info in a field attached to the invoice it shows as a separate line, so for one invoice I could have four lines of information.

I have tried grouping on invoice number, and the information basically comes out wrong! Formulas that I write work fine for the lines, but when grouping, because I only want one line of text, they don't.

Here's an example, as I don't think I'm coming across very clear!

Invoice No Date Amount InternalDispute StatusID

9866 24.06.13 303.30 No Open
9866 26.06.13 303.30 Yes Closed


I need to put that information into one line that I can either then query with formula, or use formula to create the information that I want.

Have I confused everyone?!

 

[Madawc]

For group data, you can put shared fields in the group header or footer, meaning you only see them once.

Or you can use a Running Total for the group, and have a detail line that is suppressed when the Running Total is more than one.

For various totals, you can set to count just once for a group, or use the group maximum or minimum.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[pmax9999]

Perhaps if you explained, based on the sample data you provided in your first post, how you want it to appear we may be able to help.

Cheere
Pete