Solved

Grouping problems with reporting services sql server 2005

Posted on 2007-03-22
2
279 Views
Last Modified: 2012-06-27
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
Comment
Question by:Fraser_Admin
2 Comments
 
LVL 21

Accepted Solution

by:
Yurich earned 500 total points
ID: 18774218
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
 

Author Comment

by:Fraser_Admin
ID: 18775569
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query Syntax 17 36
sql select record as one long string 21 24
Increment column based of a FK 8 23
sql server service accounts 4 27
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.

810 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