Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Interpret for RS

    this was in the grouping of an access database report I need to put into RS report but I keep getting error messages.



    ="Summary for " & "'Primary Catagory' = " & " " & [Primary Catagory] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"

  2. #2
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    I am an trying to create a Summary of a clients activity and the date of the activity in the Activty Footer of RS

    Code:
    ="Summary for " & "'Activity' = " & " " & Fields!Activity.Value & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
    I get an error message that says "an error occurred during report processing, the value expression for textbox57 uses the function "count(* scope)", this function is no longer supported us CountRow(scope) instead so I did then I got another error message when I used this, then I got another error mesage saying textbox 57 contains an error[BC30205] end of statement expected.

    Code:
    ="Summary for " & "'Activity' = " & " " & Fields!Activity.Value & " (; & CountRow(scope) & " " & IIf(CountRow(scope)=1,"detail record","detail records") & ")"
    this is what I'm aiming for "Summary for 'State Services' = Cultural (1 detail record)"
    can anyone help plse
    Last edited by desireemm; 06-21-09 at 17:56.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This is an untested SWAG, but:
    Code:
    = "Summary for '" & Fields!Activity.Value & "' = (" & CountRow(scope) & " Detail record" & IIf(CountRow(scope)=1,"","s") & ")"
    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    says name countrow is not declared

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Quote Originally Posted by Pat Phelan
    This is an untested SWAG, but:
    Code:
    = "Summary for '" & Fields!Activity.Value & "' = (" & CountRow(scope) & " Detail record" & IIf(CountRow(scope)=1,"","s") & ")"
    -PatP

    thank you Pat I got it now, it was CountRows()

    Code:
    ="Summary for State Services '" & Fields!State_Services.Value & "' = (" & CountRows() & " Detail record" & IIf(CountRows()=1,"","s") & ")"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •