Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spyork
Starting Member
6 Posts |
 Posted - 2005-07-13 : 17:43:34
|
| I'm having a small issue with displaying some table displayed with a table grouping. For example let's say I have a report where I want to group on userId and display all the projects that the userId is involved. So the report would look something like the following:User1--------project1--------project2--------project3User2--------project1--------project20The user name is displayed in the grouping row of the table and the project names are displayed in the detail row of the table.Now for the question...Is there a way in a table object to tell reporting services to start the display of the project names on the same row as the user name. For example...User1--project1-------project2-------project3User2--project1-------project20I know in ActiveReports.NET there is a property in a group header called UnderlayNextRow that will achieve this behavior, but it seems reporting services doesn't have anything similar (well at least that I can find). Does anyone have any suggestions? I would greatly appreciate any help that anyone can provide.Thanks... Spyork |
|
|
jhermiz
3564 Posts |
Posted - 2005-07-13 : 22:22:45
|
quote:
Originally posted by spyork
I'm having a small issue with displaying some table displayed with a table grouping. For example let's say I have a report where I want to group on userId and display all the projects that the userId is involved. So the report would look something like the following:User1--------project1--------project2--------project3User2--------project1--------project20The user name is displayed in the grouping row of the table and the project names are displayed in the detail row of the table.Now for the question...Is there a way in a table object to tell reporting services to start the display of the project names on the same row as the user name. For example...User1--project1-------project2-------project3User2--project1-------project20I know in ActiveReports.NET there is a property in a group header called UnderlayNextRow that will achieve this behavior, but it seems reporting services doesn't have anything similar (well at least that I can find). Does anyone have any suggestions? I would greatly appreciate any help that anyone can provide.Thanks... Spyork
Boy are we picky  ...Two things to do:1) You would have to GROUP BY UserID in your stored procedure or query and use that field in the details section of the report (the drawback is the user will repeat for all his / her projects, but I dont find this that bad)2) You will need to write custom code where you make the field invisible or visible based on a condition.My advice is to live with it, it's really not that big of a deal, you can also shrink the size or height of the actual row by using the properties section.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
spyork
Starting Member
6 Posts |
Posted - 2005-07-14 : 10:19:01
|
| Jon, thanks for the reply. Trust me when I say it's the customer who is picky about these things. You would think they would have better things to worry about :). Another solution I found was to not use a table but instead use a data list. In the data list I grouped by userId and then embedded another list inside of that list that would display the project names. This embedded list starts on the same line as the userId. Thanks...Spyork |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-07-14 : 10:21:19
|
Cool glad you got it working.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
Table grouping