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 SharmaPosted Oct 14, 2013, 1:45 AM
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 report,you 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 :)