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
Need help on ssrs expressions
Farhan Jamil
416
Reputation points
Need help with ssrs. I am not sure how to write ssrs expression for the below screenshot. Any help will be much appreciated
{count} votes
-
AniyaTang-MSFT 3,051 Reputation points Microsoft Vendor
2023-03-13T09:32:07.7966667+00:00 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
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