Found the answer with Case When
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
It sounds like you need a CASE statement
case when productid = 27 then ‘Commercial’when productid = 29 then ‘Point of Service’
17 People are following this question.
How to break the content of a row
How to get sub total based on column that have decimals numbers in varchar ?
ReportServer report returns only 1 row