Search results

  1. S

    Problem with IIf/HasData and subreport sum

    I don't know if this has anything to do with it or not, but the subreport's child and master fields are both linked to the same text box in the main report.
  2. S

    Problem with IIf/HasData and subreport sum

    The sum is on the report footer of the subreport.
  3. S

    Problem with IIf/HasData and subreport sum

    Ok, I've done that now. But, when my subreport has values in multiple rows, the result is only the value in the bottom/last row, not a sum of all of the values. In the subreport report footer I have =sum([CountOfxxx]) and I named the control XXTotal in the properties Then in the main report...
  4. S

    Problem with IIf/HasData and subreport sum

    I'm using this format to display subreport data in a group footer on my main report: =IIf([subReportName].[Report].[HasData],[subReportName].[Report]![subReportTextboxNameName],0) However, if the subreport has data (true), I need the sum of the subreport field. I tried adding sum before the...
  5. S

    % of specific response in crosstab report

    Here's my crosstab report Answer Name1 Name2 Name3 Yes 90 95 85 No 10 10 35 Total 100 105 120 I need to devide the number of Yes responses for Name1 by the...
  6. S

    Calculating % of a specific crosstab response

    Here's my crosstab report Answer Name1 Name2 Name3 Yes 90 95 85 No 10 10 35 Total 100 105 120 I need to devide the number of Yes responses for Name1 by the...
Back
Top Bottom