Report line spacing issue

There is a formatting issue that I have come across.
The report has three groups and these groups have headers. When the report is populated most of the time it prints the result properly as expected, but sometimes at different number result records of the query I see that the main group header consumes an entire page and then skips to the next page. But in the next page I get the main group header and the data as it should be printed. After adjusting a page header (not the group headers) the report behaved normally for the same set of data, but fails when the result is changed again.
Any idea what I have done wrong or need to set (maybe a line size or something ) ?Often times when I have that problem, it's due to the "Keep Group Together" option.

Right click on the group name, and choose, "Change Group." Uncheck the "Keep Group Together" box, if it's checked. That might not be the same issue, but it usually resolves the problem with me.

Good luck!|||There is no 'Keep Group Together' checked in this case. I had it earlier and removed it also thinking that may be the issue.
The problem mainly is even if I tweek it a bit and get it to work with one set of data if fails for another one later.
Thanks very much for looking at the issue.|||So all your group expert 'keep group together' and your section expert 'keep together' for groups are unchecked?|||I am terribly sorry. I was all this time unticking the 'Kepp Group Together' check box in the 'Selection Expert' window when RMB and select the 'format..' option.
As I unchecked the check box in the 'Change Group Options' window it worked.
Thank you very much for the help.
By the way do you know why is there two options of 'Keep Group Together' in these two windows ?|||The one in the section expert keeps the section together, e.g. your group header has 3 sections and this keeps these 3 sections together.
The one in the group expert tries to keep the whole group together, i.e. the entire group header, footer, details inbetween etc.

Report help

Is it possible in reporting services to do the following:
I have a tabular report with months going across, and sales person going
down, the data shows the total sales value for each salesperson for each
month.. this I can do and is easy :-)
The tricky part that I have not worked out is this:
For an individual sales person: if a months sales value is less than the
previous month then I need the cell background to be red, if the value is
higher than the previous month then I need the cell background to be green.
Thanks,
Ricci.I am assuming you are using a matrix.
This is possible under fairly restrictive conditions:
* The query must return data in the following form:
Salesperson Month MonthlySales
Joe Jan 100
Joe Feb 101
Joe Mar 99
Mary Jan 200
Mary Feb 199
Mary Mar 201
* All aggregations must be done in the query and not in the Matrix
* Data must be sorted by salesperson and month in the query
Once these conditions are meet you can add the following expression to
background color property for the matrix cell that contains the monthly
sales:
=iif(Fields!Salesperson.Value = Previous(Fields!Salesperson.Value),
iif(Fields!MonthlySales.Value < Previous(Fields!MonthlySales.Value),
"Red", "Green"), "White")
Improvements to the Previous() method are currently under consideration for
inclusion in a future release.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ricci Hammond" <ricci@.riccisoft.nospam.co.uk> wrote in message
news:uC0HnjbXEHA.1048@.tk2msftngp13.phx.gbl...
> Is it possible in reporting services to do the following:
> I have a tabular report with months going across, and sales person going
> down, the data shows the total sales value for each salesperson for each
> month.. this I can do and is easy :-)
> The tricky part that I have not worked out is this:
> For an individual sales person: if a months sales value is less than the
> previous month then I need the cell background to be red, if the value is
> higher than the previous month then I need the cell background to be
green.
> Thanks,
> Ricci.
>