Solved

Access report picture hidden lines

Posted on 2013-01-29
13
348 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
  • 7
  • 4
  • 2
13 Comments
 
LVL 24

Expert Comment

by:chaau
Comment Utility
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
Comment Utility
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 24

Expert Comment

by:chaau
Comment Utility
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
<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
Comment Utility
Access 2007 and i'm using lebans reporttopdf
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:DCRAPACCESS
Comment Utility
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
Comment Utility
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
Comment Utility
<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
Comment Utility
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
Comment Utility
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
Comment Utility
ok
0
 

Author Closing Comment

by:DCRAPACCESS
Comment Utility
Not the best solution, but the best one i could find.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now