all groups > sql server reporting services > october 2004 >
You're in the

sql server reporting services

group:

Hidden subreport problem



Hidden subreport problem Jerrad
10/13/2004 2:34:47 PM
sql server reporting services: 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.

Hidden subreport problem Jerrad
10/14/2004 1:55:11 PM
I 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.

[quoted text, click to view]
AddThis Social Bookmark Button