Supress Blank subreport

[maggi]

I have a subreport in my Group footer 3. If a subreport is empty it displays a blank page. I went to Format Subreport -> Subreport tab -> Supress Blank Subreport. But that doesn't seem to do anything. How should I fix this?

Thanks

 

[jdemmi]

Try also checking "supress blank section" in the section expert

-- Jason
"It's Just Ones and Zeros

 

[kskid]

Edit the subreport and then Click on File->Report Options and check "Suppress Printing if no records"

-lw

 

[maggi]

Checked all the above options but still no luck.

 

[jdemmi]

Are you sure there is not any data in the sub?

Page #, line, date, etc

-- Jason
"It's Just Ones and Zeros

 

[maggi]

No there is nothing. The only thing is that I have subreport displayed for every Region. For example, my report is grouped on region. So it finds Region1 and displays the data in the subreport for that region1 on the next page and then moves on to Region2 and does the same thing. Right now if there are no records for Region1, it will display an empty page and move to Region2.

 

[jdemmi]

I assume that there is data in the subreport for the other regions? If this is the case I THINK you will need to conditionally suppress the subreport based on the group data.

-- Jason
"It's Just Ones and Zeros

 

[maggi]

Yes there is. How can I conditionally suppress?

 

[Madawc]

Right-click on a section and choose Section Expert. Then choose the formula icon (x+2 and a pencil) for suppression. Enter a formula; e.g.
{AccNo} = Previous({AccNo}) and {changeflag} <> "Y"
This would mean that only one instance of the account is shown unless the flag was set for a second case etc.

It's best to give your Crystal version.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Within the subreport, go to the section expert->sections that are displayed->suppress->x+2 and enter:

isnull({table.region})

You should also have "suppress blank section" checked on these sections. Use this in conjunction with "suppress blank subreport".

-LB

 

[maggi]

lbass, I did as above and I dont see my subreport border now. But I still have the empty page.

 

[maggi]

Nevermind, it works. Thanks!