Multiple duplications

[KindleFire]

My report is based off 1 query, I have 1 page of information to be displayed, yet my report duplicates to 96 pages and all my bound fields have duplicates hide enabled. Any possible solutions?

 

[David R]

If it's only supposed to be one page of data, I would suspect there's a rogue set of Page Breaks somewhere. For each of your Header, Footer, and Detail sections, the first entry under Format should be "Force New Page". If it's set to anything other than None then that will probably cause your weirdness.

HTH,
David R

 

[Pat Hartman]

Does the query duplicate the records also?

 

[KindleFire]

I looked, force new page is None and the query does not produce duplicates. Information is similiar as I am comparing prices from 2001 and 2002. ANy help?

 

[David R]

A low-tech solution is always to rebuild the query and/or report to see if something went weird within the original. Sorry I can't be of more help.

David R

 

[AJ]

Does your query return 96 records?

 

[KindleFire]

Yes, I switched a few things and I get 47 recors and now I get 47 report pages? Any Ideas? no ducplicates

 

[David R]

If you're getting the same number of records as pages, it still sounds like there is a ForceNewPage somewhere.

Did you try building the report over?

David R