multiple details sections

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I have a very long report which is longer than the height limit of the details section of 22". Isit possible for me to create another details section?! there are no grouping for my data, therefore I cannot use the group header and footer section for displaying all my data.

Please help. Thanks

yann
 
Each Record needs more than 22" to display? Wow! That is some Record -- two
letter-size pages.

You may be able to accomplish what you need by using multiple subreports in
the detail section, using the CanGrow property on both the Subreport control
and on the Detail Section itself.

Wherever it applies, however, the 22" limit is a built-in limit that we
can't change.

Larry Linson
Microsoft Access MVP





yann said:
Hi all,

I have a very long report which is longer than the height limit of the
Click to expand...
details section of 22". Isit possible for me to create another details
section?! there are no grouping for my data, therefore I cannot use the
group header and footer section for displaying all my data.
 
Hi Larry
Thanks for quick reply. :

As i would need 2 subreports, can I use the same query for the 2 subreports?! just that different sets of fields are placed in each subreport

Thanks
yann
 
Pardon me for jumping in, but in addition to Mr. Linson's suggestion you can
group the data by the primary key or some combination of unique fields. This
will give you a group for each row in your returned set of data. Then you can
put some of the data into the group Header, some into the detail, and some into
the Group footer. This should give you up to 66 inches of space for the report.

That said, I am amazed that you could have a requirement for this much space in
a report and not run into some restrictions on the data (like the 2K limit of
record size). I guess if you were returning data from memo fields that could
account for the size of the page. However, in that case you could shrink the
control height to a minimal size and use the can grow property of the control
and the detail section to overcome (perhaps) the limit of 22 inches in any one
section of the report.
 
Hey,

I did this recently for a customer. Link the Child/Parent reports for the
1st and 2nd, then for the 2nd and 3rd. I only had to go two levels deep but
I think that I read somewhere that there is a limit of only 3 levels of
subreports on a single report. Perhaps someone else can back me up on
this...

Stewart
 
Hi Stewart and John

Thanks for replies

Stewart, can you please elaborate what you mean by
"Link the Child/Parent reports for the 1st and 2nd, then for the 2nd and 3rd."
I have never used subreports, therefore I would appreciate if you could guide me in linking the reports to form one long report. thanks

John, I've already minimised the size of the controls, but it is still running outta the page.. as I need to display 85 fields into one report. I cannot use grouping as I m using subquery in the query which is the recordsource of my report. I'll get an error saying "Multi-level GROUP BY clause is not allowed in a subquery

Thanks
yann
 
Back
Top