Link to home
Start Free TrialLog in
Avatar of Bryan Schmidt
Bryan SchmidtFlag for United States of America

asked on

Exporting Access 2010 reports in XPS format results in multiple horizontal lines not appearing

When exporting Access 2010 reports in XPS format many horizontal lines that separate rows do not appear.  The number varies from one page to another, and report length doesn't impact how many rows are affected.  Most reports contain no sub reports, but for those that do the results don't change.  When printing XPS reports to PDF the missing lines appear so they are obviously there.  Most users do not have the ability to print to PDF so converting XPS files to PDF is not an option for them.

While exporting reports in PDF format would be the best alternative, for some users that process takes much longer.  Reports are exported by state or area and it can take up to 30 minutes or more for that to complete.  Exporting in XPS format reduces the time in half but the end result looks unprofessional with missing lines appearing throughout the reports.  If there is a way to have the missing lines appear it would make everyone happy.

If someone has an explanation for this, or knows how to make all lines visible in XPS format, I would appreciate learning the solution.
SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bryan Schmidt

ASKER

I increased the width of the lines from hairline to 1 pt and that seemed to fix it.  What's interesting is that most of the lines in my reports are hairline width but only some do not appear.  I think Pat Hartman is correct about this being a bug.  I tried reporting it to Microsoft directly but could not find an email address specifically for that, and could not locate a website that is designed for it.  Their published list of products accepting bugs or suggestions does not include XPS.  I called Microsoft and got transferred multiple times before finally being told that since my employer owns the Office 2010 license I need to submit the request through my employer's liasion with Microsoft.  I will do that and thank both of you for responding to my question.