SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,232 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Need help with ssrs. I am not sure how to write ssrs expression for the below screenshot. Any help will be much appreciated
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
Hi @Farhan Jamil
Thanks for your feedback, I'm glad your issue was resolved.
Regards,
Aniya
Sign in to comment
1 answer
Sort by: Most helpful
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
Sign in to comment