A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing reports with no data



 
 
Thread Tools Display Modes
  #1  
Old August 3rd, 2004, 07:14 PM
external usenet poster
 
Posts: n/a
Default Printing reports with no data

I have designed an equipment inventory db. I have to
conduct an inventory of our equipment and want to print
out what I have so far so I can make any changes to it and
add equipment that isn't accounted for.

I have designed a report by employee with 4 subreports
which identify the computer, monitor, printer and any
peripherals the employee has been assigned. Each
equipment type is a separate subform.

For some employees, we have no information. For others,
we have the computer and printer, but no monitor or
peripheral info.

The tables are set up so that there is one main table
(tblInventory) and 4 additional tables (tblComputer,
tblPeripheral, tblMonitor, tblPrinter) with information
specific only to that equipment type in the secondary
table. Each table has a relationship with the main table.

How can I design my report so that all 4 subreports print,
with or without data? Right now, if an employee has a
computer, but no other information in the database, only
the computer subform prints and the rest of the page is
blank.

Thanks in advance for any help!
Tina
  #2  
Old August 3rd, 2004, 09:57 PM
Greg Blair
external usenet poster
 
Posts: n/a
Default Printing reports with no data

Tina,

I don't have an answer for you but you might want to watch the next post from me as well. I am trying to solve the same problem. I posted this problem in late June with no replies so I posted again today.

I'm currently trying to add a blank record to the recordset for the subform but I'm not finding the right place to add the record. I'll let you know if I succeed.

HTH,
--
Greg Blair
CNV Software
Minneapolis MN


" wrote:

I have designed an equipment inventory db. I have to
conduct an inventory of our equipment and want to print
out what I have so far so I can make any changes to it and
add equipment that isn't accounted for.

I have designed a report by employee with 4 subreports
which identify the computer, monitor, printer and any
peripherals the employee has been assigned. Each
equipment type is a separate subform.

For some employees, we have no information. For others,
we have the computer and printer, but no monitor or
peripheral info.

The tables are set up so that there is one main table
(tblInventory) and 4 additional tables (tblComputer,
tblPeripheral, tblMonitor, tblPrinter) with information
specific only to that equipment type in the secondary
table. Each table has a relationship with the main table.

How can I design my report so that all 4 subreports print,
with or without data? Right now, if an employee has a
computer, but no other information in the database, only
the computer subform prints and the rest of the page is
blank.

Thanks in advance for any help!
Tina

  #3  
Old August 4th, 2004, 01:50 PM
external usenet poster
 
Posts: n/a
Default Printing reports with no data

Greg:

I saw your post shortly after I posted mine. I hope we
get a response, but I'm not optimistic what we are trying
to do will work. I know there is an event property in the
properties box of the report called "Has no data" but I
don't know what code to put in it. I'll keep trying and
waiting for a response. Hopefully we'll get one!

Tina
-----Original Message-----
Tina,

I don't have an answer for you but you might want to

watch the next post from me as well. I am trying to solve
the same problem. I posted this problem in late June with
no replies so I posted again today.

I'm currently trying to add a blank record to the

recordset for the subform but I'm not finding the right
place to add the record. I'll let you know if I succeed.

HTH,
--
Greg Blair
CNV Software
Minneapolis MN


" wrote:

I have designed an equipment inventory db. I have to
conduct an inventory of our equipment and want to print
out what I have so far so I can make any changes to it

and
add equipment that isn't accounted for.

I have designed a report by employee with 4 subreports
which identify the computer, monitor, printer and any
peripherals the employee has been assigned. Each
equipment type is a separate subform.

For some employees, we have no information. For

others,
we have the computer and printer, but no monitor or
peripheral info.

The tables are set up so that there is one main table
(tblInventory) and 4 additional tables (tblComputer,
tblPeripheral, tblMonitor, tblPrinter) with information
specific only to that equipment type in the secondary
table. Each table has a relationship with the main

table.

How can I design my report so that all 4 subreports

print,
with or without data? Right now, if an employee has a
computer, but no other information in the database,

only
the computer subform prints and the rest of the page is
blank.

Thanks in advance for any help!
Tina

.

  #4  
Old August 4th, 2004, 04:49 PM
Greg Blair
external usenet poster
 
Posts: n/a
Default Printing reports with no data

Tina,

I've learned that a subreport without data will never show up under any circumstance so I had to recreate the subform controls on the main report. I had to set the controls visible depending on whether the subreport has data, using the Format event. The thread on my post has the details.
--
Greg Blair
CNV Software
Minneapolis MN


" wrote:

Greg:

I saw your post shortly after I posted mine. I hope we
get a response, but I'm not optimistic what we are trying
to do will work. I know there is an event property in the
properties box of the report called "Has no data" but I
don't know what code to put in it. I'll keep trying and
waiting for a response. Hopefully we'll get one!

Tina
-----Original Message-----
Tina,

I don't have an answer for you but you might want to

watch the next post from me as well. I am trying to solve
the same problem. I posted this problem in late June with
no replies so I posted again today.

I'm currently trying to add a blank record to the

recordset for the subform but I'm not finding the right
place to add the record. I'll let you know if I succeed.

HTH,
--
Greg Blair
CNV Software
Minneapolis MN


" wrote:

I have designed an equipment inventory db. I have to
conduct an inventory of our equipment and want to print
out what I have so far so I can make any changes to it

and
add equipment that isn't accounted for.

I have designed a report by employee with 4 subreports
which identify the computer, monitor, printer and any
peripherals the employee has been assigned. Each
equipment type is a separate subform.

For some employees, we have no information. For

others,
we have the computer and printer, but no monitor or
peripheral info.

The tables are set up so that there is one main table
(tblInventory) and 4 additional tables (tblComputer,
tblPeripheral, tblMonitor, tblPrinter) with information
specific only to that equipment type in the secondary
table. Each table has a relationship with the main

table.

How can I design my report so that all 4 subreports

print,
with or without data? Right now, if an employee has a
computer, but no other information in the database,

only
the computer subform prints and the rest of the page is
blank.

Thanks in advance for any help!
Tina

.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing colour in reports Pat Hartman Setting Up & Running Reports 0 July 8th, 2004 05:39 PM
How to create graphs in a monthly report where the base data can change John Clarke Charts and Charting 3 June 25th, 2004 02:22 AM
Data Labels on Charts in Reports Frank Setting Up & Running Reports 0 June 3rd, 2004 03:00 AM
Printing subform data in Access XP Raj K Using Forms 3 May 31st, 2004 02:24 AM
Collapsing rows with no data for printing John Sullivan Worksheet Functions 2 April 17th, 2004 05:42 PM


All times are GMT +1. The time now is 02:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.