Hi,
I am wondering if anyone can help me regarding suppress issue in crystal report XI?
I have few rows in report headers in following format:
------------------------------------
Contact Name
Address1
Address 2
Address 3
PostCode
-----------------------------------
I don't want to display row if its NULL or Blank.
I have tried following solution which was provided on one of the crystal report post but its not working and report is still showing Blank Line b/w addresses if address Field is NULL.
-----------------------------------------------
1. Put it in the "Suppress(No drill Down)" formula box area. I should have made that clear on the first post and I assumed that was where you were putting it. Sorry about that.
2. Make sure the check box next to the Suppress(No Drill Down) is NOT checked. If it is checked it will suppress all of your detail records not just the empty ones based on the formula you just put in.
3. Take any formula out of the Suppress Blank section, you can still check the box but it should not have any effect because as you state "oh, there is something there, I cannot suppres it".
-------------------------------------------------
Thanks