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  

Completely Blank Report...no title, data, etc.



 
 
Thread Tools Display Modes
  #1  
Old May 10th, 2010, 06:41 PM posted to microsoft.public.access.reports
ann
external usenet poster
 
Posts: 462
Default Completely Blank Report...no title, data, etc.

I am using Access 2002. I have created five reports that list totals in the
footer of each for January through December. They are then all on a report
so there is only one report instead of five. They are not linked to each
other.

All of them show up except one. One of the reports shows nothing at all,
not even the title of the report just a huge blank area where the report
should be. I'm assuming this is because there isn't any data pulled when the
query runs. If I run the report by itself I receive rows of #Errors where
all the calculations are but nothing but blank space when it's run with all
the reports combined.

Here is the calculation for January, =Sum(IIf([txtMachineType]="SeCap" And
[txtDRSMonth]="01",[sngQuantity],"0")). I thought I would get the "0" but
didn't. I then added Nz infront of Sum hoping that would work but it didn't.
I still just get a hugh blank space where this report is listed. I need to
show that each month has a zero even if there isn't any data. Any help would
be greatly appreciated. Thanks in advance.
  #2  
Old May 10th, 2010, 07:09 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Completely Blank Report...no title, data, etc.

If the subreport doesn't return any records then it will not display in the
main report.

In a report/group header/footer you often need to use IIf([HasData],...) to
get around errors where there are no records in the report/group.

--
Duane Hookom
Microsoft Access MVP


"Ann" wrote:

I am using Access 2002. I have created five reports that list totals in the
footer of each for January through December. They are then all on a report
so there is only one report instead of five. They are not linked to each
other.

All of them show up except one. One of the reports shows nothing at all,
not even the title of the report just a huge blank area where the report
should be. I'm assuming this is because there isn't any data pulled when the
query runs. If I run the report by itself I receive rows of #Errors where
all the calculations are but nothing but blank space when it's run with all
the reports combined.

Here is the calculation for January, =Sum(IIf([txtMachineType]="SeCap" And
[txtDRSMonth]="01",[sngQuantity],"0")). I thought I would get the "0" but
didn't. I then added Nz infront of Sum hoping that would work but it didn't.
I still just get a hugh blank space where this report is listed. I need to
show that each month has a zero even if there isn't any data. Any help would
be greatly appreciated. Thanks in advance.

  #3  
Old May 10th, 2010, 07:15 PM posted to microsoft.public.access.reports
ann
external usenet poster
 
Posts: 462
Default Completely Blank Report...no title, data, etc.

I'm not familiar with that. Does it somehow have to be part of the following:

=Sum(IIf([txtMachineType]="SeCap" And
[txtDRSMonth]="01",[sngQuantity],"0")).

I have twelve of these statements, one for every month.

"Duane Hookom" wrote:

If the subreport doesn't return any records then it will not display in the
main report.

In a report/group header/footer you often need to use IIf([HasData],...) to
get around errors where there are no records in the report/group.

--
Duane Hookom
Microsoft Access MVP


"Ann" wrote:

I am using Access 2002. I have created five reports that list totals in the
footer of each for January through December. They are then all on a report
so there is only one report instead of five. They are not linked to each
other.

All of them show up except one. One of the reports shows nothing at all,
not even the title of the report just a huge blank area where the report
should be. I'm assuming this is because there isn't any data pulled when the
query runs. If I run the report by itself I receive rows of #Errors where
all the calculations are but nothing but blank space when it's run with all
the reports combined.

Here is the calculation for January, =Sum(IIf([txtMachineType]="SeCap" And
[txtDRSMonth]="01",[sngQuantity],"0")). I thought I would get the "0" but
didn't. I then added Nz infront of Sum hoping that would work but it didn't.
I still just get a hugh blank space where this report is listed. I need to
show that each month has a zero even if there isn't any data. Any help would
be greatly appreciated. Thanks in advance.

  #4  
Old May 10th, 2010, 09:01 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Completely Blank Report...no title, data, etc.

I'm not sure if your expression is in the main or subreport or if you expect
it to display even if there are no records.

First, I would change the "0" to just 0 without the quotes. An IIf() should
not be designed to return either a number or text... pick one.
=Sum(IIf([txtMachineType]="SeCap" And [txtDRSMonth]="01",[sngQuantity],0))

Then I would suggest a small change:
=Sum(Abs([txtMachineType]="SeCap" And [txtDRSMonth]="01") * [sngQuantity])

This will return an error in a group header or footer if there are no
records. The usual solution is to use syntax like:
=IIf(HasData, Sum(Abs([txtMachineType]="SeCap" And [txtDRSMonth]="01") *
[sngQuantity]),0)

--
Duane Hookom
Microsoft Access MVP


"Ann" wrote:

I'm not familiar with that. Does it somehow have to be part of the following:

=Sum(IIf([txtMachineType]="SeCap" And
[txtDRSMonth]="01",[sngQuantity],"0")).

I have twelve of these statements, one for every month.

"Duane Hookom" wrote:

If the subreport doesn't return any records then it will not display in the
main report.

In a report/group header/footer you often need to use IIf([HasData],...) to
get around errors where there are no records in the report/group.

--
Duane Hookom
Microsoft Access MVP


"Ann" wrote:

I am using Access 2002. I have created five reports that list totals in the
footer of each for January through December. They are then all on a report
so there is only one report instead of five. They are not linked to each
other.

All of them show up except one. One of the reports shows nothing at all,
not even the title of the report just a huge blank area where the report
should be. I'm assuming this is because there isn't any data pulled when the
query runs. If I run the report by itself I receive rows of #Errors where
all the calculations are but nothing but blank space when it's run with all
the reports combined.

Here is the calculation for January, =Sum(IIf([txtMachineType]="SeCap" And
[txtDRSMonth]="01",[sngQuantity],"0")). I thought I would get the "0" but
didn't. I then added Nz infront of Sum hoping that would work but it didn't.
I still just get a hugh blank space where this report is listed. I need to
show that each month has a zero even if there isn't any data. Any help would
be greatly appreciated. Thanks in advance.

 




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


All times are GMT +1. The time now is 09:19 AM.


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