February 1, 2010 at 4:30 pm
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.
February 2, 2010 at 8:12 am
Assuming you are using a table, if you have group/table headers and put the fields you want aggregated into the header you will get aggregated data. You can change the aggregate function in the header as SSRS will default to SUM for numeric fields and First for text fields.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply