Conditional Formatting based on Group Summary

[Ryderson]

Hi. I have a report that requires me to print the details of a group in reverse font based on a total calculation of the entire group (BACASEID). Right now it will only print correctly if each line in the detail meets the criteria but only for that one detailed line (not the entire group).

The total formula for the variable (@FedReserve) is as follows:

//check the next case to see if group has changed
if next({BaCase.BaCaseID}) <> {BaCase.BaCaseID} then

//if same group then see whether calculation meets criteria
and print it on the last line of the group
if({@CalculateAccount} - {?SecurityPledge} > 0) then
{@CalculateAccount} - {?SecurityPledge}
else
0
// I have a suppress on the formula field if 0

What I need is for the entire detail line to print in reverse font if the @FedReserve variable is > 0

Is this possible?

 

[Ryderson]

Sorry for leaving version off, cr9 for visual studio .net

Also, I'm using a dataset (populated by sql)

 

[lbass]

You need to show the content of all nested formulas.

-LB