Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-12-2018, 10:12 PM   #1
SAE
Newly Registered User
 
Join Date: Feb 2018
Posts: 21
Thanks: 9
Thanked 0 Times in 0 Posts
SAE is on a distinguished road
pdf in Report

I have a DB where i have a list of clients and links (via a hyperlink field) to various documents they have sent us.

What i am trying to do i run some filters to filter the documents and then run a report that lists the various clients and the pdfs (usually letters) they have sent us.

Query and filters work fine but I have hit a brick wall when it comes to running a report that shows the pdfs.

Is this at all possible? I have been searching the web for a couple of days and can't find a way to do it. Most responses regard to displaying a pdf in a sub-form on a form, but I need the option to filter and include them in a report.

Note for my queries and filters I could end up with 50-100 pdfs so having to manually filter and group them isn't my preferred route.


TIA,


Simon

SAE is offline   Reply With Quote
Old 07-12-2018, 10:53 PM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,352
Thanks: 2
Thanked 1,971 Times in 1,927 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: pdf in Report

Do you want to show the content of the pdf files, or to include the pdf files, in the report?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 07-12-2018, 11:17 PM   #3
SAE
Newly Registered User
 
Join Date: Feb 2018
Posts: 21
Thanks: 9
Thanked 0 Times in 0 Posts
SAE is on a distinguished road
Re: pdf in Report

not sure the difference. between showing the pdf and including the pdf.

I want a report that says Client A, and then has 3 letters following it. Client B then 2 letters following it.

I want to show the contents of the subsequent pdfs and not just a list of names or their link reference.

Hope this clears it up.

Thx,


SAE

SAE is offline   Reply With Quote
Old 07-16-2018, 10:27 AM   #4
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,150
Thanks: 20
Thanked 859 Times in 844 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: pdf in Report

If you are just looking to list the reports they have sent then you can use a Main Report|Subreport scenario.

Main Report - Include ClientID
Subreport - Include the query that lists the documents and the ClientID

Make the Main report and the subreport , save and then drop the subreport on the main report. They should automatically connect based on the ClientID. Then make it look presentable.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 07-16-2018, 11:01 AM   #5
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 1,491
Thanks: 14
Thanked 272 Times in 270 Posts
Mark_ will become famous soon enough
Re: pdf in Report

SAE,

Are you trying to, effectively, have the contents of the various PDFs appended one after the other in some type of display that can also print? Or do you simply want a header list that can open each PDF when clicked upon? Also does this need to be something you can send to others?
Mark_ is offline   Reply With Quote
Old 07-16-2018, 05:51 PM   #6
SAE
Newly Registered User
 
Join Date: Feb 2018
Posts: 21
Thanks: 9
Thanked 0 Times in 0 Posts
SAE is on a distinguished road
Re: pdf in Report

Quote:
Originally Posted by Mark_ View Post
SAE,

Are you trying to, effectively, have the contents of the various PDFs appended one after the other in some type of display that can also print? Or do you simply want a header list that can open each PDF when clicked upon? Also does this need to be something you can send to others?


Yes, this needs to be something I print out, so having a link that I click on isn't an option.

As you said, I need a header followed by subsequent pdfs, then another header, then more pdfs.

Also, I thought reports weren't interactive so I couldn't put an active link in a report anyway.
SAE is offline   Reply With Quote
Old 07-16-2018, 06:09 PM   #7
SAE
Newly Registered User
 
Join Date: Feb 2018
Posts: 21
Thanks: 9
Thanked 0 Times in 0 Posts
SAE is on a distinguished road
Re: pdf in Report

Quote:
Originally Posted by GinaWhipp View Post
If you are just looking to list the reports they have sent then you can use a Main Report|Subreport scenario.

Main Report - Include ClientID
Subreport - Include the query that lists the documents and the ClientID

Make the Main report and the subreport , save and then drop the subreport on the main report. They should automatically connect based on the ClientID. Then make it look presentable.

Gina, I don't just want a list of document, I want to actually display the documents.

The report is set up as you describe with a sub report linked to the main report via ID_Client field. In my subreport I have a hyperlink field with the link datafield as the Control Source. But all this shows in a list of hyperlinks, not the actual documents.

Is there another field type that can show the actual pdf and not just its path ???

Thanks,


SAE

SAE is offline   Reply With Quote
Old 07-16-2018, 08:37 PM   #8
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,150
Thanks: 20
Thanked 859 Times in 844 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: pdf in Report

I realized that after I read your reply to Mark. The only that comes to mind, short of turning them into images, is an OLE Object. I have never done that and not sure how well it work.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 07-16-2018, 09:29 PM   #9
SAE
Newly Registered User
 
Join Date: Feb 2018
Posts: 21
Thanks: 9
Thanked 0 Times in 0 Posts
SAE is on a distinguished road
Re: pdf in Report

Quote:
Originally Posted by GinaWhipp View Post
I realized that after I read your reply to Mark. The only that comes to mind, short of turning them into images, is an OLE Object. I have never done that and not sure how well it work.

That's pretty much the route I am about to try. I just need people to get out of the BE so I can add an OLE field to the table. I'll then try with either pdf or scan some docs to jpg and see how that goes.
SAE is offline   Reply With Quote
Old 07-16-2018, 10:06 PM   #10
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,150
Thanks: 20
Thanked 859 Times in 844 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: pdf in Report

I would suggest you make a copy of the backend and TEST first. Do not attempt this on a live backend. If it works great then you can implement but if it doesn't you didn't inconvenience anyone.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 07-16-2018, 10:29 PM   #11
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,352
Thanks: 2
Thanked 1,971 Times in 1,927 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: pdf in Report

Only a thought, can not you convert it all into one pdf file per client?
Ie. Your output per. client from the database is converted to a pdf file, after which you merge the corresponding pdf files per. client.
As mention, only a thought.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 07-17-2018, 05:03 AM   #12
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 1,491
Thanks: 14
Thanked 272 Times in 270 Posts
Mark_ will become famous soon enough
Re: pdf in Report

From your description, putting the files into your back end isn't going to help.

I'm not sure exactly how to do it, but you really want a display on each subreport that displays the contents of each PDF. As a PDF can be multiple pages and be sized for different paper, not exactly sure if this is what you are trying for or not.

Which version of ACCESS are you using?

NOTE: There is an alternate approach for generating a paper report that may do what you wish; create a loop that calls your "Header" as a report that is automatically sent to a printer. Then loop through the child records (links to PDFs) and automatically send them to the same printer in sequence. I'm not sure if this can be pulled off in ACCESS without a dialog popping up along the way though. Only time I've had to do this I was doing it through crystal reports using their API, and that was a long time ago.
Mark_ is offline   Reply With Quote
Old 07-17-2018, 08:17 AM   #13
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 1,491
Thanks: 14
Thanked 272 Times in 270 Posts
Mark_ will become famous soon enough
Re: pdf in Report

Simon,

Can you get the documents in a format other than PDF? Or is it an option to use a command line converter to make non-PDF copies for printing?

In a report you can't easily change a displayed PDF, but an image control showing a JPG can easily change to show something else. If you have single page PDFs you should be able to have a command line converter make image copies of each for printing purposes. Then you would have a header record that lists who the pages are for, one subreport that lists your index of documents, then another that prints the image files for each document.

The other alternative is to write a loop that goes through your dataset. Your loop would call the "header report" first for each "parent record" (and gives you a list of documents that will follow) then get a recordset for all child documents. For each child record, you will want to send it to the printer. I'd write a function that can be passed the full path to the PDF and the printer you want it printed on. How you write the function depends on which version of access/adobe you have and what it supports. The goal here would be to create an instance of adobe first, use that instance to print all of the documents, then end that instance so adobe doesn't remain in memory.

Using adobe to do the printing will definitely give a better printed result, but depending on your needs using image files may be a better/easier option.

Mark_ is offline   Reply With Quote
Reply

Tags
pdf , report

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Change report filters and report label caption based on form command newdistrict Reports 6 07-23-2017 12:52 PM
Open report button to select data from 7 list boxes and present in a report Gavin59 Forms 19 03-07-2016 07:16 PM
[SOLVED] Open sub report from main report by selecting report name scopes456 Reports 3 12-15-2015 11:01 AM
Does MS Access Report support Hide/Show fields at the Report View time? accesser2003 General 3 06-13-2014 06:15 AM
Invoice report problem, report show items from previous invoices. saltyseadog Reports 1 04-16-2013 07:30 AM




All times are GMT -8. The time now is 11:31 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World