Posted by Erland Sommarskog on 01/10/07 23:30

pmarisole (jbarnes5@midsouth.rr.com) writes:
> I am trying to write a report that displays a hierarchy such as:
> Director, Manager, Employee
> I want to suppress the repeating Director, Manager for the employees.

Do you use Reporting Services? In such case, you may get better
assitance in microsoft.public.sqlserver.reportingsvcs.

Or do you want your query to produce this result:

> This is how I want it to display on the report
>
> MD Manager Employee
> Brian Smith Michael Smart Bill Mitchell
> Heidi Rainey
> Ponita Asnor
> Marcus Jones
> Rick Doe Glenn Thomas Helen Kelley
> Gaston Knight
> Helen Black Prentis Parker
> Billie Spike
> Jason Smart Tim Snow Joe Monty
> Randi Bull
> Misty Wonton

Please don't even think of it. It's not impossible, but it would
be complicated. Do this in your report tool, as this is standard
stuff for whichever tool you are using.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]