Forum Discussion
How To Lookup A Specific Value in Report Builder
While this question remains unanswered, I ended up taking a piece of a query from one of the data sets in use to create yet another data set. That new data set is laid out in a manner where I can just use the field corresponding to each expression I want to have in my textbox, as opposed to trying to do what I was initially doing. I haven't ruled out that what I was trying to do isn't even possible at this point. While I'm able to resume my developments now, if anyone ever comes up with an answer to his, I would love to hear it, as it might come in handy as I get more into using Power BI (Desktop and/or Report Builder).
Super UserIt's hard to say for sure, but you might be able to do what you are asking using the Lookup function in your text boxes - see https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-lookup-function?view=sql-server-ver15
d_gosbell lookup function unfortunately does not work inside textboxes.
I have found a solution that involves having your dataset as a value-label pair in Parameters (create a new parameter with the dataset in question as source). Then you will need to write a custom function that will retrieve a label from the parameter value that you can use in a textbox.
This tutorial explains it quite well (on an example of localization): https://www.youtube.com/watch?v=lZYMeOaAd7U
It is in Greek, but you can follow it quite well nonetheless. I hope this helps.