I'm still fairly new to Reporting Services, and i have been tasked with
recreating a report that i believe was originally created with Python. I
know i can do it in ASP.Net, but i would rather use Reporting Services. I
know i can figure out most items, but the one issue that i'm having is
getting all the ticket numbers to appear. Here is an example of what i'm
trying to create

Users Tickets
user1 13345
user2 9133 6718 6669 3726
user3 9682 7313 3583 13465 13460 13458 11829
....

So, the report would continue to display each user, and every ticket that is
currently assigned to them. (each ticket is actually a link to the details,
and color coded - but i'm sure i can figure that part out) I'm having
troubles getting the report to appear with a dynamic number of columns
displaying all the ticket numbers.

I did get the report to display this at one point - but it's no good because
it gets REALLY wide!
Users Tickets
user1 13345
user2 9133 6718 6669 3726
user3
9682 7313 3583 13465 13460 13458 11829
......

Please tell me that i don't need to break out the ASP.....


--
Message posted via SQLMonster.com

I figured out a solution if anybody ever needs it. the 1st report reports on
the users creating a list. A subreport takes the user as a parameter and
outputs the ticket numbers to a matrix instead of a table.

[quoted text, click to view]


--