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?
LVL 53
Dale FyeOwner, Dev-Soln LLCAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Well you are not alone with this problem..lets say that a lot of people want to display checkboxes on SSRS reports....well this guy here has developed an image based solution that looks good
Jim HornSQL Server Data DudeCommented:
(Potentially stupid question)  Why are we displaying a checkbox, which implies user interaction, on an SSRS report which by definition does not allow user interaction?

It would be more intuitive to display something that does not imply that it's editable, such as the value itself, or as John says come up with an image.
Dale FyeOwner, Dev-Soln LLCAuthor Commented:

I'll take a look at that article.


Because the SSRS report has to emulate a state approved form.  The checkbox is not designed to be editable, but to merely replicate the appearance of this state approved form.

I've mentioned to the client that if they need to edit the report, after running it, then those changes should go in the database, but have lost that argument.
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Jim HornSQL Server Data DudeCommented:
Ahh.  That would do it.  The image route will probably be less aggrevation then trying to get a checkbox to render correctly both in SSRS and in an export to Word.
Russell FoxDatabase DeveloperCommented:
Split the single row into three rows (red lines), and then remove the borders between the rows where it's supposed to look like a single row (yellow area):
Row split
Dale FyeOwner, Dev-Soln LLCAuthor Commented:

I attempted to do that, but was unable to merge the cells in other columns that should span multiple rows, in many cases 5 or 6 lines of text.

Dale FyeOwner, Dev-Soln LLCAuthor Commented:
At this point, I cannot even remember what I did to resolve this, think it was a combination of a number of responses I found on other web-sites.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.