Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to add PDF and/or .JPG files to a Report

Status
Not open for further replies.
yosteevo

yosteevo

IS-IT--Management
May 8, 2012
42
US
I am creating a report that will need to print PDF and/or .JPG files within the report.
The PDF and/or .JPG files will be unique for each report created.

I'm working with a LIMS database that runs along with SQL Server 2005 that allows me to upload files to a specified directory contained on my database. (which in turn creates a unique file name for each PDF and/or .JPG file)

How is this done?


Thanks
Stephen
 
Sort by date Sort by votes
Is this going to be a printed report only, or is this an electronic report ? Are your PDF or JPG files strictly graphics ?
Does your report generator have a graphics function built-in? This reminds me of working in Revelation G2b many years back, where another company built an add-on product called R/Graph, which would generate graphics from within the R/Basic code used in the Revelation product. Have you considered dropping your report info into Excel, and using templates or macros there to create the graphics ?

Fred Wagner

 
Upvote 0 Downvote
Hello Fred,

Yes, this report is to be printed. The PDF and .JPG files are documents with both text, graphics, and digital photographs. So these image files will need to be placed directly into crystal reports.

I am using Crystal Reports 2008.

Also, these image files will be different for every report and there may be anywhere from 1-15+ images to be pulled into each report.

The LIMS software allows users to upload their PDF or .JPG images to the LIMS Server and then each file is given a unique file name.

 
Upvote 0 Downvote
This sounds like a challenge for the Crystal Reports forum. If you were working directly in Acrobat Pro for a single report, you could insert the pages of PDF's and JPG's directly into the PDF, and perhaps even generate consecutive page numbering to include the inserted pages.
Since you are doing a large batch printed report, essentially a custom merge for hundreds or thousands of reports, the solution will be in the way Crystal assembles the output. Acrobat might not even be directly involved. Perhaps someone who's done this successfully will jump in with the answer!

Fred Wagner

 
Upvote 0 Downvote
A quick use of the Search window on this site brought up a product called Automation Anywhere - sounds like its designed for your task.

Fred Wagner

 
Upvote 0 Downvote
Are you part of the Blaze Systems integration team, or are you part of the end user organization ? This sounds like something that should have been included in the scope of the original project.

Fred Wagner

 
Upvote 0 Downvote
I am one of their end users.
I am the LIMS Database / IT Technician for my employer.
I'm consistently updating configurations to a LIMS database and building ongoing custom reports for my department.


 
Upvote 0 Downvote
From your description of the report system you're trying to build, the Automation Anywhere product sounds like something that would get the job done directly, if your budget allows.

Fred Wagner

 
Upvote 0 Downvote
Automation Anywhere seems similar to "Photoshop Actions" within Adobe Photoshop. This is not what I am looking for actually.


What I am attempting to do is to have static OLE objects placed into a crystal report. These will be screen shots of Excel tables.

Every time this crystal report is run, it will need to reference a different image file from our LIMS server. All of these image files are unique by file name and can be linked by a database field from the LIMS database.


Thanks
Stephen
 
Upvote 0 Downvote
I also have the ability to pull the file names into my report.
I just need to have the file graphically displayed within my report.

Also, this will be configured into a subreport within Crystal Reports.
 
Upvote 0 Downvote
Steve - the expertise you need will be found over the the Busines Objects: Crystal Reports forum, perhaps even using XML or XPS as the output format. Take a look in the #2 forum for Data Access....

Fred Wagner

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Colema2
  • Locked
  • Question
Problems with adding grayed out text to a PDF text field (entered text should display black)
Replies
0
Views
921
Colema2
Colema2
Cyoung223
  • Locked
  • Question
Buttons for adding and removing page templates in PDF form
Replies
0
Views
1K
Cyoung223
Cyoung223
SarahSCPDAdmin
  • Locked
  • Question
Adobe Acrobat Fillable Form with Checkbox and Values
Replies
2
Views
1K
SarahSCPDAdmin
SarahSCPDAdmin
Rivvie99
  • Locked
  • Question
Fillable PDF Forms - Text Field, Spacing Between Characters
Replies
2
Views
1K
Rivvie99
Rivvie99
Rasheed5FA5
  • Locked
  • Question
Convert PDF tables to XML
Replies
1
Views
817
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top