Solved

Grouping problems with reporting services sql server 2005

Posted on 2007-03-22
2
274 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
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now