WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: Accessible SQL Server Reports


From: Bourne, Sarah (MASSIT)
Date: May 30, 2019 12:23PM


Our Department of Transportation (DOT) ran into this issue. In short, Microsoft was using an ancient engine in their SQL Server Reporting Service (SSRS) to produce PDFs. The PDF version predated the PDF/UA format and thus didn't support it.

DOT was finally able to get in touch with the right people to understand the magnitude of the problem we (and others!) faced. Tickets were created! Work was started! They told us last July, "The last update I have from the product team is that the capability would be available in the next update around CY19Q3."

They suggested two workarounds until the update:
1. Build RDL formatted reports from SQL Server data using SSDT and then publish through Power BI using the new export to accessible PDF option.

2. Use SSRS to render reports in MS Word format (as an intermediate step) and then call a VB script file to automatically convert the intermediate MS Word format to accessible PDF.
Hope this helps!
Sarah E. Bourne
Director of IT Accessibility
1 Ashburton Place, 8th Floor, Boston, MA 02108
Office: (617) 626-4502
<EMAIL REMOVED> | www.mass.gov/eotss<;http://www.mass.gov/anf/research-and-tech/oversight-agencies/itd/>;
Executive Office of Technology Services and Security (EOTSS)
EOTSS provides secure and quality digital information, services, and tools
to constituents and service providers when and where they need them.

From: WebAIM-Forum < <EMAIL REMOVED> > on behalf of Peter Shikli < <EMAIL REMOVED> >
Sent: Tuesday, May 14, 2019 10:31 PM
To: WebAIM Forum
Subject: [WebAIM] Accessible SQL Server Reports

When remediating PDFs, we're always looking to migrate up the food chain
to the source document, often an MS Word or Excel template. In this
case, we have a PDF table generated as a report from Microsoft's SQL
Server Database. Much better than remediating the PDFs, which are
generated regularly with current data, would be to instruct SQL Server
to add the accessibility tags to the report tables, such as header
tags. We have experience building transactional applications using PHP
that source SQL Server data, but not with a focus on accessibility.

Has anyone come across reusable report instructions, or at least
guidelines, to generate accessible SQL Server reports, or have ideas
where to look? Google seems curiously silent on the subject.

Peter Shikli