[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SSRS:  How to get Totals line above the Detail

Posted on 2012-08-20
Medium Priority
Last Modified: 2012-08-29
Hi guys

In the attached image I have an SSRS 2008 report with a tablix, and a totals line below the detail.  
This works great.

SSRS tablix with totals
Question:  What would it take to get this totals line to appear ABOVE the detail lines?

When I try to insert a row, and do =Sum(whatever), it returns a 'The tablix 'name' has an invalid TablixMember' error message.

Question by:Jim Horn
  • 5
LVL 11

Accepted Solution

SThaya earned 1400 total points
ID: 38311602
are you doing any grouping . if yes .. when you select the Total option from Grouping pane in the bottom .. Select " add Total " and then select "Above " this will place a Grand Total in the top of the Detail Row.
LVL 11

Assisted Solution

by:Simone B
Simone B earned 600 total points
ID: 38311613
I believe this will work in 2008:

Right click on the box to the left of your table headers, and select "Insert Row Below." That should add another header row, and you can put your sum there.

Screen Capture
LVL 66

Author Comment

by:Jim Horn
ID: 38311684
<gotta go OOO for the next five hours, will reply then.  Thanks.  -Jim>
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

LVL 66

Author Comment

by:Jim Horn
ID: 38313117
SThaya - I followed your instructions, and the row appears, pre-populated with =Sum(Fields!field_name.Value)

But when I attempt to run the report in Preview mode I get the following error message:

An error occured during local report processing.
The definition of the report 'report_name' is invalid.
The tablix 'tablix_name' has an invalid TablixMember.  The TablixMember must have the same value set for the ReportOnNewPage property as those following or preceding the dynamic TablixMember.
(Expected Value: "True"; Actual Value: "False")

Looking around the only object that has a ReportOnNewPage property is the tablix itself, and the error message that says 'TablixMember' doesn't specifically name the object that is invalid.
LVL 66

Author Comment

by:Jim Horn
ID: 38313143
Slight correction to the above:
In the Row Groups, when I click on the arrow and choose Add Total, the choices are Before and After (not Above per your comment).  I chose Before.
LVL 66

Author Comment

by:Jim Horn
ID: 38313185
I was able to pull this off on an SSRS report that has only one detail row, so will assume for the moment that the error I'm experience is related to my using two detail rows.
LVL 66

Author Closing Comment

by:Jim Horn
ID: 38346528
Since the original question was answered I'll award points, and create a second question for the follow-up.  Thanks.  -Jim

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question