How to suppress empty or blank rows in report

[Former Member]

How to suppress empty or blank rows in report. I already have a Suppress Blank Section property set on the Detail section,

but still i see the blank rows in report.

How can i suppress these rows.

The version that I am using is 11.5.11.1470.

Thanks in advance.

[Former Member]

If I check for each field, if its not null and not empty and not ="" etc, then seems like its working.

Thanks All.

[former_member292966]

Hi Deepak,

Are you sure the blank lines are coming from the Detail section? If you hide the detail section, do you still see the lines?

Do you have subreports in your report? An empty subreport will also generate a line unless the section it's in is suppressed or hidden.

Are you previewing the report in Crystal or exporting? Exporting to something luke Excel is very tricky if the fields and lines are not lined up properly.

Good luck,

Brian

[Former Member]

Hi Brian,

I have a simple report with just detail section, No sub reports, no groups. I am previewing in crystal.

How the report shows up is:- (for example, below there are empty rows between ID 101 and 103, also empty rows between 103 and 108).

If the whole row is empty then i want to suppress the row.

ID Count1 count2

-

---

-

---

-

---

101

103 10030 100040

108 100050

Thanks,

Deepak P

[former_member292966]

Hi Deepak,

A report that simple should be able to do that.

Try a couple of things:

1) Go to File | Report Options and put a check mark in Convert Database NULL values to Default and Convert OTHER NULL values to Default.

2) Just have these three fields in the Detail section. No text boxes or formulas. Remove any formatting you may have set for the fields.

Do either of these options work?

Good luck,

Brian

[Former Member]

Brian,

Sorry, Both the options didnt work.

One more thing, right now I am viewing the data in crystal but products allow the user to save it in Crysta/PDF/Excel format as well. I feel that the Report option changes will not work since its actually not changing the data within the report right.

And when user saves it to PDF/excel, then still we can see empty or blank rows.

Thanks,

Deepak P

[Former Member]

Try creating a simple formula, just to see if Item one is showing up as a null.

If it does, then do the same thing for Item two and item three.

If your formula works for all three items, then you should be able to suppress the section

using the same logic. or maybe something like this.

Use this in the supression section.

if {item 1} = true and if {item 2} = true and if {item 3} = true then true, else false

I was unable to test, because my db's do not have true null fields. they have blanks, but not nulls.