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 |
|
mani01784
Starting Member
1 Post |
 Posted - 2009-12-22 : 11:41:00
|
Hi all,I hope someone can help. Im trying to produce a report for a client who is very specific in the way that they want the report to be displayed, for example: The Class of Business, Account Class and Risk Group are not static labels but they will be data from within database. The table should display the records as grouped by Class of Business, Account Class and Risk Group and then the next group of data should be displayed within a new table.I've tried using a table and used the First() function and that does give me the first record, but it also gives me data for ALL the Received Years instead on the ones connected to the Groups.Using a matrix I cannot replicate the layout.If anyone can provide any help it will be much appreciated!Thanks,Mani |
|
|
Tahumars
Starting Member
15 Posts |
Posted - 2009-12-22 : 12:57:51
|
| I'm having a hard time imagining what the table should look like, maybe a quick screenshot of what it looks like now would help. But just from my first impression, could you not just add a filter to the group to only consider the current year? |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-12-23 : 15:25:35
|
| I have done this with a table with Toggles so that they can expand. With yours your grouping will be exactly the way you have it laid out in the above pix. I would use a table instead of a matrix. Matrix is nice when you have nth columns imho.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Matrix/Table help - Pulling my hair out!