Re: Repost-Still Suffering with Subreports

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 08/24/04 

Date: Mon, 23 Aug 2004 22:52:02 -0500

Since you have link master child set to the date field, I would place the
totals in the subreport in the report footer. Is there a reason why you are
using a running sum for TotalGroupRS rather than a regular Sum()? 

-- 
Duane Hookom
MS Access MVP
"IreneJ" <anonymous@discussions.microsoft.com> wrote in message
news:ba7401c4893e$d75201b0$a401280a@phx.gbl...
> Good morning,
> In subreport 1 (Volunteer), VGAmounttoContractorTotal is
> in the Date Footer.  VGAmounttoContractorTotal is a total
> field comprised of =[VDAmounttoContractorTotal]+
> [DTotalJobCats].  DTotalJobCats is a field comprised of =
> [TotalGroupRS], a running sum of some job categories from
> the Date Footer.
>
> I checked all the other reports and all the other totals
> come from the Report Footer.  I was having so much
> trouble summing the job categories and the billing amount
> to the contractor in the Volunteer report that I moved
> the total to the Date Footer but I did have it in the
> Report Footer also at one point but trying to add two
> fields together was causing me grief so I moved it.
>
> Thanks for trying to help me with this.  I really
> appreciate any help, it's making me crazy.  I thought
> that subreporting would be fairly easy but it hasn't been
> at all!
> Thanks again,
> Irene
>
>
> >-----Original Message-----
> >Where in the subreport, do you get
> VGAmounttoContractorTotal from? Is it in
> >the report footer section or a date footer? How about
> other totals on
> >subreports?
> >
> >-- 
> >Duane Hookom
> >MS Access MVP
> >
> >
> >"IreneJ" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:b06701c488af$c316c440$a601280a@phx.gbl...
> >> Is anyone able to help with me with this posted on Aug
> >> 19. Thank you,
> >> Hello again, still having multiple problems getting
> four
> >> subreports on a main report to print items from each by
> >> date.  Have made some head way with your help provided
> >> but now have another problem.
> >>
> >> I have subtotal boxes in the date footer on the main
> form
> >> for the amounts from each form i.e. Subreport1 -
> 208.00.
> >> Each one of the total boxes has:
> >> =IIf([Subreport1].Report.HasData,[Subreport1].Report!
> >> [VGAmounttoContractorTotal],0) so that if the report
> has
> >> no data that the field is populated with 0.00. (This
> part
> >> seems to work okay)
> >>
> >> I have found that if any one of the subreports doesn't
> >> have any data to report i.e. Subreport 1 - 208.00,
> >> Subreport 2 - 0.00, the total box for Subreport 1 will
> >> skew the data and give me a false number such as 143.00
> >> instead of the 208.00. As long as the reports have
> >> information in them, Subreport 1 will produce the
> correct
> >> amount in the total box.
> >>
> >> Anyone have any ideas about what might be going on.  Is
> >> there anything specific that subreports have to have
> make
> >> them run correctly.  I have found a way to put
> link/child
> >> fields on all of them so that they have an attachment
> to
> >> a date which they didn't have before, they had
> prevously
> >> just been unlinked on the main report.
> >>
> >> Thanks,
> >> Irene
> >>
> >
> >
> >.
> >

Relevant Pages

  • RE: Errors in Report total fields
    ... subtotal control ... Are PaymentTotal and ExpenseTotal in the REPORT footer of each subreport? ... reports to get their totals data from the fields of the report which come ...
    (microsoft.public.access.reports)
  • Re: subreport/report total question
    ... In the subreport, move your DayTotal text box into the Report Footer ... Page Header ... job totals always match the Work_Date totals because it gives me a job ...
    (microsoft.public.access.reports)
  • RE: Errors in Report total fields
    ... reports to get their totals data from the fields of the report which come ... two provide a subtotal for the main report. ... Subtract subreport 3 total from Main Report subtotal to get grand total: ... A button on the second form opens a preview of the invoice report. ...
    (microsoft.public.access.reports)
  • Re: Repost-Still Suffering with Subreports
    ... I haven't had to nest two subreports on a report. ... > footer and let you know how I make out. ... > When calling a subreport on a subreport is there a proper ... >>>>> totals ...
    (microsoft.public.access.reports)
  • Re: crystal report subreport - leaves space for main rpt footer
    ... I have a crystal report that I have a subreport in the group header. ... link the main report to the subreport by a customer id. ... Use this group footer for your totals. ...
    (microsoft.public.vb.crystal)
Loading