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:
But 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.
If 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.
I'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?