Supress Using Next(), Last Row Missing 1

[v45]

Using Crystal Reports XI.

A report without groups, using the Suppress (No Drill-Down) formula of:

{Patient_Clin_Tran.clinical_transaction_no} = NEXT({Patient_Clin_Tran.clinical_transaction_no})

In the Section Expert box, when the suppress checkbox is checked, the last detail row is suppressed, when the checkbox is unchecked, the last detail row is not suppressed. The last row is not a duplicate transaction number of the previous row.

Any suggestions on what might cause this? The help is not helpful.

 

[stevefah]

The checkbox is for unconditional suppression. The X+1 formula box is for conditional suppression.
If you use both you're gonna confuse the poor little Report Designer. Pick one and stick to it!

 

[lbass]

The conditional suppression formula overrides the check box--as long as it executes. Otherwise, if it doesn't execute, as in when there IS no next record, it will default to the check box condition. I would leave the box unchecked and change the conditional suppression formula to:

not onlastrecord and
{Patient_Clin_Tran.clinical_transaction_no} = NEXT({Patient_Clin_Tran.clinical_transaction_no})

-LB

 

[v45]

Very helpful, thanks.

 

[stevefah]

This is not the "official" position of Crystal Technical Support personnel. We do not endorse the idea that "the formula overrides the checkbox when executing" because this is NOT tested behaviour.
Although it appears to make sense, we haven't tested it so you do it at your own risk.

Our official position is don't do both.
Do one or the other.
I hope this helps.

 

[lbass]

This is from the Crystal Help section:

When a conditional formatting formula is set up, the formula overrides any fixed settings you have made in the Format Editor. For example, if you select the Suppress option, then set up a conditional formula for the Suppress option, the property will still apply only if the condition in the formula is met.

-LB

 

[rfoote]

Hey V45: I am looking at the same type of thing for the same ADG PsychConsult software, can we hook up and use each other as a resource.

I have been using PC for about 2 years now with data windows
and Crystal Reports.

 

[stevefah]

Thanks, lbass, for providing that cut'n'paste, but still, if you call in for support we will tell you nonetheless that we don't recommend using both.
I'll definitely pass that around, though...

 

[lbass]

To be clear, I wasn't recommending using both. I was simply explaining what would happen and why if the user did, based on my own testing.

-LB

 

[stevefah]

No problemo. Just as long as the user's not confused... V45, are you still there?
Don't be confused! Our aim is just to help, not to "one-up" each other.

 

[v45]

stevefah - I'm not confused, but you might check on the poor little report designer.

LB - Thanks for your help and research, it is working fine now.

rfoote - I have your e-mail somewhere, I'll send you a note.

Thanks again.