Solved

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

Posted on 2014-07-23
3
388 Views
Last Modified: 2014-07-24
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.
0
Comment
Question by:Liberty4all
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 37

Assisted Solution

by:PatHartman
PatHartman earned 250 total points
ID: 40216837
Sounds like a bug with the XPS format viewer so unless MS fixes it, there is nothing that can be done.  Please do report the issue to MS.  If people don't report issues, MS has no idea there is a problem.

Everyone should have the ability to print to PDF since that feature is included in Office.  With some versions, it might be a separate add-in that you have to download and install separately due to some licensing issue MS had.
0
 
LVL 15

Accepted Solution

by:
JimFive earned 250 total points
ID: 40217106
My guess would be that the lines are too thin, try setting the lines to 1pt instead of hairline.
0
 

Author Comment

by:Liberty4all
ID: 40218335
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.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
print previewing the record showing on the form 4 46
vb.net dbnull syntax 1 47
Access Query function 4 44
Ms Access 2010 Setup (Executable file) 4 56
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

736 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question