Can't stop page breaks on my grouped list

All,
I've created a list and defined a group for monthly period. In the
list, I include several controls that show each month's summary values.
Unfortunately, each month's set of controls is appearing on separate
pages. The sections are small enough to fit two or three per page.
I've verified that the two page break properties are both set to False.
I've set the Keep Together property to False. What else am I missing?
Are their layout issues concerning margins or anything like that? This
is the first time I've tried to use grouped lists so I don't know what
to think.
I created the report with the report wizards and then modified it from
there. Maybe that will help.
Thanks,
DavidIt's me...the originator of this message.
I apparently have not found the list control's property that made it
serve as the Page field container that I chose in the New Report Wizard
(Matrix report). I would have thought the New Page After property.
Nevertheless, I created a new list control and copied my controls into
it. After defining my group, all worked as expected.
So if you're reading this and have a guess why the list control
mysteriously ejected pages, please respond. I'm interested.
David|||What was the property ? I am having a similar problem with the
occasional page in my report (200 pages) breaking about half way down
the page.
davidb@.mercurydata.com wrote:
> It's me...the originator of this message.
> I apparently have not found the list control's property that made it
> serve as the Page field container that I chose in the New Report Wizard
> (Matrix report). I would have thought the New Page After property.
> Nevertheless, I created a new list control and copied my controls into
> it. After defining my group, all worked as expected.
> So if you're reading this and have a guess why the list control
> mysteriously ejected pages, please respond. I'm interested.
> David

Can't group on Month part of the date.

Hi everyone,
I have a report with Period field that I use on a graph as Category
field (horozontal axe.) I want to group on the month part of the
Period. In my sql query Period is DATETIME. I found a similar topic
here and used this expession to group on month:
=DatePart("MM", Fields!Period.Value)
I also sorted by Period to preserve date-order.
I am getting the following error in preview:
The group expression for the grouping 'chart1_CategoryGroup1' contains
an error: Argument "Interval" is not a valid value.
Here is a format of my Period as it comes from SQL Server:
2004-02-29 00:00:00.000
Any ideas what is wrong?
Thanks in advance!
StanI just found my problem.
this
=DatePart("MM", Fields!Period.Value) shoild be like that:
=DatePart("M", Fields!Period.Value)
One single m!
Stan|||There is another problem. My data runs from February, 2004 to October,
2005. When I group on month my graph shows only 12 months. I don't see
data from the mid-end 2005!!! Is this s bug or a feature of RS'
Stan|||You need to group on the combination of year and month - otherwise data
from both Feb 2004 and Feb 2005 will be grouped together (and similarly
for other months, of course).
Something like =DatePart("yyyy", Fields!Period.Value) & " " &
DatePart("m", Fields!Period.Value)
You may need to convert this to a string, with a leading zero for the
month, for it to work correctly.|||Thanks! I did just that. In Group On expression for the Period in my
graph I entered:
=Year(Fields!Period.Value)*100 + Month(Fields!Period.Value)
so that I group on a combination of year and month.
Stan