hiding record from table detail section

[munnyAnu]

Hi,

I am trying to create a basic drill down report. I want to show least
salaried employee record from each department in department group
header.
then detail level should show all other employees by salary ascending
order for each department.

I am grouping by department and i am able to show the least salaried
employee record in group header. but here the problem is the details
section showing all the employee records including least salaried
employee record. since i am showing this record in group header i
don't want to show this record again in detail level. can anybody help
me how to prevent that record from detail section.

Thanks,
Anu.

[munnyAnu]

current report:

department Employee Salary
Group Level: Account, Jane, $70,000
Details: Account Jane $70,000
Account William $60,000
Account Smith $45,000

But I don't want show Jane's record twice. since i am showing Jane's
record in group header, I don't want to show in detail section again.
I want to show like below:

department Employee Salary
Group Level: Account, Jane, $70,000
Details: Account William $60,000
Account Smith $45,000
Account Debbie $40,000......


any help appreciated.


Thanks,
Anu.

[Simon]

Hi

You have several options here.

Option 1. You could change your query so that you identify the group
header as a separate column. You would probably do this using a
temporary table to identify the departments salartys that will be in
the group header and then using another temporary table to identify
the detail lines, and then join them all together at the end.

ie. your query results would be something like this:

Department Employee Salary Department Group Department
Group Salary
Account William 60000 Jane
70000
Account Smith 45000 Jane
70000

Option 2
Another option would be to identify the grouping record in your query
and then hide that detail row using a formula in the hidden/visbility
properities of the row:

ie
Department Employee Salary MaxmiumDeptSalary
Account Jane 70000 0
Account William 60000 0
Account Smith 45000 1

=IIF(Fields!MaximumDeptSalary =1,True,False)

Hope that helps.

Cheers
Simon