OT: Reporting services local reports

ajj3085 posted on Thursday, July 05, 2007

Hi,

I have a local report against my Csla business objects.

I have a table which lists line item details.  In the footer I'm trying to do a total but I need to exclude certain line items from the total (for example, I have a Subtotal line item and its amount should be ignored).

I tried using this expression:  =Sum( IIf( Fields!IsSubTotal.Value, 0D,  Fields!ExtendedPrice.Value ) ), but that simply results in #Error (helpful, huh?).

I've also tried inserting a custom code snippet into the report to abstract this away but the function does not show up: =Sum( Code.FilterSubtotal( Fields!Value.Value ) )

But it doesn't reconized FilterSubtotal as a valid function.

Any ideas?  Here's the sub:

Public Shared Function ConvertToDecimal( ByVal dec As String ) As Decimal
    Dim Result As Decimal

    If String.IsNullOrEmpty( dec ) Then
        Result = 0
    Else
        Result = Decimal.Parse( dec )
    End If

    Return Result
End Function

ajj3085 replied on Thursday, July 05, 2007

Ok, I got it figured out.  Forgot my build server isn't detecting changes properly at the moment..