The field of OTS country in the drop down show text but in SSRS, it shows number. I think it is index to the country field. I want to know how to get or refer to the text in SSRS?
Thank you guys
What’s the context? Customizing an exist repor, or making a BAQ report?
I would like to customize an exist report in Report Builder. However, when I select the expression of this field, the result is the number of country, because the field is CountryNum. I would like to show the country description e.g. 3 = canada. I know that I can use switch case in the expression or create another table for lookup. Thank you
is the country name field available in the RDD? If so it might already be in the dataset for the report’s RDL
Actually, there is country field in the RDD which is show the name of each country. I think I also can use lookup for this one as well. Thank you