• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2442
  • Last Modified:

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

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
0
Jim Horn
Asked:
Jim Horn
1 Solution
 
Nico BontenbalCommented:
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:
http://stackoverflow.com/questions/488900/reporting-services-tablix-repeatcolumnheaders-doesnt-work-on-some-reports
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
You are correct, found that out after I posted the question.  Thanks.  -Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now