October 8, 2014 at 12:49 am
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
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
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
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