Re: Repost-Still Suffering with Subreports
From: IreneJ (anonymous_at_discussions.microsoft.com)
Date: 08/24/04
- Next message: Noel: "Can a text field size be varied depending on content?"
- Previous message: Bart Schelkens: "Re: Hiding labels"
- In reply to: Duane Hookom: "Re: Repost-Still Suffering with Subreports"
- Next in thread: Duane Hookom: "Re: Repost-Still Suffering with Subreports"
- Reply: Duane Hookom: "Re: Repost-Still Suffering with Subreports"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Aug 2004 06:29:50 -0700
Good morning, thank you for responding. On each install
that we do, an installer can be paid extra job
categories, so I built a small subreport on the Volunteer
subreport that would take each group of values for a day
and put them together, the only way I knew to total, say
a whole day at a time, with 10 installs that all have a
lot of job cats was to use a running sum.
Example
Basic Install Job Cat 1 Job Cat 2 Job Cat 3
$39.00 20.00 15.00 30.00 Total 65.00
$39.00 15.00 30.00 Total 45.00
Total Basic Total Job Cats
78.00 65.00+45.00 = 110.00
It does seem that my problem seems to be attached to
these job categories though I think. Yesterday I tried
various methods of moving a total box to the report
footer (or even the date footer) of the Volunteer
subreport. Each time I do it and preview it I can see
the proper subtotal, say $110.00 properly. But the second
I take that field name and go to the main report and put
it in the date footer I get a skewed number, i.e. just
like the example above, I would only get a 45.00 showing
up instead of the $110.00, but if I move it to the Report
Footer on the Main Report it reports at $110.00.
Thanks again, I really appreciate this. I struggle with
what appears to be 'being just about there, but not
quite' and it's really frustrating.
Regards,
IEJ
>-----Original Message-----
>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
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Noel: "Can a text field size be varied depending on content?"
- Previous message: Bart Schelkens: "Re: Hiding labels"
- In reply to: Duane Hookom: "Re: Repost-Still Suffering with Subreports"
- Next in thread: Duane Hookom: "Re: Repost-Still Suffering with Subreports"
- Reply: Duane Hookom: "Re: Repost-Still Suffering with Subreports"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
