Subreports show each column on a new page

[chgus]

I have a report with three subreports. Each subreport can have up to 8
columns of information based on which dates are selected (using checkboxes)
in a form that opens the report and sets the filter on the main report
(through a command button).

I have linked the subreports to the main report (master/child) by the date
field that is used to filter the data.

All the information shows up on each subreport as selected on the form but
each column of information (set across then down and can grow) is on a new
page. I want them all on the same page. The subreports work fine on their
own as does the layout preview. If I remove the master/child link, it
formats correctly but the filter no longer works.

I am using Access 2003.

Help. Please. This is making me nuts.

Thanks

 

[MikeJohnB]

Check the force new page setting of the detail header title (right Click)
also check the group together settins on the subform properties again right
click the title.

 

[chgus]

Thanks for the reply.

I double checked and I don't force a new page anywhere.

I want to confirm that you are referring to the "Grouping and Sorting"
option when you say "group together setting". I also want to confirm that
you are asking about the 'detail' section of the subform. I have monkeyed
with these settings a lot and have not gotten anywhere.

I wonder if the problem is that the field that ties the report to the
subreports is the date field that filters the report--each column is based on
these dates. If I sort and group on the date field and, even if I keep the
whole group together, each column is a different date. Would the "whole
group" specification in Grouping and Sorting be just one date? Is there
another way I could group things? I saw some posts about using =1, but didn't
understand where or how to use it and was unable to make it work from what I
read.

 

[MikeJohnB]

There are a couple of extra settings on the report layout in design mode. If
you right click on the title bar of the detail section of the report or the
titlr bar of the subreport and select properties, you will see force new page
and keep together, This is independant of the grouping of the data. I
wondered if you had tried these settings?

Kindest Regards

 

[chgus]

The detail section of each subreport and the detail section of the main
report all have:
Force New Page: None
Keep Together: Yes

Can you think of anything else it might be?

 

[MikeJohnB]

Like you, I am now struggling with this particular issue, the write up on
keep together says that if access finds that a report is longer than the
current page length, it forces a new page and prints t on the new page. you
can set the keep together as false in which case it should fill the current
page and then continue to print on the next page. I have a report, the same
as yours, I thought I had cracked this problem but adding just a few more
records causes the same issue.

(Below Quoted from the Net)
"Note When you set the Keep Together property to Whole Group or With
First Detail, the size of the group (or the portion of a group that includes
the group header through the first detail record) determines how Access
prints the report. If either the whole group or the header through the first
detail record is too large to fit on the page currently being printed, Access
advances to a new page and then begins printing the report."

I suggest you look at
http://msdn.microsoft.com/en-us/library/aa196190(office.11).aspx
http://office.microsoft.com/en-us/access/HP051873631033.aspx
http://allenbrowne.com/tips.html

There are a considerable number of pages relating to this issue if you
Google for Access report Keep together, one of the best people to answer this
issue in my opinion is Allen Browne

There is a pretty good explanation of this issue but I am not sure where the
code goes at the moment, if I find a solution I will re-post.

 

[chgus]

Thanks for your reply. I re-read the sections you recommended and didn't see
anything that would help. I'll keep looking. I've searched the web rather
extensively and haven't yet found anything that solves my problem (though I
readily admit the content is sometimes over my head).

All the information I have--report and subreports--format appropriately and
roll onto a new page as expected when the subreports aren't linked
(mother/child) to the report. Unfortunately, if I do that I lose the filter
and get far more information than I need. Make sense?

Good luck with your formatting.