Solved

Access report picture hidden lines

Posted on 2013-01-29
13
353 Views
Last Modified: 2013-02-12
Hi Experts,

I have inserted a picture in a report.

When i open the report in prwview mode zoom 100% it looks like picture "without line"

But if i zoom or create the report as PDF it looks like the picture "With line".

Why does it happen and how can i fix it. If i open the picture file and zoom there is no line.

The picture type is EMF. For some reason this give the best quality in the report.
without-line.JPG
with-line.JPG
0
Comment
Question by:DCRAPACCESS
[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
  • 7
  • 4
  • 2
13 Comments
 
LVL 25

Expert Comment

by:chaau
ID: 38833466
Unfortunately, it is a stupid feature of many report previewers (not only Access). The usual remedy here is to make the line "bolder". Even though, the previewer may decide to not draw lines in some cases
0
 

Author Comment

by:DCRAPACCESS
ID: 38834090
No the issue is that there should not be any lines :-(

I have made the border transparent, so it should only show the picture, nothing else.
0
 
LVL 25

Expert Comment

by:chaau
ID: 38834638
OK, I see. The line can be of the detail band or the header (if you put it there). Can you check its properties. As I said, you may not see it in the previewer by default. Try setting bigger zoom in the previewer, the line might be there as well
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38857234
<But if i zoom or create the report as PDF it looks like the picture "With line".>
This is an issue with how a your PDF converter will interpret the Access properties.
(It knows there is a always some sort of border, and it just draws it)

Can you state how you are creating the PDF and what version of Access you are using?

<border transparent>
Lets be clear...
There is a "BorderColor" Property, ...set this to: White
There is also a "BorderStyle" property, ...set this to: Transparent
Also make sure the "Special Effect" property is set to: Flat

JeffCoachman
0
 

Author Comment

by:DCRAPACCESS
ID: 38858251
Access 2007 and i'm using lebans reporttopdf
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38859873
With Access 2007 you can Download the free PDF converter
http://www.microsoft.com/en-us/download/details.aspx?id=9943
I use this for Access 2007 and newer with no "border" issues on PDF's
Report Image zoomed 200%, no border
I only use the Lebans utility for Access 2003 and older.
But to be sure, did you set all the properties I mentioned in my previous post? (in addition, please set the Border width property to "Hairline")

Finally make sure you are using a current version of your PDF "Viewer"
I only trust the Adobe free reader (or the full version) for viewing PDFs.

JeffCoachman
0
 

Author Comment

by:DCRAPACCESS
ID: 38863579
Sorry can't use the build in PDF creator, it has trouble making line charts. The quality is really bad. I have a old post about this problem and I have talked with one from microsoft support, and they don't support the PDF converter, it is something Adobe has made for them. That is why i have used Lebans. It is fast and the quality is good.
0
 

Accepted Solution

by:
DCRAPACCESS earned 0 total points
ID: 38863629
All the borders are correct. I have "fixed" by making a white thin box on top of the picture on each side, to hide the lines. But i don't like that solution even though it works.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38864115
<Sorry can't use the build in PDF creator, it has trouble making line charts. The quality is really bad.>
I have been using the PDF Add-in since it was first available, and never had these issues...

I am glad you got this fixed on your own.

You can now select you own post as the solution.
;-)

Jeff
0
 

Author Comment

by:DCRAPACCESS
ID: 38864874
Look at my old post:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24545766.html

The bad one is made with access add-in.

The other one is made with Lebans
0
 

Author Comment

by:DCRAPACCESS
ID: 38864887
Sorry not Lebans, Adobe Pro. But the result was the same. The line in the chart was not a clean line. And Microsoft Support tested it, and told me that it was not their problem, the add-in at I said is made by Adobe.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38865007
ok
0
 

Author Closing Comment

by:DCRAPACCESS
ID: 38879494
Not the best solution, but the best one i could find.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

623 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