How to Suppress Blank Spaces...in crystal report

Question

Hi

I have designed a report with c# crystal report.
Its a accounting ledger containing debit side on left and credit on right.
The either of the debit or credit will have value and zero.
If debit has value credit will be zero in same row and viceversa.

Now i am able to suppress the fields according by checking which part is zero on which side.
My problem is if the debit side is have first two rows zero then they will get suppressed but there will be space. How can i remove that space.
Please help me out for this. Any help will be appreciated. I am giving screen shot of this please suggest me how can i suppress this space

Sunny Sharma · Answer

Hi Kedar Following steps may be help you to get the requirement: 1.go to report--> selection formulas-->record-->select n option as default values for null  that exist beside comment (//) option. 2.Write following formula: not (isnull({Customer.Address2})) (formula will give you data that has no null values.) 3.Now insert you chart into the reportyou will get chart without spaces. Resolution2: 1.You must get your data to the report without null by using add command(free hand sql) 2.you insert the chart.you will get chat without spaces. Taken from here Hope it helps :)