additional detail section

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

Guest

My report contains a lot of data per one record. There are 7 subreports
within this report printed on 4 pages. The problem is that I have come to
the end of the detail section. It seems I would have add an additional detail
section in order to fit all of the subreports (an approximate total of 10).
Can someone tell me how to add an additional detail band? Or should I be
making multiple reports and just writing code to print all at once?
 
You can add a lowest level of sorting and grouping by your primary key
field. If you display either the header or footer of this grouping, you
create an addition to your detail section.
 
debpep said:
My report contains a lot of data per one record. There are 7 subreports
within this report printed on 4 pages. The problem is that I have come to
the end of the detail section. It seems I would have add an additional detail
section in order to fit all of the subreports (an approximate total of 10).
Can someone tell me how to add an additional detail band? Or should I be
making multiple reports and just writing code to print all at once?
Click to expand...

Already answered in your previous thread.
 
I am sorry, Rick. You advised me that "*repeating* the bands or sections in
the report however many times necessary to process the records and groups in
the data set." But I don't know how to *repeat* a band. You also said that
"A report that has a 1 inch detail section and 1000 records will produce 1000
inches of output. You don't embed the entire report's output while in design
view." I am not embedding many records in the design view. I am reporting
only one record at a time with data from over ten tables. I am embedding
several subreports on a bound report. The maximum height of a section in
design view is 22 inches and I have come to the end of 22 inches. If you can
advise me on how to *repeat* the detail section, I would be most thankful.
 
I have sorted and grouped on the primary key and have displayed the group
header. The detail band is still the specified 22 inches of design view. I
cannot add more subreports to this detail section. It may be best to make
several reports that can print with one button, but it would seem that one
could keep adding enough subreports to one single report on one single
record. I am reporting data from over 10 tables for only one record.
 
The limit of 22 inches is "per section". If you add more group sections
then you will have 22 more inches for each section added. If you group on
the primary key and add a header and footer it will be the equivalent of
having a second and third detail section because each will repeat the same
number of times as there are records in the report. If your report is only
printing a single record at a time this would still yield an additional 44
inches of real estate.
 
OK. I get it now. Thank You!

Rick Brandt said:
The limit of 22 inches is "per section". If you add more group sections
then you will have 22 more inches for each section added. If you group on
the primary key and add a header and footer it will be the equivalent of
having a second and third detail section because each will repeat the same
number of times as there are records in the report. If your report is only
printing a single record at a time this would still yield an additional 44
inches of real estate.
Click to expand...
 
Back
Top