Microsoft Dynamics AX (Archived)

Can I Make a Check Box in SSRS Report?

(0) Share

Report

Posted on by Momochi

1,036

Hello Awesome Community! I'm new to AX development still learning!

I want to have a box in my report that displays "✓" or "☒" if it equals a certain value in a field of the temp table.

I have done it using a text box with an "X" inside it and using a visibility expression to show and hide. But it does not look good haha. if there is a more better looking way more professional please inform me.

Thanks in advance!!!!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

I remember use of Wingdings font with chars 251 and 252. You can use expression as following

=IIF(Fields!YourFieldName.Value = 1, Chr(252), Chr(251))

Don't forget to select correct font

Was this reply helpful? Yes No
Suggested answer

Momochi 1,036 on at

Like (0)

Report

I've found video which was very helpful but there is a small issue.

https://www.youtube.com/watch?v=m2Ygkym-rtc

In my expression I want it to show a checked box if the data in the field is equal "05".

the checked box appears when the data is equal to 05, that's fine. But when the data does not equal 05, an empty box should appear but 5 different shapes appears instead of an empty check box.

Here is my expression for the text box:

=IIF(Fileds!BankTransType.value = 05, chr(254), chr(168))

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

You can use symbol using code 127

=IIF(Fileds!BankTransType.value = 05, chr(254), chr(127))

www.alanwood.net/.../wingdings.html

Was this reply helpful? Yes No
Momochi 1,036 on at

Like (0)

Report

Thanks Mr. Sohaib for your time and help!

I have this issue where when the expression is true it displays correctly but when the condition is false it displays multiple shapes....here are screen shots:-

When the expression is true:

When the expression is false:

Tried different codes but it still displays the same thing when the expression is false :(

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

have you tried char 127 ..?

Was this reply helpful? Yes No
Momochi 1,036 on at

Like (0)

Report

Yes I did but unfortunately it didn't work. Still shows the multiple shapes when it's false.

Was this reply helpful? Yes No