Using sub-reports

[RikHess]

I have just started using sub-reports in my design (RS2005).

On the whole they work fine, but on the occasions that no details are included in the sub-report, the empty line still prints.

Does anyone know how to "shrink" the line when the sub-report is empty? It "grows" just fine when there is extra text.

The example I am working with is for a Meeting Plan. Each scheduled event may have multiple-detail notes, but if an event has no notes we want to suppress the blank line.

Any help is appreciated.

 

[ousoonerjoe]

what about just doing a Hidden=IIF(RowCount > 0, FALSE, TRUE) on the row you want to 'shrink'?

--------------------------------------------------
Bluto: What? Over? Did you say "over"? Nothing is over until we decide it is! Was it over when the Germans bombed Pearl Harbor? No!
Otter: Germans?
Boon: Forget it, he's rolling.
--------------------------------------------------

 

[RikHess]

I am a little confused by your advice.

Is this a Visibility property setting for the main or sub report?

Also, is it row setting (set from clicking on the 3-bar line handle) or is it a setting for the sub-report or detail line?

I like the simplicity of the code, I just hope we can make it work.

Thank you.

 

[ousoonerjoe]

Been a while since i've had to use sub-reports, but you should be able to set the Visibilty > Hidden property using an IF statement like the one shown above.

--------------------------------------------------
Bluto: What? Over? Did you say "over"? Nothing is over until we decide it is! Was it over when the Germans bombed Pearl Harbor? No!
Otter: Germans?
Boon: Forget it, he's rolling.
--------------------------------------------------