how to disappear the sub Report if the values are null from db..

[Former Member]

hi.

i have one requirement ie.

i put two sub reports at report footer section..

sub report values are coming from the data base

Some times  there is no values in data base at sub report two

plz have a look on below image..it becomes empty.

can i disappear the sub report if there is no values..

I need your valuable suggestions..

[former_member203168 · Accepted solution]

Hi

In your sub reports, you also have to suppress the values (report labels,headings etc) using a formula.

Go in Report Menu--Section Expert--Suppress -- Formula editor and write the follwoing :

if Count({Yoursubreportfield)}) > 0 then false else true

This will suppress your headers and footers or any other secitons which has static information.

Now in the main report go in section expert and check 'Suppress Blank Sections'

Also check you have applied New Page before or After for any of your sections.

--Praveen G