 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / May 2008unable to subtotal from subreport
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 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?  SignatureDuane Hookom Microsoft Access MVP > 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 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 [quoted text clipped - 5 lines] >> >> Thanks HasData isn't well documented. You should try =IIf([NGLPurchaseQuery].[Report].HasData,[NGLPurchaseQuery].[Report]![Text13],0) SignatureDuane Hookom Microsoft Access MVP > I create a textbox with this in: > =([NGLPurchaseQuery].[Report]![Text13]) [quoted text clipped - 14 lines] > >> > >> Thanks Thanks for that HasData, it works wonder. >HasData isn't well documented. You should try >=IIf([NGLPurchaseQuery].[Report].HasData,[NGLPurchaseQuery].[Report]![Text13],0) [quoted text clipped - 4 lines] >> >> >> >> Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.