unable to subtotal from subreport

[Syphonics via AccessMonster.com]

I am doing a general legder. I have plently of subreports which i put them
all into a final report.
There are times when some of the subreport will return no values, because of
no transactions on that particular date.
When I open the final report in report view I am able to get a "0" when there
is no value in the subreports. But when I do a print view, I get back an
#error.
How do I solve this problem.

Thanks

 

[Duane Hookom]

Could you provide the control source of the troublesome control or how you
are displaying the value? Are you using the HasData property of the subreport
control?

 

[Syphonics via AccessMonster.com]

I create a textbox with this in:
=([NGLPurchaseQuery].[Report]![Text13])

Assuming there is no data during 16/5/2008 for my purchases.
In my final report, this textbox appears a "0" in the report view. But when I
did a print view it gave me #Error.

I am not using the Has Data property, and I couldn't find that property

Could you provide the control source of the troublesome control or how you
are displaying the value? Are you using the HasData property of the subreport
control?

I am doing a general legder. I have plently of subreports which i put them
all into a final report.

[quoted text clipped - 6 lines]

Thanks

 

[Duane Hookom]

HasData isn't well documented. You should try
=IIf([NGLPurchaseQuery].[Report].HasData,[NGLPurchaseQuery].[Report]![Text13],0)

--
Duane Hookom
Microsoft Access MVP

I create a textbox with this in:
=([NGLPurchaseQuery].[Report]![Text13])

Assuming there is no data during 16/5/2008 for my purchases.
In my final report, this textbox appears a "0" in the report view. But when I
did a print view it gave me #Error.

I am not using the Has Data property, and I couldn't find that property

Could you provide the control source of the troublesome control or how you
are displaying the value? Are you using the HasData property of the subreport
control?

I am doing a general legder. I have plently of subreports which i put them
all into a final report.

[quoted text clipped - 6 lines]

Thanks

 

[Syphonics via AccessMonster.com]

Thanks for that HasData, it works wonder.

HasData isn't well documented. You should try
=IIf([NGLPurchaseQuery].[Report].HasData,[NGLPurchaseQuery].[Report]![Text13],0)

I create a textbox with this in:
=([NGLPurchaseQuery].[Report]![Text13])

[quoted text clipped - 14 lines]