Clarification: Hide Group Header

[epoh]

I am trying to clean up a report that displays information about a network resource (resources) and a subreport (tasks) with a basic to-do list. The two reports are linked together by ResourceID.

Sample Report (how it looks now):

[COLOR=blue][b]Primary Domain Controller [/b][Group Header]
-Install updates [detail]
-Run ipconfig

[b]Secondary Domain Controller [/b] [Group Header]

[b]SQL Server[/b] [Group Header]
-Test MSSQL 2008

[b]Exchange Server [/b] [Group Header]
-delete old accounts

[b]Terminal Server [/b] [Group Header][/color]

Objective: I want to hide any resource that has no tasks in the subreport.

[highlight]Report (Goal):[/highlight]

[COLOR=blue][b]Primary Domain Controller[/b]  [Group Header]
-Install updates [detail]
-Run ipconfig

[b]SQL Server [/b][Group Header]
-Test MSSQL 2008 

[b]Exchange Server[/b] [Group Header]
-delete old accounts[/color]

Notice that the Secondary Domain Controller & Terminal Server are not listed, that's because there are no tasks associated with this resource.

Can this be done, I have looked high and low. I saw some suggestions for doing a count(*), that didn't help because all the counts were 1.

(Sorry for the bad post earlier -

http://www.tek-tips.com/viewthread.cfm?qid=1550001&page=1)

 

[MazeWorX]

Have you tried to set criteria for Tasks 'Is Not Null' in the query?



Remember amateurs built the ark - professionals built the Titanic

[flush]

 

[epoh]

Well, I would but in the db there are two tables:

tbl_SystemName
tbl_Tasks

There are multiple tasks here with different statuses of these tasks, I am looking for any unfinished task.

the header is tbl_SystemName, the detail is a subreport of tbl_Taks