Microsoft Dynamics CRM (Archived)

Display custom field on report

(0) Share

Report

Posted on by Community Member

Dear all,

In an Invoice form I have a list box selection filled which are filled in with CODES like :

AFD
FGDS
FD545
ERT89

each code is linked with a specific text string to be display on report

For example if user select items code "ERT89", then I should display on report text : "VAT expemted on export delivery". if user select an other code it will be another text.

How can I display corresponding text based on selection ?

regards

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

Magor Kovacs 1,835 on at

Like (0)

Report
Copy link

Link copied!

Hello Sergec,

Yes, this is possible, via an expression in the SSRS report. Please refer to: msdn.microsoft.com/.../ms157328.aspx

Decision Functions

The Iif function returns one of two values depending on whether the expression is true or not. The following expression uses the Iif function to return a Boolean value of True if the value of LineTotal exceeds 100. Otherwise it returns False:

Use multiple IIF functions (also known as "nested IIFs") to return one of three values depending on the value of PctComplete. The following expression can be placed in the fill color of a text box to change the background color depending on the value in the text box.

Was this reply helpful? Yes No
Verified answer

Mamatha Swamy 5,426 on at

Like (0)

Report
Copy link

Link copied!

You can use a 'Switch' function in SSRS Expression to display text related to the code

Refer http://weblogs.sqlteam.com/joew/archive/2008/08/20/60693.aspx

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergec,

Do you mean in the SSRS?

You need to use expression IIF

for example:

=IIF(Fields!fieldselection.Value >= "ERT89", "VAT", IIF(Fields!fieldselection.Value = "fieldselection", "VAT2", "NOVALUE"))

Or Switch Case

For example:

=SWITCH(Fields!fieldselection.Value = "ERT89", "VAT",

Fields!fieldselection.Value = "AFD", "VAT2",

Fields!fieldselection.Value = "FGDS", "VAT3",

Fields!fieldselection.Value = "AAAAS", "VAT4",

Fields!fieldselection.Value = "ABCDHigh", "VAT5")

And put in to the display text value expression.

Are you referring to that expression?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Switch command work nicely.

Thanks to all of you

Was this reply helpful? Yes No