473,320 Members | 1,933 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,320 software developers and data experts.

Blank document when previewing my reports

I am working with a hospital database and am trying to put together a report that runs statistics on the various demographics of the patients that come through. As such I have created multiple queries counting how many of X patients have been seen. I have then combined all of these queries into one and used it as the source for a report. I haven't used any expressions in the report only drag and drop from the source list. However, when I attempt to preview the reports (Now 3 of them because I also don't know how to subreport to extend past the height of 22"), it brings up an infinite number of blank pages. I'm self taught and have only been working with access for the past 8 weeks ~ 64 total hours. Please help!
Oct 14 '08 #1
3 1173
NeoPa
32,556 Expert Mod 16PB
This all really depends on what's set up in the report and, possibly, the underlying query. A frequent report problem with blank pages is that the design is expected to fit in a single page of A4, but due to extremely small levels of overshoot, you are left with many pages of seemingly blank info. This would typically come at the end though rather than the start.

You will need to tell us more if we're to be more help I'm afraid.
Oct 14 '08 #2
This all really depends on what's set up in the report and, possibly, the underlying query. A frequent report problem with blank pages is that the design is expected to fit in a single page of A4, but due to extremely small levels of overshoot, you are left with many pages of seemingly blank info. This would typically come at the end though rather than the start.

You will need to tell us more if we're to be more help I'm afraid.
Sure, I'd love to tell you more. Though I must say I'm not really sure what will be most helpful toward you helping me. So I'll just start. I've been working in Access 2002 but also 2003 (Depends on which computer I'm at). Currently I'm on 2002. My OS is Windows XP. My database is full of patient information. I'm running statistics on race, age, sex, cause of injury, etc. There are multiple tables which house these fields that I've now joined in queries and then queried the queries to "count number of X in Y." An example
Expand|Select|Wrap|Line Numbers
  1. Spine: DCount("[ICD Body Part]","Demo_OrthoDx","[ICD Body Part]='Spine'")
counts the number of spinal injuries out of all of the orthopaedic diagnoses. You can imagine that there are many things you could count to get the statistics you would need. As such, I have more of these counts than can even fit into a single query. I've split them into separate queries and used the separate queries as the source data for multiple reports. In design view I have been dragging data from the field list and dropping it onto the report. I format it how I like then copy it, and paste it again where I then manually change the data it is calling from say spine to toes. When I attempt to preview the report..Blank.
Oct 14 '08 #3
NeoPa
32,556 Expert Mod 16PB
Do you have a Record Source for your report? If so, what is it?
Oct 14 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Me | last post by:
I need to test for blank inputs and run a routine "if" the input is blank. This will be used internally on a LAN to calculate selling price if the "sell" input is blank and a margin is supplied,...
5
by: Bob | last post by:
Hi, I am using Access 2000 to print out an address book. I have designed the report based on a database whose first record is not blank. In the design there is a one line report header, a onle...
6
by: Melissa | last post by:
Does anyone have a generic procedure for adding blank lines to reports like Sales details, PO details and/or Orders details. The procedure would need to count the number of line items, determine...
7
by: peggyfiorentino | last post by:
I'm an intermediate Access user. I have 3 summary reports that I would like to combine on one report. I tried to create a report in design view using 3 seperate subreport boxes. Specifying the...
2
by: Olveres | last post by:
Hi, I have managed to work out how to add new lines into a calculated text box. However in this text box some of the outcome fields are empty however when previewing the report it includes the...
0
by: timeline | last post by:
VB-WEB: proint Job Name is about:blank followed by content to print C#-APP: Sending a Job to the Printer with Crystal Reports I am using mshtml.HTMLDocumentClass docObject=new...
2
by: vipinkmathews | last post by:
I wrote code for previewing a word dcoument in C#. In the code when the user click preview button the document gets opened and later the user manually closes the document. But in Task manager the...
10
by: Lorie0114 | last post by:
Hello, We have an issue that I do not know how to resolve. Our website has several hundred reports. There are a handful of them that are causing issues when there is no interaction for a couple...
11
by: Gord | last post by:
When I open a certain report, it runs some code that generates the records that will be displayed in that report. This works fine. When I go to print preview the report it appears that the code...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
0
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: 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
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.