This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 69%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFJ%3C/text%3E%3C/svg%3E)
Need help with ssrs. I am not sure how to write ssrs expression for the below screenshot. Any help will be much appreciated
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @Farhan Jamil
I don't quite understand what you mean. What does your raw data look like? What do you want the expression to do? What is the meaning of these fields?
Best regards,
Aniya
Hi @AniyaTang-MSFT . This is a subset of base data. I am getting this result from a SP. Can't make changes in SP. Hence thought ssrs expression is the only way to achieve result in this fashion. Basically it is an audit dataset wherein I have to fetch only those data which fit under the category mentioned above. To clarify, I have scores of both of these columns from 1 to 5 . So scores are like 1-1,1-2,1-3,1-4,1-5 etc. And from those scores I Need the one which I have highlighted in the screenshot. Hope this answers the question
Hi @Farhan Jamil
I still don't quite understand what you mean. So the screenshot is your source data, right? What do you mean by data that fits the above categories? I don't quite understand what the one you're trying to highlight is, is it the RQ score column? Please provide more information and I will test it for you tomorrow.
Regards,
Aniya
Hi @Farhan Jamil
Has your issue been resolved?
If you need me to test, please provide me with more detailed information.
Best regards,
Aniya
Hi Aniya. I resolved it myself. I made my change in SP by using simple case statement. I could see that it resolved the issue
And what's the requirement / logic for the wanted result? How does the base data look like?
See Expression examples in paginated reports (Report Builder) for more details & examples.
Hi Olaf. This is a subset of base data. I am getting this result from a SP. Can't make changes in SP. Hence thought ssrs expression is the only way to achieve result in this fashion. Basically it is an audit dataset wherein I have to fetch only those data which fit under the category mentioned above. To clarify, I have scores of both of these columns from 1 to 5 . So scores are like 1-1,1-2,1-3,1-4,1-5 etc. And from those scores I Need the one which I have highlighted in the screenshot. Hope this answers the question