report header and footer

[iccsi]

I have a report which does not have details and I put everything in
the report header and page footer.

I just realized that the report header and footer have limit height
22" each.. My report will have more than 5 pages which need more than
44" height.


I just wanted to know are there any workaround for this?


Your help is great appreciated,

 

[Marshall Barton]

I have a report which does not have details and I put everything in
the report header and page footer.

I just realized that the report header and footer have limit height
22" each.. My report will have more than 5 pages which need more than
44" height.


I just wanted to know are there any workaround for this?

Sounds messy. Is it an unbound report? If not, you should
fo the total calculations in the report's record source
query instead of hiding all the details.

Regardless of that, unless you have a rather unusual
printer, the page footer should never be anywhere near 22"
high. Maybe you meant Report Footer?

Anyway, you can add up to 10 group headers and footers by
using constant expressions (e.g.=1) in Sorting and Grouping
(View menu). Then spread your controls over any of the
sections (up to a max of 220 inches total).

 

[iccsi]

Sounds messy.  Is it an unbound report?  If not, you should
fo the total calculations in the report's record source
query instead of hiding all the details.

Regardless of that, unless you have a rather unusual
printer, the page footer should never be anywhere near 22"
high.  Maybe you meant Report Footer?

Anyway, you can add up to 10 group headers and footers by
using constant expressions (e.g.=1) in Sorting and Grouping
(View menu).  Then spread your controls over any of the
sections (up to a max of 220 inches total).

yes, I mean report footer.

Thanks for the tips,

 

[iccsi]

yes, I mean report footer.

Thanks for the tips,- Hide quoted text -

- Show quoted text -

Do you mean that dummy grouping then Access will put them together?

How is sub report?
Will sub report work?

Thanks again,

 

[Marshall Barton]

Do you mean that dummy grouping then Access will put them together?

How is sub report?
Will sub report work?

What subreport? You didn't mentioned a subreport before.
What does a subreport have to do with your question? I
really can not provide very specfic help without a fairly
detailed description of the problem.

I don't understand what you mean by "Access will put them
together". Access prints each visible section in the
appropriate order, in this case one after another.

For a simple thing like I suggested, just make a copy of
your report and give it a try to see what Access does with
it.

 

[iccsi]

Do you mean that dummy grouping then Access will  put them together?

How is sub report?
Will sub report work?

What subreport?  You didn't mentioned a subreport before.
What does a subreport have to do with your question?  I
really can not provide very specfic help without a fairly
detailed description of the problem.

I don't understand what you mean by "Access will  put them
together".  Access prints each visible section in the
appropriate order, in this case one after another.

For a simple thing like I suggested, just make a copy of
your report and give it a try to see what Access does with
it.

--
Marsh
MVP [MS Access]- Hide quoted text -

- Show quoted text -

Thanks for the message,
I understood that grouping report is a workaround for mey situation.
My questions was does subreport work as well?

Can I split my reprot in to small reports and place them in serveral
subreport and put the subreports on the main report then to workaround
the height of report header and report footer issue?

Thanks again,

 

[Marshall Barton]

I understood that grouping report is a workaround for my situation.
My questions was does subreport work as well?

Can I split my reprot in to small reports and place them in serveral
subreport and put the subreports on the main report then to workaround
the height of report header and report footer issue?

Sure. Just make sure that you can keep all the record
sources from getting in each other's way.

For such a simple idea, it's much quicker to just give it a
try and see what happens.