Suppressing certain detail lines

[hbussell]

I am working with a database that creates a distinct movement record for each admission to a program showing the admission date and a new record for a discharge from the program with the discharge date. The new discharge record does not have the admission date.

I have been able to get a listing that only shows the program code (Last record for the client) using the formula IF Client Record <> NEXT(client Record) THEN Movement>Program Code. I have also been able to print the last record program code using an ONLASTRECORD formula.

What I have not been able to do is suppress the data in the detail line where the Program code is blank. Is this possible? If so can someone help me with what I need to do?

Thanks

Harold

 

[kenhamady]

First confirm that this info is printing on the detail band of the design screen. Then go to format - section, highlight the detail section, and click the formula button next to the suppress property. Put in a formula like:


IsNull({Pcode}) or {Pcode} = &quot;&quot; Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.