Get Previous group value within the group

  • I have  grouping  on Account called Account and I am trying to display order date and order number in detail. but I don't want to repeat same order date and order number for same Account. and also it should not repeat  these info if it continue on 2nd page. 

    I tried this and it works but it also hide order date based on previous account. I want to validate only withing current account.
    IIF(Field!Order_date.value = previous(Field!order_number.value), true, false)

  • kk_tech - Tuesday, June 20, 2017 9:13 PM

    I have  grouping  on Account called Account and I am trying to display order date and order number in detail. but I don't want to repeat same order date and order number for same Account. and also it should not repeat  these info if it continue on 2nd page. 

    I tried this and it works but it also hide order date based on previous account. I want to validate only withing current account.
    IIF(Field!Order_date.value = previous(Field!order_number.value), true, false)

    We've got no way to know what your dataset is providing in the way of data, nor what your report actually looks like.  Please be more specific, and indicate not only what the problem is, but what you want to have happen.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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