If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subreport Height not Grow/Shrink when change Page
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 |
#2
|
|||
|
|||
Subreport Height not Grow/Shrink when change Page
You might want to check out the calendar reports at
http://www.access.hookom.net/Samples.htm. The subreports all grow as expected. -- Duane Hookom Microsoft Access MVP "wrldruler" wrote: 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 |
#3
|
|||
|
|||
Subreport Height not Grow/Shrink when change Page
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 On Jul 27, 9:58 am, Duane Hookom wrote: You might want to check out the calendar reports athttp://www.access.hookom.net/Samples.htm. The subreports all grow as expected. -- Duane Hookom Microsoft Access MVP |
#4
|
|||
|
|||
Subreport Height not Grow/Shrink when change Page
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 "wrldruler" wrote: 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 On Jul 27, 9:58 am, Duane Hookom wrote: You might want to check out the calendar reports athttp://www.access.hookom.net/Samples.htm. The subreports all grow as expected. -- Duane Hookom Microsoft Access MVP |
#5
|
|||
|
|||
Subreport Height not Grow/Shrink when change Page
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 On Jul 27, 2:14 pm, Duane Hookom wrote: 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 |
#6
|
|||
|
|||
Subreport Height not Grow/Shrink when change Page
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 "wrldruler" wrote: 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 On Jul 27, 2:14 pm, Duane Hookom wrote: 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 |
Thread Tools | |
Display Modes | |
|
|