print statement based on activity 1

[amoeba102]

Crystal Reports XI

I am creating statements for lastfullmonth (CR function).

I only want to print them for accounts that meet both of two criteria- 1. zero balance forward. 2. No activity during lastfullmonth.

I am getting the balance forward info via a view in a group just below the header, then I do groupings and the current activity is in the detail, with the new balance in a group footer.

I can get those with no bal. fwd. by suppression of all groups based on the formula for Bal fwd, because it is in the first group. But I'm at a loss as to how to suppress the statement on current activity seeing that I haven't checked for it yet.

 

[synapsevampire]

OK, when you say print, I guess that means display.

Rather than psoting text descriptions, you'll be better served to state the fields and the data within.

If the second row is always 2. No activity during lastfullmonth, then you can set the suppression using the next() function.

So the formula might read:

not(
{table.field} = 1
and
next({table.field}) = 2
)

If not, then try creating a formula of:

//@2exists
if {table.field} = "2. No activity during lastfullmonth" then
1
else
0

Now you can test using:
sum({@2exists},{table.group}) > 0

One of these should resolve.

-k