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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|