Post reply

Creating aggregates on SSRS

  • June 22, 2013 at 12:32 am

    #274275

    Hi Everyone,

    I have been working on a SSRS report and could not make it work.

    I have a data set like shown below:

    Data Set

    ItemOrder OrdQtyCompQtyCost

    XZ 10 A 441

    XZ 10 B 545

    XY 5 C 624

    XY 5 D 421

    XW 20 E 240

    I would like to have a result like shown below:

    Result

    ItemOrderOrdQtyCompQtyCost

    XZ10 A441

    B545

    OrdTotal10 986

    Y5 C624

    D421

    OrdTotal5 1045

    W20 E240

    OrdTotal20 240

    ItemTotal35 9171

    9I was wable to get right ItemTotal for Qty

    171I was able to get right ItemTotal for Cost

    35I could not get this working. I tried expression sum(avg(OrdQty))

    I was able to get right value for Qty and cost but I could not get a right value for ItemTotal by trying few things. One of the expressions I tried is shown above. Any help will be highly appreciated.

    Thanks

    Sar

  • June 22, 2013 at 1:37 pm

    #1626572

    I suspect the problem can be resolved by applying a "scope" to one or both of your aggregate functions. It is difficult to tell for sure because of the lack of formatting in your post. Perhaps a screenshot showing the tablix and highlighting the value that you are having trouble with would help clarify the solution.

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

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