Grouping problems with reporting services sql server 2005
Posted on 2007-03-22
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?