Error in totals when no data in subreport

Barry

Guest

Posts: n/a

2nd Jun 2010

Good Evening:
I have a report ("Invoice") which has 2 subreports, one for parts and the
other for labor. When either has no data the calculations for totals on the
main report show #error. I am having difficulty making the data from the
offending subreport zero (0). Any ideas as to how to force the situation
when no data exists in the particular subreport? Thanks much for reading
this.

Barry

« blank subreports appearing on every record of report | Colored Flags »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Totals: Group totals different from Grand totals	PsyberFox	Microsoft Excel Misc	1	13th Feb 2008 07:16 PM
Total from SubReport Data But Not in SubReport	Novice2000	Microsoft Access Reports	4	15th Jan 2008 10:19 PM
Page break before subreport if subreport has data	Kathy Webster	Microsoft Access Reports	1	17th Jul 2007 08:40 PM
SubReport within a SubReport	=?Utf-8?B?a2FiYWth?=	Microsoft Access	1	29th Apr 2005 08:16 PM
Making subreport labels invisible when there is no data in the subreport	John Baker	Microsoft Access Reports	1	28th Jul 2004 05:08 PM