Solved

Grouping problems with reporting services sql server 2005

Posted on 2007-03-22
2
281 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How do I figure out how much database is expected to grow? 15 73
SQL Select - identify record discrepancies 1 30
sql update 2 36
T-SQL Query - Group By Year 3 25
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

713 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