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
|
|||
|
|||
No Record Reports
I have a report with 2 subreports... it's a basic billing system.
rptBalanceForward - displays a balance due as of one month before the "user entered" current Billing Date rptChargesThisPeriod - displays charge and credit transactions for the last month before Billing Date rptBalanceForward is located just above rptChargesThisPeriod. Often, no records meet the criteria in the Balance Forward supreport, so it comes up empty, and displays nothing. There are ChargesThisPeriod amounts to display, and they do... but with an empty space above, due to the empty sub. Customer ID is the field that links both subreports to the main form. Fields in sub rptBalanceForward... AsOfDate (unbound Calc - User entered BillingDate-1 month) Transaction (label - "BalanceForward") Amount (bound calc - =Sum(Amount) - Format nulls as .00) CustomerID (bound - [CustomerID] - key/link field) Tried "OnNoData", On Print, IIF(IsNull...), etc... to force a display, but no luck. Can someone offer some tips or tricks on how to force a rptBalanceForward record to display as (ex.) 7/14/05 Balance Forward 0.00 if no records meet the criteria? Thanks in advance, Al Camp |
#2
|
|||
|
|||
Al Camp wrote:
I have a report with 2 subreports... it's a basic billing system. rptBalanceForward - displays a balance due as of one month before the "user entered" current Billing Date rptChargesThisPeriod - displays charge and credit transactions for the last month before Billing Date rptBalanceForward is located just above rptChargesThisPeriod. Often, no records meet the criteria in the Balance Forward supreport, so it comes up empty, and displays nothing. There are ChargesThisPeriod amounts to display, and they do... but with an empty space above, due to the empty sub. Customer ID is the field that links both subreports to the main form. Fields in sub rptBalanceForward... AsOfDate (unbound Calc - User entered BillingDate-1 month) Transaction (label - "BalanceForward") Amount (bound calc - =Sum(Amount) - Format nulls as .00) CustomerID (bound - [CustomerID] - key/link field) Tried "OnNoData", On Print, IIF(IsNull...), etc... to force a display, but no luck. Can someone offer some tips or tricks on how to force a rptBalanceForward record to display as (ex.) 7/14/05 Balance Forward 0.00 if no records meet the criteria? You can not make an empty subreport display anything. What you can do is place one or more text box's on top of the subreport And make them visible when the subreport doesn't have any data: Me.atextbox.Visible = Not Me.subreport.HasData To get rid of the blank space, set the subreport control's and its section's CanShrink property to Yes. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
How about making an image out of the blank subreport? You could make the
image display when there are no records. Linda "Marshall Barton" wrote in message ... Al Camp wrote: I have a report with 2 subreports... it's a basic billing system. rptBalanceForward - displays a balance due as of one month before the "user entered" current Billing Date rptChargesThisPeriod - displays charge and credit transactions for the last month before Billing Date rptBalanceForward is located just above rptChargesThisPeriod. Often, no records meet the criteria in the Balance Forward supreport, so it comes up empty, and displays nothing. There are ChargesThisPeriod amounts to display, and they do... but with an empty space above, due to the empty sub. Customer ID is the field that links both subreports to the main form. Fields in sub rptBalanceForward... AsOfDate (unbound Calc - User entered BillingDate-1 month) Transaction (label - "BalanceForward") Amount (bound calc - =Sum(Amount) - Format nulls as .00) CustomerID (bound - [CustomerID] - key/link field) Tried "OnNoData", On Print, IIF(IsNull...), etc... to force a display, but no luck. Can someone offer some tips or tricks on how to force a rptBalanceForward record to display as (ex.) 7/14/05 Balance Forward 0.00 if no records meet the criteria? You can not make an empty subreport display anything. What you can do is place one or more text box's on top of the subreport And make them visible when the subreport doesn't have any data: Me.atextbox.Visible = Not Me.subreport.HasData To get rid of the blank space, set the subreport control's and its section's CanShrink property to Yes. -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
"Marshall Barton" wrote in message
... Al Camp wrote: I have a report with 2 subreports... it's a basic billing system. rptBalanceForward - displays a balance due as of one month before the "user entered" current Billing Date rptChargesThisPeriod - displays charge and credit transactions for the last month before Billing Date rptBalanceForward is located just above rptChargesThisPeriod. Often, no records meet the criteria in the Balance Forward supreport, so it comes up empty, and displays nothing. There are ChargesThisPeriod amounts to display, and they do... but with an empty space above, due to the empty sub. Customer ID is the field that links both subreports to the main form. Fields in sub rptBalanceForward... AsOfDate (unbound Calc - User entered BillingDate-1 month) Transaction (label - "BalanceForward") Amount (bound calc - =Sum(Amount) - Format nulls as .00) CustomerID (bound - [CustomerID] - key/link field) Tried "OnNoData", On Print, IIF(IsNull...), etc... to force a display, but no luck. Can someone offer some tips or tricks on how to force a rptBalanceForward record to display as (ex.) 7/14/05 Balance Forward 0.00 if no records meet the criteria? You can not make an empty subreport display anything. What you can do is place one or more text box's on top of the subreport And make them visible when the subreport doesn't have any data: Me.atextbox.Visible = Not Me.subreport.HasData To get rid of the blank space, set the subreport control's and its section's CanShrink property to Yes. -- Marsh MVP [MS Access] Thanks very much Marshall. That's just what I needed to know. Sounds like a reasonable workaround. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions |
#5
|
|||
|
|||
I rarely use images, so I'll probably just use one text control...but the
invisible/visible soultion is just what I needed to know. Thank you for your quick response, -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Linda Burnside" wrote in message . .. How about making an image out of the blank subreport? You could make the image display when there are no records. Linda "Marshall Barton" wrote in message ... Al Camp wrote: I have a report with 2 subreports... it's a basic billing system. rptBalanceForward - displays a balance due as of one month before the "user entered" current Billing Date rptChargesThisPeriod - displays charge and credit transactions for the last month before Billing Date rptBalanceForward is located just above rptChargesThisPeriod. Often, no records meet the criteria in the Balance Forward supreport, so it comes up empty, and displays nothing. There are ChargesThisPeriod amounts to display, and they do... but with an empty space above, due to the empty sub. Customer ID is the field that links both subreports to the main form. Fields in sub rptBalanceForward... AsOfDate (unbound Calc - User entered BillingDate-1 month) Transaction (label - "BalanceForward") Amount (bound calc - =Sum(Amount) - Format nulls as .00) CustomerID (bound - [CustomerID] - key/link field) Tried "OnNoData", On Print, IIF(IsNull...), etc... to force a display, but no luck. Can someone offer some tips or tricks on how to force a rptBalanceForward record to display as (ex.) 7/14/05 Balance Forward 0.00 if no records meet the criteria? You can not make an empty subreport display anything. What you can do is place one or more text box's on top of the subreport And make them visible when the subreport doesn't have any data: Me.atextbox.Visible = Not Me.subreport.HasData To get rid of the blank space, set the subreport control's and its section's CanShrink property to Yes. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form has record displayed when open | rg32 | Using Forms | 4 | June 10th, 2005 08:50 PM |
Inspect record, replace null field on output | RNUSZ@OKDPS | Setting Up & Running Reports | 3 | April 5th, 2005 04:27 PM |
Do not show main record if sub reports null | ancient_hilly | Setting Up & Running Reports | 3 | March 10th, 2005 09:02 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
Gaps in Form "Record Number Boxes" | EricRod | New Users | 5 | March 5th, 2005 02:01 AM |