Subreport Height not Grow/Shrink when change Page

[wrldruler]

Hello,

I have a calendar report which uses 30 copies of a sub-report to
build
each day. Working just fine except:

Let's say January 16th, there are 2 items to be listed for that date
and the sub-report grows to a height of 0.5".

I hit Next Page, go to February. There are now 4 items that need to
be
listed in that box. But instead of growing to accomodate these 4
items, the box stays at the 0.5" from January, and thus cuts off the
February data.

I have set Can Grow and Can Shrink everywhere -- in the sub-report
details, on the sub-report control, and on the main report details. It
DOES successfully grow and shrink on initial open, but just won't
adjust the height on page turn.

The subreport hieghts are being set on Page #1, and will not grow or
shrink to adjust to the page 2 data.

Any ideas on how to force a sub-report to grow/shrink when a page is
turned?

Thanks

 

[Duane Hookom]

You might want to check out the calendar reports at
http://www.access.hookom.net/Samples.htm. The subreports all grow as expected.

 

[wrldruler]

Thanks for the advice. Should have thought of that considering I used
that sample DB to build the report to start with.

Unfortunetly, I compared my DB versus the sample and can find no
logical reason for the behavior. The sample DB does not do anything
special to grow/shrink.

Another symptom: I put a textbox with Count(*) on the sub-report. In
January, let's say subrpt15 has a count of 5, which is correct. I
switch to February. That same subrpt shows 2 pieces of data, yet the
count is stuck at 5. So the Count doesn't refresh either when I switch
pages.

Thanks,

Chris

 

[Duane Hookom]

Do you have any code running? You may need to requery the subreport or
something similar to having to requery a chart control on a report.
--
Duane Hookom
Microsoft Access MVP

Thanks for the advice. Should have thought of that considering I used
that sample DB to build the report to start with.

Unfortunetly, I compared my DB versus the sample and can find no
logical reason for the behavior. The sample DB does not do anything
special to grow/shrink.

Another symptom: I put a textbox with Count(*) on the sub-report. In
January, let's say subrpt15 has a count of 5, which is correct. I
switch to February. That same subrpt shows 2 pieces of data, yet the
count is stuck at 5. So the Count doesn't refresh either when I switch
pages.

Thanks,

Chris

 

[wrldruler]

I had an earlier problem where my data was not refreshing at all when
I moed from page to page.

So I am doing a Me.subrt.Requery now and that fixed the data refresh
problem, but still have a lingering grow/shrink "refresh" problem.

Thanks

 

[Duane Hookom]

It might be the 30 subreports is too many depending on the number of records
and indexes etc. Have you thought about 5-7 subreports to create a week at a
time?

--
Duane Hookom
Microsoft Access MVP

I had an earlier problem where my data was not refreshing at all when
I moed from page to page.

So I am doing a Me.subrt.Requery now and that fixed the data refresh
problem, but still have a lingering grow/shrink "refresh" problem.

Thanks