I would like to create a report that looks like this:
+ Employee1 name
+ Employee2 name
+ Employee3 name
...
If I want to see the supervisors for a particular employee
(let's say Employee2), I can click the + and expand a
subreport below it like so:
+ Employee1 name Department
- Employee2 name Department
Employee2's Supervisor1 name
Employee2's Supervisor2 name
+ Employee3 name Department
My report has a table with 2 detail rows. The first row
has the employee names and the 2nd row has a subreport that
shows the supervisor names for that employee. I've got the
subreport's visibility set to Hidden and toggled by the
employee name. The report works except that the + next to
each employee name is offset down by one. So Employee1 has
no +, and when I click the + by Employee2, I see the
supervisors for Employee1. This obviously has something to
do with the subreport being on the 2nd detail row, because
if I move it up to be on the same row as the employee name,
it works correctly. But then it shows up between the
employee's name and department, shoving department off to
the right. I want it to display beneath the employee name
as illustrated above. Anyone know how to do this? Thanks.
-JerradI figured out the problem. I was only making the cell
holding the subreport hidden. When I make the entire
detail row hidden, it works as expected.
>--Original Message--
>I would like to create a report that looks like this:
> + Employee1 name
> + Employee2 name
> + Employee3 name
> ...
>If I want to see the supervisors for a particular employee
>(let's say Employee2), I can click the + and expand a
>subreport below it like so:
> + Employee1 name Department
> - Employee2 name Department
> Employee2's Supervisor1 name
> Employee2's Supervisor2 name
> + Employee3 name Department
>My report has a table with 2 detail rows. The first row
>has the employee names and the 2nd row has a subreport that
>shows the supervisor names for that employee. I've got the
>subreport's visibility set to Hidden and toggled by the
>employee name. The report works except that the + next to
>each employee name is offset down by one. So Employee1 has
>no +, and when I click the + by Employee2, I see the
>supervisors for Employee1. This obviously has something to
>do with the subreport being on the 2nd detail row, because
>if I move it up to be on the same row as the employee name,
>it works correctly. But then it shows up between the
>employee's name and department, shoving department off to
>the right. I want it to display beneath the employee name
>as illustrated above. Anyone know how to do this? Thanks.
>-Jerrad
>.
>
No comments:
Post a Comment