Summary in Reporting Services - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Summary in Reporting Services

Author

Topic

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-06-21 : 16:58:29

I am an trying to create a Summary of a clients activity and the date of the activity in the Activty Footer of RS

="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.

="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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-25 : 14:44:25

it should be something like

="Summary for " & "'Activity' = " & " " & Fields!Activity.Value & " ( " & CountRow(your scope value here) & " " & IIf(CountRow(your scope value here)=1,"detail record","detail records") & ")"

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-06-26 : 11:32:05

thank you Visakh16 I figured it out, heres what worked
="Summary for State Services '" & Fields!State_Services.Value & "' = (" & CountRows() & " Detail record" & IIf(CountRows()=1,"","s") & ")"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-26 : 14:17:54

welcome

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources