Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SSRS 2008:  Tablix header row with =SUM()'s when there are two detail rows is not working

Posted on 2012-08-29
Medium Priority
Last Modified: 2012-09-04
In the attached image I have an SSRS 2008 report with a tablix, TWO detail lines, and a totals line below the detail lines.  This works great.

SSRS Column Totals
Question:  What would it take to get the totals line to appear ABOVE the two detail lines?

On reports with ONE detail line, when I click on the left side of the top detail row, then go to the Grouping pane in the bottom, select “Add Totals” and then select ‘Before’, it creates the row with appropriate =SUM(Fields!Whatever.Value) expressions, but when I run it I get this error message.

An error occurred during local report processing.
The definition of the report ‘/rpt_report_name’ is invalid.
The tablix ‘tbx_name’ has an invalid TablixMember.  The TablixMember must have the same value set for the RepeatOnNewPage property as those following or preceding the dynamic TablixMember.
(Expected Value: “True”, Actual Value: “False”

I’m looking everywhere, and I can’t find a ‘Repeat on new page” property
Question by:Jim Horn
LVL 22

Accepted Solution

Nico Bontenbal earned 2000 total points
ID: 38353637
This technique should work. You need to find a solution for the RepeatOnNewPage problem. You could try to recreate the Tablix step by step. Maybe that help.
More information on the RepeatOnNewPage property can be found here:
LVL 66

Author Comment

by:Jim Horn
ID: 38365086
You are correct, found that out after I posted the question.  Thanks.  -Jim

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
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
Suggested Courses

572 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