"Mike" <mike.no.spam.please@no.spam.com> wrote in message
news:uPiZkQH3EHA.3840@tk2msftngp13.phx.gbl...
>I am having trouble get the Total on a column, i get the following error:
>
> c:\inetpub\wwwroot\cireports\PurchaseDetails.rdl The value expression for
> the textbox 'textbox15' uses an aggregate function on data of varying data
> types. Aggregate functions other than First, Last, Previous, Count, and
> CountDistinct can only aggregate data of a single data type.
>
>
> This is what i have, the report needs to not include a certain value if
> it meets a certain condition, also to note the stored procedure that feeds
> this report is used in several other parts of the application that this
> report is working with, so it is not possible to change the stored
> procedure to do the calculations in the stored procedure.
>
> In my Dataset I created a Calculated Field called 'Amt' with the following
> expression
> =IIF(Fields!Col1.Value = "Condition",0,Fields!Col2.Value)
>
> Then in the Report Designer I created a Report with the following Detail
> Columns
> =Fields!Col1.Value,
> =Fields!Amt.Value,=Fields!Col3.Value,=Fields!Amt.Value-Fields!Col3.Value
>
> Then in the Report Footer I have the following:
>
> For the =Fields!Amt.Value Column I have =Sum(Fields!Amt.Value)
> For the =Fields!Col3.Value Column I have =Sum(Fields!Col3.Value)
> For the =Fields!Amt.Value-Fields!Col3.Value Column I have
> =Sum(Fields!Amt.Value-Fields!Col3.Value)
>
>
> Everything works except the =Sum(Fields!Amt.Value) total column
>
>
> Can anyone explain why 2 of the fields that use the Calculated Field as
> part of a formula work but the one that is suppose to Sum up the column
> does not.
>
> Thanks
> Mike
>
>
>
>
>
>
>