Hi,
You can use he below query as reference for getting the Option set text value in report. Hope it helps.
select
a.new_OrganizationType,
fsmc.Value as OrgTypeName
from Quote q
inner join Account a on q.accountid=a.accountid
inner join Opportunity o on o.OpportunityId=q.OpportunityId
LEFT OUTER JOIN FilteredStringMap AS fsmc ON
a.new_OrganizationType = fsmc.AttributeValue AND fsmc.AttributeName = 'new_OrganisationType' AND
fsmc.FilteredViewName = 'Filteredaccount'
where (q.QuoteNumber = 'Quotenumber')
Here new_OrganizationType is an option set.
Thanks,
Prasad
(If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".)