Grouping Problem

[qlan]

Hi,

I am using V10. Under tblProjects, I have
CustomerName ProjectNum PrintVolumn
ABC 123AC 20,000

This same Project would show multiple times under the tblProjectBusinessType since it has different BusinessTypes (Development, Installtion, and Testing).

I group my report by BusinessTypes. Therefore, the report would show something like this:

Development
CustomerName ProjectNum PrintVolumn
ABC 123AC 20,000

Installtion
CustomerName ProjectNum PrintVolumn
ABC 123AC 20,000

Testing
CustomerName ProjectNum PrintVolumn
ABC 123AC 20,000

My PrintVolumn for this project now is 60,000 instead of the original 20,000. Is there a way I can do to have it show PrintVolumn as 20,000 for the first BusinessType. In this case, it would print:

Development
CustomerName ProjectNum PrintVolumn
ABC 123AC 20,000

Installtion
CustomerName ProjectNum PrintVolumn
ABC 123AC

Testing
CustomerName ProjectNum PrintVolumn
ABC 123AC


Thanks so much!

 

[synapsevampire]

Try to relate fields referenced to heading shown in the report to minimize confusion, you speak of tblProjectBusinessType, yet there's no title by that name in the data. Be consistent when referencing entities.

And are you just displaying a field for the 20,000, or is this an aggregate?

you might try right clicking it and selecting format field and in the X2 next to suppress place:

Previous({table.tblProjectBusinessType}) = {table.tblProjectBusinessType}
and
Previous({table.projectnum}) = {table.projectnum}

Then if you're showing a subtotal at the {table.tblProjectBusinessType} level, use a formula of:

minimum({table.PrintVolumn
},{table.tblProjectBusinessType})

-k