report is way too many pages...

[raistlin]

the problem i'm having with one of my reports is that it's 721 pages, and it's only supposed to be 1 page. i have 721 records and for some reason it seems to think it needs a page for each one, but i have all the information i need on one page. i've been looking at my other reports to try and figure out why it's doing that but all the settings seem to be the same.

the only things i have on the report is the report header and a detail section with a bunch of text boxes that are getting their information from one of my tables, and the table they're getting the information from has the 721 records on it.

i don't have any grouping or sorting being done on the report either.

is there an easy fix for this? am i just completely overlooking a setting, or do i need to change the format of my report somehow?

i appreciate any help.

 

[gemma-the-husky]

is your detail section very large - it needs to be as short as possible

do you have group headers/footers causing new pages to be generated

 

[raistlin]

the only thing i have for header/footer is the report header/footer and the detail section in between, and the detail section is about 6" long and it's filled with a ton of text boxes, but they all fit on one page.

 

[gemma-the-husky]

if the detail section is 6" long, then each detail section will need a whole page to show it, so you have 721 records, so you get 721 pages

if you only want a report on one row of your table, you need to filter the report or a query driving the report to achieve what you want

in the detail section properties theere is one called keep together - set that to no, and your report will split your details over two pages where it can, which will reduce the total number of pages

 

[raistlin]

changing the "keep together" to no make it go down to 481 pages, so it's going in the right direction, but i have no idea where the extra 480 pages are coming from. each page displays the same information.

here is a pic of what my detail section looks like. if it will help, i can probably make a watered down version of my db to show exactly what i have set up.

 

[gemma-the-husky]

i've told you

you have 721 records, and you are doing a report on all the records

each record will produce a detail section, so you get 721 detail sections

- why do you think/expect you will only get one page

- if you only want one page, you have to make the report just print the current record


-----------
if you want to summarise these records, then what you need is a TOTALS query, and then base the report on that query, instead of on the table

 

[raistlin]

i wasn't understanding why it wanted to report details for each record when i specified what i wanted it to display since my other reports only display a few records depending on how i filter them through the report.

but this;

-----------
if you want to summarise these records, then what you need is a TOTALS query, and then base the report on that query, instead of on the table

will solve my problem. thank you