Avatar of Dale Fye
Dale Fye
Flag for United States of America

asked on 

Checkboxes created in report (Visual Studio 2010) do not display properly in SSRS or render properly when exported to Word

I'm trying to recreate a report for a client, and in that report they have three fields Night, Weekend, Holiday (0 or 1) which need to be displayed as check-boxes.
In Visual Studio, I've made the column for these values .2" wide, have set the font to Wingdings, and have the expression which looks like:

= IIF(Fields!Night.Value = 0, chr(0168), chr(0254))
& IIF(Fields!Wknd.Value  = 0, chr(0168), chr(0254))
& IIF(Fields!Holiday.Value = 0, chr(0168), chr(0254))

In VS, this displays like the following image:2018-09-05-SSRS-Checkbox1.jpgBut after I deploy the report and run it in SSRS it looks like the following, making it difficult for the client to review the data in the report.2018-09-05-SSRS-Checkbox2.jpgIf my client exports this from SSRS to a .pdf file, it renders properly, but the client needs to export the report to Word (so that it can be edited) and when they do, that column automatically resizes itself so that these stacked checkboxes display horizontally.  My client recognizes that they can simply resize the column, but would prefer not to have to do so.2018-09-05-SSRS-Checkbox3.jpgI've tried inserting a carriage return/line feed between each character in the report textbox expression, but that results in extra spacing between the checkboxes.

I've also tried using 'X' and 'o' with the wingdings font, which places an X inside the checkbox, but the formatting issue still persists.

Does anyone have any recommendations?
SSRSMicrosoft WordMicrosoft Visual Studio

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon