Suppress Detail?

[Sonja A]

I have tried that as well. The problem is that if there are no tasks, the Objective will not show up. I just tried it again to make sure - I have one report, the Objectives are in the detail section and the task are a subreport in the detail section as well - if there are no tasks, the objective does not show up.

 

[RichMorrison]

You wrote
<<
I have one report, the Objectives are in the detail section and the task are a subreport in the detail section as well - if there are no tasks, the objective does not show up.
>>

As they say at Microsoft tech support; "it works fine here".

I just retested a report with main and subreport components and the main report detail does print when the subreport is empty.

Are you trying to use THE SAME QUERY for the main and sub reports? If yes, that won't work.

RichM

 

[Sonja A]

Rich,
Thanks, that worked, I had the task table in the overall query and removed it - now everything I want to show up does.
However, when there are not tasks, there is a blank space on the report for where the task would normally appear. Any way to have the subreport be invisible when no tasks are there?
I cannot say if task_ID is null then subreport is invisible because taks_ID is at the subreport level.

 

[RichMorrison]

you wrote
<<
However, when there are not tasks, there is a blank space on the report for where the task would normally appear. Any way to have the subreport be invisible when no tasks are there?
>>

Make the height of the subreport small and set Can Grow to Yes.

RichM

 

[Sonja A]

Awesome - Thank you so very, very much! I have been headaching about this for a while and this forum is really wonderful. I hope I can return the favor sometime.