Re: Calculation in a report

Thanks, Jana!

My report works as far as separating the categories and giving me
subtotals. What I need is for the category subtotals to be subtracted
from a number to show available funds. I got the grand total to work by
simply adding an unbound field and putting the code
=Sum(200000-[AmountRequested]). However, the "group" footer has a long
code that seems to be what makes the report brake out according to my
specifications. That code reads as follows: ="Summary for " &
"'GrantType' = " & " " & [GrantType] & " (" & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") & ")". How can I
incorporate my =Sum in this?

Thank you so much for responding. I really appreciate it.

Best,
Pat

.

Relevant Pages

  • Re: errors in Crystal Reports .NET subtotals and grand totals
    ... the grand total does not match the sum of the subtotals... ... Subtotals and grand totals sum EVERY detail record ... whether or not they actually appear on the report. ... setting the conditional calculation to perform only when the section is ...
    (microsoft.public.vb.crystal)
  • Re: Report Subtotals - Repost - Thanks!
    ... The report is grouped by year, ... >> I have a report that creates subtotals for monthly sales, ... >> footer for annual sales and finally a footer for grand totals. ...
    (microsoft.public.access.reports)
  • Re: How do I automatically add rows...
    ... Another way sticking strictly to subtotals (no conditional formatting, ... then select all of your used rows (optional won't change printed report), ... series of Excel tutorials ...
    (microsoft.public.excel.misc)
  • Re: Adding two subtotals from two subreports in a main report
    ... Once I try putting the brackets around them and go to view the report it ... "Duane Hookom" wrote: ... So my subreport names are LABOUR R & PARTS R the subtotal fields are ... they have a text box named "txtRptTotal" containg the subtotals ...
    (microsoft.public.access.reports)
  • Re: Sort on Subtotals in an Access Report
    ... I use Crystal Reports which allows you to sort by subtotals much more ... > totals query to your report's record source and join the City fields. ... > can then use the CountOfEmployees from the totals query to sort your report. ... >> I have a grouped report by City and a list of employees in each city. ...
    (microsoft.public.access.reports)