Post reply

Help Adding a calculated field on a SSRS chart

  • July 1, 2010 at 6:21 am

    #234625

    Hello all,

    I'm working on a report to get a projection for some data, I need to add some data to the chart which is a matter of drag and drop for any data field in the existing dataset, but what about a calculated field?? how can I do it?

    when I try to add a calculated field to the dataset, it gives error "The expression used for the calculated field '=Sum(Fields!Total2010.Value)/DateDiff("d", "01/01/2010", Parameters!Day.Value)*365' includes an aggregate function. Aggregate functions cannot be used in calculated field expressions"

    and I can't find a way of adding it directly to the chart

    any help will be appreciated please.

    Thanks

  • July 7, 2010 at 10:10 am

    #1189722

    Hi,

    If I have understood your scenario correctly, rather than adding a post calculated field to an existing dataset, add the calculated column to the dataset...:hehe:

    So if you retrieve the data via a stored procedure, add the calculated columns to the stored procedure.

    HTH,

    gsc_dba

    gsc_dba

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply