 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / February 2010reporting totals on top in sql server report services 2005
I am new to sql server report service 2005. I need to be able to put totals at the top of categories instead of at the bottom of categories. i have tried lots of options but nothing has worked so far. I need to be able to have a report look like the following: total group1 100 type1 50 type2 25 type3 25 Basically the total of 100 needs to be at the top of the report instead as a total at the bottom. I have been trying to use both the matrix and tables from the toolbar, but I have not succeeded yet. Thus I am wondering if you have any suggestions. I use this often in Matrix reports. Create your matrix and ensure you have groups defined for each section you want to total. Example Layout (simplified): Group | Type | Amount there are two ways to do the total above. 1. Right click on the group in the matrix and choose "Insert Row" - "Inside Group - Above". This will create a row above the grouping. then simply add your total there - something like [SUM(Amount)] 2. Alternatively (and the one i use most often), go to the bottom of the interface, where it shows the "Row Groups", right click on the appropriate group and choose "Add Total " - "Before". This will add the row above your group, and add the [SUM(....)] to each field in the row Hope this helps Sean > I am new to sql server report service 2005. I need to be able to put > totals [quoted text clipped - 16 lines] > but > I have not succeeded yet. Thus I am wondering if you have any suggestions. hmmmm... only noticed after i posted that u are using RS 2005. My comments applied to 2008. I haven't used the 2005 interface, so not sure how similar they are... > I use this often in Matrix reports. Create your matrix and ensure you have > groups defined for each section you want to total. [quoted text clipped - 34 lines] >> I have not succeeded yet. Thus I am wondering if you have any >> suggestions. I will let you know if either way works! Thanks! > hmmmm... only noticed after i posted that u are using RS 2005. My comments > applied to 2008. I haven't used the 2005 interface, so not sure how similar [quoted text clipped - 38 lines] > >> I have not succeeded yet. Thus I am wondering if you have any > >> suggestions. I tried the suggestions in 2005 and they did not work unfortunately! > I will let you know if either way works! > [quoted text clipped - 42 lines] > > >> I have not succeeded yet. Thus I am wondering if you have any > > >> suggestions. midnight, If I understand your question correctly, this is an easy answer. You can do totals in the Group Header Row the same as you can in the Group Footer row. So if you something like: =Sum(Fields!MyField.value) in the Group Header or Footer it will sum all the items within that group. Is that what you are trying to do? Hope that helps, Andrew Karcher SQL Server MVP >I am new to sql server report service 2005. I need to be able to put totals >at the top of categories instead of at the bottom of categories. i have tried [quoted text clipped - 13 lines] > I have been trying to use both the matrix and tables from the toolbar, but >I have not succeeded yet. Thus I am wondering if you have any suggestions. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.