473,324 Members | 2,541 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Holy Smokes 21000 pages of report!

I am writing this very simple report and everything looks fine... until
i do a page preview where my supposedly 3-pager balloons into 21K
pages!!! What is wrong??? In the design view, things are perfect but
apparently not. Help!

IQ

Nov 13 '05 #1
2 1303
Information Queen wrote:
I am writing this very simple report and everything looks fine... until
i do a page preview where my supposedly 3-pager balloons into 21K
pages!!! What is wrong??? In the design view, things are perfect but
apparently not. Help!

IQ

This is almost always related to an join problem. I've had it often when
I added a table to a query and forgot to join it.
judy
Nov 13 '05 #2
Information Queen,
Check the query that supplies information to the report. I suspect you have
neglected a join somewhere and are getting a Cartesian Product of your
results.

"Information Queen" <tz****@yahoo.com> wrote in message
news:10**********************@f14g2000cwb.googlegr oups.com...
I am writing this very simple report and everything looks fine... until
i do a page preview where my supposedly 3-pager balloons into 21K
pages!!! What is wrong??? In the design view, things are perfect but
apparently not. Help!

IQ

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: gg.2.starfire | last post by:
WebCheck (http://www.raycosoft.com/rayco/products/webcheck) is a program for testing and analyzing static or dynamic web pages. WebCheck fetches web pages, applies detailed tests to each web page...
1
by: VBSponge | last post by:
Hi all. In A2K i have a report with a control bound to to calculate the page count for the report. I need to retrieve this page count from the report, and build it into a TOC containing this an...
2
by: Information Queen | last post by:
My supposedly simple 3-page report balloons into 21K pages of redundant information when I preview it. In the design view, things are perfect... but then apparently not. Help! IQ
6
by: noway | last post by:
I have greated a report and have included a page break in it. The report breaks were it is supposed to but then it creates a blank page between the two pages. Since this report will print out...
4
by: Mal Reeve | last post by:
Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates...
0
by: booktwo | last post by:
Back from Africa, where I was a secular missionary in the Kayon Ghozi's leprosary (Burundi) because of health reasons, I wrote these lucky Flashes of mine, which got a resounding success ,on...
2
by: Richard | last post by:
Our web programmer was looking in his application log an found the following error: 2006-08-31 16:33:35,129 ERROR org.hibernate.util.JDBCExceptionReporter - < SQL0723N An error occurred in a...
1
by: ellenh | last post by:
I have read postings on the similar subject including the posting from 2003 shown below. This process works fine to display a single page snapshot report in PowerPoint. I need to display...
2
by: Steve | last post by:
I'm working on a report for an existing database. The report will be a directory of over 500 employees and thus multiple pages. What do I need to do to show the first employee and the last employee...
1
by: Neil Ginsberg | last post by:
Anyone have an idea as to why an MS Graph chart would cause a report to repeat for 27 pages? I have a report which consists of a few labels in the header, and a single chart in the Detail section....
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.