CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
user3690738
user3690738

Reputation: 27

SSRS insert text when currency value ='GBP' or 'EURO' or 'USD' ect

i have been trying to work out how i can get a ssrs expression to insert text if the following currency appear in my invoices.

I would like,

if currency value = 'GBP' then show text "please pay UK BANK 000x000x00" if currency value = 'Euro' then show text "please pay Euro BANK 000x000x00"

We have this to make the customer clear on which bank to pay into.

Upvotes: 0

Views: 120

Answers (1)

papermoon88
papermoon88

Reputation: 476

You can use SWITCH (similar to CASE in SQL) to display text based on the your value of the field. I have below an example with the sample you provided. Assuming your column name is "currency".

=SWITCH(
Fields!currency.value = "GBP", "please pay UK BANK 000x000x00",
Fields!currency.value = "Euro", "please pay Euro BANK 000x000x00")

Upvotes: 2

Related Questions