limit on height for detail section of report

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

Guest

Hi all,

Is there a limit on the height set to the detail section of an MS report? I tried to set the height of my report to be greater than 22", I get an error message saying "The number is too big". I need to generate a report with many details and i need a report detail section to be bigger than 22" is there anyway i can do that? please help.

Thanks!
yann
 
yann said:
Hi all,

Is there a limit on the height set to the detail section of an MS report? I
Click to expand...
tried to set the height of my report to be greater than 22", I get an error
message saying "The number is too big". I need to generate a report with many
details and i need a report detail section to be bigger than 22" is there anyway
i can do that? please help.

Add more sections or use subreports. A group section based on the Primary Key
field will act just like a second detail section.
 
Hi Rick,
Thanks for your help. Please kindly advice how can i add more sections or subreports to my report as I have no idea how to do so.

Thanks in advance.

regards
Yann Yng


----- Rick Brandt wrote: -----

yann said:
Hi all,
Click to expand...
tried to set the height of my report to be greater than 22", I get an error
message saying "The number is too big". I need to generate a report with many
details and i need a report detail section to be bigger than 22" is there anyway
i can do that? please help.

Add more sections or use subreports. A group section based on the Primary Key
field will act just like a second detail section.
 
yann said:
Hi Rick,
Thanks for your help. Please kindly advice how can i add more sections or
Click to expand...
subreports to my report as I have no idea how to do so.

Look for the Sorting and Grouping button in the toolbar while in design
view. The dialog produced allows you to establish a sort-order on one or
more fields or expressions. On each field/expression that you sort on you
can also optionally create a group header and/or footer. If you created a
group header based on an expression that was different for every row in the
report's RecordSource it would repeat as many times as the detail section
when the report was run.
 
Hi Rick
Thanks for your patience and explanation
Is there a way to prevent a page break between the group header section and the details section

Thanks in advance
yann
 
Back
Top