Post reply

Directional indicators and the PREVIOUS function in a report

  • October 8, 2014 at 12:49 am

    #291313

    Hello

    I have a report which gives a sales tally per month, so:

    Jan 200

    Feb 250

    March 240

    I have added a column to the right of this with the statement =IIf(previous(count(fields!sales.value)) < (count(fields!sales.value)), "y", "n")

    This works fine in that it will show "y" by Feb and "n" by March - showing if the month's tally is higher or lower than the previous month's. But what I would really like to do is add an up arrow instead of "y" and a down arrow instead of "n". I've tried various things, to no avail, so any advice would be gratefully appreciated.

    Thanks.

  • October 8, 2014 at 1:06 am

    #1750834

    Either use the indicators provided in SSRS, or use the Wingdings font.

    For example, é and ê translate in the up and down arrow.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 8, 2014 at 1:18 am

    #1750839

    Thanks very much for taking the trouble to get back.

    I have tried via indicators but am clearly doing something wrong - will keep trying.

    The Wingdings solution is a neat idea that I'll use until I work out how to get the indicators working properly.

    Thanks.

  • October 8, 2014 at 1:22 am

    #1750842

    faulknerwilliam2 (10/8/2014)

    Thanks very much for taking the trouble to get back.

    I have tried via indicators but am clearly doing something wrong - will keep trying.

    The Wingdings solution is a neat idea that I'll use until I work out how to get the indicators working properly.

    Thanks.

    By the way, for very large reports the wingdings alternative is much faster than indicators.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

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