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

Grouping problems with reporting services sql server 2005

I'm having 2 problems with reporting services:
1) i have my report to group on contract and there are generally 4 or 5 lines per contract, so I don't want to page break in between.  For some reason it is page breaking after every contract.  I check the group properties and it is not set to page break (it is unchecked).
2) i want to have a table footer, so i can have a grand total.  for some reason it is showing the table footer with every grouping break (ie. every contract has a grouping total and a grand total which is the same).  And I never do get my actual grand total.

Is there a setting I'm missing?
0
Fraser_Admin
Asked:
Fraser_Admin
1 Solution
 
YurichCommented:
1) try deploying your report and see if you still have breaks on your report server. The report preview in Visual Studio tends not to give actual views from time to time

2) if you have groups, you would have group footer and table footer. make sure that you're using table footer and you don't have group specified in your totals, e.g. sum( Fields! MyFields.Value, "grpContracts" )

Regs,
Yurich
0
 
Fraser_AdminAuthor Commented:
My problem was some sort of a list object.  No clue where it came from, but once I got rid of it everything started working ok.
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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