By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Sending report to a PDF File. Good link for Access developers

P: n/a
Hi Guys: I was stuck. I needed to send a report to a file. My
beautiful report(s) in Access were going to require loss of formatting
with RTFs, a PITA in WordMailMerge, sending it as a text file...whatever.

I described my situation to the guy I'm doing work for and he did some
research for me and came up with the following link.

http://www.novapdf.com/

The part that should excite us Access developers is their SDK
http://www.novapdf.com/pdf-sdk.php

And as an Access developer, you might faint at
http://www.novapdf.com/pdf-reports-access.php

You can use the SDK and not spend any cash (free). It will simply put a
Novapdf watermark on the document. But if you are distributing your
application to others, the SDK can be purchased and the watermark goes
away. So if you are distributing apps, you might look at this product
with interest.

I'll test it out and post my observations on it...most likely in the
beginning of 2006.

Frankly, for my needs, this is an early Christmas present if it works as
advertised.


Dec 16 '05 #1
Share this Question
Share on Google+
13 Replies


P: n/a
MLH
Am looking forward to your evaluation.
Dec 16 '05 #2

P: n/a
MLH
Have you looked at stephan lebans' A97SnapshotToPDFver746.mdb?
Dec 16 '05 #3

P: n/a

"salad" <oi*@vinegar.com> schreef in bericht news:rT*****************@newsread1.news.pas.earthl ink.net...
Hi Guys: I was stuck. I needed to send a report to a file. My
beautiful report(s) in Access were going to require loss of formatting
with RTFs, a PITA in WordMailMerge, sending it as a text file...whatever.

I described my situation to the guy I'm doing work for and he did some
research for me and came up with the following link.

http://www.novapdf.com/

The part that should excite us Access developers is their SDK
http://www.novapdf.com/pdf-sdk.php

And as an Access developer, you might faint at
http://www.novapdf.com/pdf-reports-access.php

You can use the SDK and not spend any cash (free). It will simply put a
Novapdf watermark on the document. But if you are distributing your
application to others, the SDK can be purchased and the watermark goes
away. So if you are distributing apps, you might look at this product
with interest.

I'll test it out and post my observations on it...most likely in the
beginning of 2006.

Frankly, for my needs, this is an early Christmas present if it works as
advertised.


I also need to send my beautiful Access-reports to others.
I use PDF995 to generate the pdf-files with very good results (also free, NO watermark)
The only 'nag' if you like with the free version is that you are linked to their website.
If you don't like this you have to spend some money ($9,95)

It suits my needs allright.

Arno R

Dec 16 '05 #4

P: n/a
Arno R wrote:
"salad" <oi*@vinegar.com> schreef in bericht news:rT*****************@newsread1.news.pas.earthl ink.net...
Hi Guys: I was stuck. I needed to send a report to a file. My
beautiful report(s) in Access were going to require loss of formatting
with RTFs, a PITA in WordMailMerge, sending it as a text file...whatever.

I described my situation to the guy I'm doing work for and he did some
research for me and came up with the following link.

http://www.novapdf.com/

The part that should excite us Access developers is their SDK
http://www.novapdf.com/pdf-sdk.php

And as an Access developer, you might faint at
http://www.novapdf.com/pdf-reports-access.php

You can use the SDK and not spend any cash (free). It will simply put a
Novapdf watermark on the document. But if you are distributing your
application to others, the SDK can be purchased and the watermark goes
away. So if you are distributing apps, you might look at this product
with interest.

I'll test it out and post my observations on it...most likely in the
beginning of 2006.

Frankly, for my needs, this is an early Christmas present if it works as
advertised.

I also need to send my beautiful Access-reports to others.
I use PDF995 to generate the pdf-files with very good results (also free, NO watermark)
The only 'nag' if you like with the free version is that you are linked to their website.
If you don't like this you have to spend some money ($9,95)

It suits my needs allright.

Arno R

What I like about this is that I, as a developer, don't have to worry
about other PDF writers any user may have. I won't need to charge
licensing fees or demand someone have a certain writer. For the cost of
Adobe, I have something that is specific to my app.

If you are at a fixed site, or with a company that has
authorized/dictated using a specific writer, then I would stay with your
method. If you are distributing an application, I would not use your
method. I don't want to be telling clients that they must cough up
$9.95 for an app for my app to work. The less I involve my
clients/customers with external issues, the better.

Dec 16 '05 #5

P: n/a
MLH wrote:
Have you looked at stephan lebans' A97SnapshotToPDFver746.mdb?


No I haven't. However, if it would require a 2 step process to create
my document (first snapshot then convert to pdf) I would prefer a single
step method.

I would liked to have used the snapshot format in a report recently but
it is virtually useless with graphics. Maybe the snapshot format can
use graphics, but from my experience they need to be tiny.
Dec 16 '05 #6

P: n/a
MLH wrote:
Am looking forward to your evaluation.


Great. I hope I have something very positive to report.

I like their statement " novaPDF SDK is fully functional with no time
limitation. This means that you can download, install, integrate it in
your application and test to see if it fits your needs, without ordering
it."

Can't get better than that.
Dec 16 '05 #7

P: n/a

"salad" <oi*@vinegar.com> wrote in message
news:44*****************@newsread1.news.pas.earthl ink.net...
Arno R wrote:
"salad" <oi*@vinegar.com> schreef in bericht news:rT*****************@newsread1.news.pas.earthl ink.net...
Hi Guys: I was stuck. I needed to send a report to a file. My
beautiful report(s) in Access were going to require loss of formatting
with RTFs, a PITA in WordMailMerge, sending it as a text file...whatever.
I described my situation to the guy I'm doing work for and he did some
research for me and came up with the following link.

http://www.novapdf.com/

The part that should excite us Access developers is their SDK
http://www.novapdf.com/pdf-sdk.php

And as an Access developer, you might faint at
http://www.novapdf.com/pdf-reports-access.php

You can use the SDK and not spend any cash (free). It will simply put a
Novapdf watermark on the document. But if you are distributing your
application to others, the SDK can be purchased and the watermark goes
away. So if you are distributing apps, you might look at this product
with interest.

I'll test it out and post my observations on it...most likely in the
beginning of 2006.

Frankly, for my needs, this is an early Christmas present if it works as
advertised.

I also need to send my beautiful Access-reports to others.
I use PDF995 to generate the pdf-files with very good results (also free, NO watermark) The only 'nag' if you like with the free version is that you are linked to their website. If you don't like this you have to spend some money ($9,95)

It suits my needs allright.

Arno R

What I like about this is that I, as a developer, don't have to worry
about other PDF writers any user may have. I won't need to charge
licensing fees or demand someone have a certain writer. For the cost of
Adobe, I have something that is specific to my app.

If you are at a fixed site, or with a company that has
authorized/dictated using a specific writer, then I would stay with your
method. If you are distributing an application, I would not use your
method. I don't want to be telling clients that they must cough up
$9.95 for an app for my app to work. The less I involve my
clients/customers with external issues, the better.


I looked at their web site. The purchase price is what I would consider
very reasonable. If it's as good as they say it is, it's a bargain. They
have volume pricing (even better discounts) but I didn't see anything about
restrictions on redistributing the licenses to clients.

I too will be looking forward to the results of Salad's evaluation.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Dec 16 '05 #8

P: n/a
The conversion process does require exporting the Report to Snapshot format
first but it is performed programmatically. It does not require the external
MS Snapshot viewer just the native Access ability to export to Snapshot that
exists from A97 SR1 and later. I have not seen any significant Image related
issues with conversion to Snapshot from A2K on and I have tested hundred's
of reports. Your experience is not the norm.

I purchased the DynaPDF library and negotiated rights so that it could be
distributed as a Freeware solution. PDF conversion is performed within a
standard C++ DLL that does not require Registration or a Reference be set to
the DLL. No PDF printer driver is required. This is important to me as I
want to limit the amount of tech support required for this solution.

I am slowly exposing more functionality of the DynaPDF library. Compression,
security, combining multiple PDF docs etc.. Early next year I should be able
to display a PDF document within an Access Form/Report without requiring and
ActiveX or OLE Frame control.

I am not espousing that my PDF solution is the best. For most people, and
especially single users, a PDF Printer Driver is by far the simplest and
easiest solution to implement. But for corporate desktops that are locked
down tight, my solution is a very attractive alternative. For developers
that want/need control over the conversion process, again my solution is an
viable alternative. For Developer's that require complete control they can
simply purchase the DynaPDF library directly.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"salad" <oi*@vinegar.com> wrote in message
news:F7*****************@newsread1.news.pas.earthl ink.net...
MLH wrote:
Have you looked at stephan lebans' A97SnapshotToPDFver746.mdb?


No I haven't. However, if it would require a 2 step process to create my
document (first snapshot then convert to pdf) I would prefer a single step
method.

I would liked to have used the snapshot format in a report recently but it
is virtually useless with graphics. Maybe the snapshot format can use
graphics, but from my experience they need to be tiny.

Dec 16 '05 #9

P: n/a
First, why use something with a water mark?

For at least two years, I used the following:

It is absolutely Free,

And free means no watermarks, no nag screens, no annoying Popup
advertisements, no time limits etc.

It is also very fast, and works very well. I highly recommend it.

http://www.acrosoftware.com/products...df/Printer.asp

However, the above does not allow automaton.

(that means you can' use code to set the "output" file.

If you need to "set" the resulting output file?

Well, then...

Right now, the best "free" ms-access report to pdf on the web is of course
Stephen Lebans solution.

Stephen's solution DOES NOT require you to install a printer driver.

the code to make a pdf looks like:
DoCmd.OpenReport "tblpubs", acViewPreview
Reports("tblPubs").Visible = False
Call convertreporttopdf("tblpubs", , "c:\t.pdf", False, True)
DoCmd.Close acReport, "tblPubs"

Note how the user does NOT have to type in a resulting pdf name. So, with
Stephens code, you don't have to convert, or even install a pdf Printer on
the system.

So, you just open the report as you want...and then call the routine to make
a pdf out of that report....

As far as I can tell, for a free solution, Stephens is better then anything
else out there by a country mile...

You do NOT have to install a printer driver for this to work...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Dec 17 '05 #10

P: n/a
Randy Harris wrote:
"salad" <oi*@vinegar.com> wrote in message
news:44*****************@newsread1.news.pas.earthl ink.net...
Arno R wrote:

"salad" <oi*@vinegar.com> schreef in bericht
news:rT*****************@newsread1.news.pas.earthl ink.net...
Hi Guys: I was stuck. I needed to send a report to a file. My
beautiful report(s) in Access were going to require loss of formatting
with RTFs, a PITA in WordMailMerge, sending it as a text
file...whatever.
I described my situation to the guy I'm doing work for and he did some
research for me and came up with the following link.

http://www.novapdf.com/

The part that should excite us Access developers is their SDK
http://www.novapdf.com/pdf-sdk.php

And as an Access developer, you might faint at
http://www.novapdf.com/pdf-reports-access.php

You can use the SDK and not spend any cash (free). It will simply put a
Novapdf watermark on the document. But if you are distributing your
application to others, the SDK can be purchased and the watermark goes
away. So if you are distributing apps, you might look at this product
with interest.

I'll test it out and post my observations on it...most likely in the
beginning of 2006.

Frankly, for my needs, this is an early Christmas present if it works as
advertised.
I also need to send my beautiful Access-reports to others.
I use PDF995 to generate the pdf-files with very good results (also
free, NO watermark)
The only 'nag' if you like with the free version is that you are linked
to their website.
If you don't like this you have to spend some money ($9,95)

It suits my needs allright.

Arno R

What I like about this is that I, as a developer, don't have to worry
about other PDF writers any user may have. I won't need to charge
licensing fees or demand someone have a certain writer. For the cost of
Adobe, I have something that is specific to my app.

If you are at a fixed site, or with a company that has
authorized/dictated using a specific writer, then I would stay with your
method. If you are distributing an application, I would not use your
method. I don't want to be telling clients that they must cough up
$9.95 for an app for my app to work. The less I involve my
clients/customers with external issues, the better.

I looked at their web site. The purchase price is what I would consider
very reasonable. If it's as good as they say it is, it's a bargain. They
have volume pricing (even better discounts) but I didn't see anything about
restrictions on redistributing the licenses to clients.


Bingo!

I too will be looking forward to the results of Salad's evaluation.

Dec 17 '05 #11

P: n/a
Albert D. Kallal wrote:
First, why use something with a water mark?

For at least two years, I used the following:

It is absolutely Free,

And free means no watermarks, no nag screens, no annoying Popup
advertisements, no time limits etc.

It is also very fast, and works very well. I highly recommend it.

http://www.acrosoftware.com/products...df/Printer.asp

However, the above does not allow automaton.

(that means you can' use code to set the "output" file.

If you need to "set" the resulting output file?

Well, then...

Right now, the best "free" ms-access report to pdf on the web is of course
Stephen Lebans solution.

Stephen's solution DOES NOT require you to install a printer driver.

the code to make a pdf looks like:
DoCmd.OpenReport "tblpubs", acViewPreview
Reports("tblPubs").Visible = False
Call convertreporttopdf("tblpubs", , "c:\t.pdf", False, True)
DoCmd.Close acReport, "tblPubs"

Note how the user does NOT have to type in a resulting pdf name. So, with
Stephens code, you don't have to convert, or even install a pdf Printer on
the system.

So, you just open the report as you want...and then call the routine to make
a pdf out of that report....

As far as I can tell, for a free solution, Stephens is better then anything
else out there by a country mile...

You do NOT have to install a printer driver for this to work...

I have CutePDF too. The lack of ability to send if to a specified
filename and the hassle of clicking and pointing to folders using a
File/Open dialog immediately turned me off. If I could simply specify
CutePDF as the printer for the report, plus give it a file name (use an
ini file in their folder) that would be great. I DON'T want to force my
users to click and clack to get to a folder, nor do I want them to type
the filename.

CutePDF or PDF995 may be fine if it's for you or for a small company. I
think, no...I believe one needs a more professional solution if you have
any plans on distributing an app that will make use of writing PDF files.

I would go with Stephen Lebans program except that when I used "Snapshot
format" it clunked and clanged and then burped on an image file I
absolutely needed to have in the report...simply because the image file
was large. IOW, I needed something more robust than Snapshot. Reading
Stephen's response, his product will be just what Access developers will
need/want in the future.
Dec 17 '05 #12

P: n/a
Stephen Lebans wrote:
The conversion process does require exporting the Report to Snapshot format
first but it is performed programmatically. It does not require the external
MS Snapshot viewer just the native Access ability to export to Snapshot that
exists from A97 SR1 and later. I have not seen any significant Image related
issues with conversion to Snapshot from A2K on and I have tested hundred's
of reports. Your experience is not the norm.
Yeah. My computer is not the norm. I once had A2K on my machine and
removed it. It affected somthing in A97 where I couldn't export/import
text files. So I removed Office97 from C:\Program Files\Office97 and
reinstalled to C:\Program Files\Office or whatever the default is. This
created even more problems. Finally I reinstalled Office2k, removed it,
removed A97, went through a laborious process of removing Access97 and a
bunch of registry entries, then reinstalled Office97. I was able to
install SR1 but SR2 refuses to install.

Today, I can't create Snapshot files even tho I have SR1. I guess I
could do that if I were to reformat my drive, reinstall Windows,
repurchase programs I purchased over the net but I won't. If I were to
go through all that rig-a-marole I'd buy another computer instead.

I simply disappointed in MS ability to run a clean uninstall. And I'm
disappointed in MS's inability to communicate well with their other
programs. I guess the registry is so complicated even they can't clean
up their things right.

I purchased the DynaPDF library and negotiated rights so that it could be
distributed as a Freeware solution. PDF conversion is performed within a
standard C++ DLL that does not require Registration or a Reference be set to
the DLL. No PDF printer driver is required. This is important to me as I
want to limit the amount of tech support required for this solution.

I am slowly exposing more functionality of the DynaPDF library. Compression,
security, combining multiple PDF docs etc.. Early next year I should be able
to display a PDF document within an Access Form/Report without requiring and
ActiveX or OLE Frame control.
That will be wonderful!
I am not espousing that my PDF solution is the best. For most people, and
especially single users, a PDF Printer Driver is by far the simplest and
easiest solution to implement. But for corporate desktops that are locked
down tight, my solution is a very attractive alternative. For developers
that want/need control over the conversion process, again my solution is an
viable alternative. For Developer's that require complete control they can
simply purchase the DynaPDF library directly.

I wish you much success.
Dec 17 '05 #13

P: n/a
Salad just for your own knowledge base, if you are having trouble with
loading a specific image here is some info that may be of use to you.

Here is a NewsGroup post of mine containing code showing how to convert the
contents of the Image control to a Bitmap file prior to printing. This helps
alleviate the "Out of Memory" error that can popup when printing image
intensive reports.

From: Stephen Lebans (St***********@mvps.org)
Subject: Re: Reports with potentially 1000's of images
View: Complete Thread (5 articles)
Original Format

Newsgroups: microsoft.public.access.reports
Date: 2002-11-13 13:16:03 PST

Hi Steve, I would add two other items.
1) Turn of the "Importing Image" dialog window via the registry keys as
outlined here:
http://www.mvps.org/access/api/api0038.htm
Make sure you do it for all Image types that you using that contain the
key.
2) Change all of the Images to Bitmaps at runtime. I have been able to
print previously unprintable reports by doing this last step. Here's a
previous post of mine on the subject.
From: Stephen Lebans (St***********@mvps.org)
Subject: Re: Images in Reports
View: Complete Thread (18 articles)
Original Format
Newsgroups: microsoft.public.access.reports
Date: 2002-09-16 18:46:39 PST
Bruce I finally got a chance to test your method last night. It helped
but only with the actual printing and not the Print Preview itself.
I was able to print the failed Report directly to the printer or to a
disk printer file so that's great! Don't get me wrong, it's still a good
thing because at least you can print the report!

Unfortunately Acess still runs out of resources when you page back and
forth through Print Preview.
I plan to spend some time onthis issue shortly.
Here is the code I use to convert any Jpeg, Gif, or Metafile into a BMP.
Rather than using one of my API solutions I have cheated and set a
Reference to Standard OLE Types type library in order to get at the
SAVETODISK method. But no ActiveX controls are required
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Private ctr As Long

ctr = ctr + 1

Select Case ctr
Case 1
Me.Image10.Picture = CreateBitmapFile("C:\A.jpg")

Case 2
Me.Image10.Picture = CreateBitmapFile("C:\b.jpg")

Case 3
Me.Image10.Picture = CreateBitmapFile("C:\c.jpg")
ctr = 0

Case Else
ctr = 0

End Select

End Sub

Private Sub Report_Open(Cancel As Integer)
ctr = 0
End Sub
Private Function CreateBitmapFile(fname As String) As String

Dim obj As Object

Set obj = LoadPicture(fname)
If Not IsNull(obj) Then

SavePicture obj, "C:\SL11-52"
DoEvents
End If
CreateBitmapFile = "C:\SL11-52"
Set obj = Nothing

End Function


Keywords: out of memory report convert Jpg Jpeg bitmap
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"salad" <oi*@vinegar.com> wrote in message
news:oz***************@newsread2.news.pas.earthlin k.net...
Albert D. Kallal wrote:
First, why use something with a water mark?

For at least two years, I used the following:

It is absolutely Free,

And free means no watermarks, no nag screens, no annoying Popup
advertisements, no time limits etc.

It is also very fast, and works very well. I highly recommend it.

http://www.acrosoftware.com/products...df/Printer.asp

However, the above does not allow automaton.

(that means you can' use code to set the "output" file.

If you need to "set" the resulting output file?

Well, then...

Right now, the best "free" ms-access report to pdf on the web is of
course Stephen Lebans solution.

Stephen's solution DOES NOT require you to install a printer driver.

the code to make a pdf looks like:
DoCmd.OpenReport "tblpubs", acViewPreview
Reports("tblPubs").Visible = False
Call convertreporttopdf("tblpubs", , "c:\t.pdf", False, True)
DoCmd.Close acReport, "tblPubs"

Note how the user does NOT have to type in a resulting pdf name. So, with
Stephens code, you don't have to convert, or even install a pdf Printer
on the system.

So, you just open the report as you want...and then call the routine to
make a pdf out of that report....

As far as I can tell, for a free solution, Stephens is better then
anything else out there by a country mile...

You do NOT have to install a printer driver for this to work...

I have CutePDF too. The lack of ability to send if to a specified
filename and the hassle of clicking and pointing to folders using a
File/Open dialog immediately turned me off. If I could simply specify
CutePDF as the printer for the report, plus give it a file name (use an
ini file in their folder) that would be great. I DON'T want to force my
users to click and clack to get to a folder, nor do I want them to type
the filename.

CutePDF or PDF995 may be fine if it's for you or for a small company. I
think, no...I believe one needs a more professional solution if you have
any plans on distributing an app that will make use of writing PDF files.

I would go with Stephen Lebans program except that when I used "Snapshot
format" it clunked and clanged and then burped on an image file I
absolutely needed to have in the report...simply because the image file
was large. IOW, I needed something more robust than Snapshot. Reading
Stephen's response, his product will be just what Access developers will
need/want in the future.

Dec 17 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.