Lebans ReportToPDF test

Hi Stephen,

my OE would not post to the original thread, because he is too long!

So here the last results:

Stephen Lebans wrote:

Dieter can you help me isolate the problem.
Would you please export a Report to Snapshot file format and then
Email me the Snapshot.

... in progress

What happens when you use the MDE by itself and try to convert the
sample reports contained within the MDE?

exaytly the same error
"Das Format, in dem Sie das aktuelle Objekt auszugeben versuchen, ist nicht
verfügbar"
The Title of the MsgBox: ReportToPDF:2282

--
So long Dieter

Hi Dieter,
thanks for sending me the Snapshot file. I was able to find the problem. The
printer Driver you are using is not filling in the Devmode's PageWidth and
PageHeight values. I have only seen this in three specific instances:
1) Certain HP Printer Drivers
2) The Microsoft Office Document Image writer printer driver
3) A PDF printer driver

I am currently adding logic to handle this issue. A quick solution would be
for you to select a different printer driver than your current setup.

Thanks for helping me debug this issue. I will post the update later tonight
or early tomorrow. It's takes a bit of time as I have to translate the page
height and width values for all possible page sizes supported by Windows.

:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Dieter Liessmann" wrote in message
...
Hi Stephen,

my OE would not post to the original thread, because he is too long!

So here the last results:

Stephen Lebans wrote:

Dieter can you help me isolate the problem.
Would you please export a Report to Snapshot file format and then
Email me the Snapshot.

.. in progress

What happens when you use the MDE by itself and try to convert the
sample reports contained within the MDE?

exaytly the same error
"Das Format, in dem Sie das aktuelle Objekt auszugeben versuchen, ist
nicht
verfügbar"
The Title of the MsgBox: ReportToPDF:2282

--
So long Dieter

Hi Stephen,

Stephen Lebans schrieb:
Hi Dieter,
thanks for sending me the Snapshot file. I was able to find the
problem. The printer Driver you are using is not filling in the
Devmode's PageWidth and PageHeight values. I have only seen this in
three specific instances: 1) Certain HP Printer Drivers
2) The Microsoft Office Document Image writer printer driver
3) A PDF printer driver

I am using a
Kyocera Mita FS-3820N

I am currently adding logic to handle this issue. A quick solution
would be for you to select a different printer driver than your
current setup. Thanks for helping me debug this issue. I will post the
update later
tonight or early tomorrow. It's takes a bit of time as I have to
translate the page height and width values for all possible page
sizes supported by Windows.

It sounds good. Not the lot of work, but that there is a solution ;-).
I will wait for your solution because i think this problem could be happend
at my custumors.

--
So long Dieter

Hi Dieter,
I just posted the update to fix the issue you were encountering. Please let
me know how it works for you.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

Stephen Lebans schrieb:
Hi Dieter,
thanks for sending me the Snapshot file. I was able to find the
problem. The printer Driver you are using is not filling in the
Devmode's PageWidth and PageHeight values. I have only seen this in
three specific instances: 1) Certain HP Printer Drivers
2) The Microsoft Office Document Image writer printer driver
3) A PDF printer driver

I am using a
Kyocera Mita FS-3820N

I am currently adding logic to handle this issue. A quick solution
would be for you to select a different printer driver than your
current setup. Thanks for helping me debug this issue. I will post the
update later
tonight or early tomorrow. It's takes a bit of time as I have to
translate the page height and width values for all possible page
sizes supported by Windows.

It sounds good. Not the lot of work, but that there is a solution ;-).
I will wait for your solution because i think this problem could be
happend at my custumors.

--
So long Dieter

Stephen

Hope you don't mind if I chime in here.

I got your A2000ReportToPDFver735.mde and tested it against my Problem
Printer Drivers. Here are my results testing against the
"DrawBoxWithMargin" report from your sample Database.

hp deskjet 895c series page size 0.38 x 0.39 in
HP LaserJet 1200 Series PCL 6 page size 13.17 x 17.06 in
hp photosmart 1115 series page size 13.17 x 17.06 in

Using other Drivers that I have installed (HP4, 5, 4050, and Color LaserJet
5/5m) I get the correct 8.5 x 11 in page size. Wish I had better news :-(

--
Ron W
www.WorksRite.com
"Stephen Lebans"
wrote in message ...
Hi Dieter,
I just posted the update to fix the issue you were encountering. Please
let
me know how it works for you.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

Stephen Lebans schrieb:
Hi Dieter,
thanks for sending me the Snapshot file. I was able to find the
problem. The printer Driver you are using is not filling in the
Devmode's PageWidth and PageHeight values. I have only seen this in
three specific instances: 1) Certain HP Printer Drivers
2) The Microsoft Office Document Image writer printer driver
3) A PDF printer driver

I am using a
Kyocera Mita FS-3820N

I am currently adding logic to handle this issue. A quick solution
would be for you to select a different printer driver than your
current setup. Thanks for helping me debug this issue. I will post the
update later
tonight or early tomorrow. It's takes a bit of time as I have to
translate the page height and width values for all possible page
sizes supported by Windows.

It sounds good. Not the lot of work, but that there is a solution ;-).
I will wait for your solution because i think this problem could be
happend at my custumors.

--
So long Dieter

Ron could I ask a favour? Would you export the DrawBoxWithMargin sample
Report to Snapshot with each of the 3 Printer Drivers from your post as the
default printer for your system or the SPecific printer for the report. I
would really appreciate your time here to get this bug resolved.
Email:


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Ron Weiner" wrote in message
...
Stephen

Hope you don't mind if I chime in here.

I got your A2000ReportToPDFver735.mde and tested it against my Problem
Printer Drivers. Here are my results testing against the
"DrawBoxWithMargin" report from your sample Database.

hp deskjet 895c series page size 0.38 x 0.39 in
HP LaserJet 1200 Series PCL 6 page size 13.17 x 17.06 in
hp photosmart 1115 series page size 13.17 x 17.06 in

Using other Drivers that I have installed (HP4, 5, 4050, and Color
LaserJet
5/5m) I get the correct 8.5 x 11 in page size. Wish I had better news :-(

--
Ron W
www.WorksRite.com
"Stephen Lebans"
wrote in message ...
Hi Dieter,
I just posted the update to fix the issue you were encountering. Please
let
me know how it works for you.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

Stephen Lebans schrieb:
Hi Dieter,
thanks for sending me the Snapshot file. I was able to find the
problem. The printer Driver you are using is not filling in the
Devmode's PageWidth and PageHeight values. I have only seen this in
three specific instances: 1) Certain HP Printer Drivers
2) The Microsoft Office Document Image writer printer driver
3) A PDF printer driver

I am using a
Kyocera Mita FS-3820N

I am currently adding logic to handle this issue. A quick solution
would be for you to select a different printer driver than your
current setup. Thanks for helping me debug this issue. I will post
the
update later
tonight or early tomorrow. It's takes a bit of time as I have to
translate the page height and width values for all possible page
sizes supported by Windows.

It sounds good. Not the lot of work, but that there is a solution ;-).
I will wait for your solution because i think this problem could be
happend at my custumors.

--
So long Dieter

Thank you very much Ron!
I found that certain printer drivers write nonsensical values into the
printer Devmode structure. I was testing for ZERO in the PageWidth and
PageHeight members. The Printer drivers you uses were writing the value of
90 into these members so my logic test failed as 90 could not simply be a
valid number. I have given up on using the PageWidth/Height members and
simply convert the PageSize member directly into the required values.

Thanks again! The update is now on my site. Version 1.95
http://www.lebans.com/reporttopdf.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Stephen Lebans"
wrote in message ...
Ron could I ask a favour? Would you export the DrawBoxWithMargin sample
Report to Snapshot with each of the 3 Printer Drivers from your post as
the default printer for your system or the SPecific printer for the
report. I would really appreciate your time here to get this bug resolved.
Email:


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Ron Weiner" wrote in message
...
Stephen

Hope you don't mind if I chime in here.

I got your A2000ReportToPDFver735.mde and tested it against my Problem
Printer Drivers. Here are my results testing against the
"DrawBoxWithMargin" report from your sample Database.

hp deskjet 895c series page size 0.38 x 0.39 in
HP LaserJet 1200 Series PCL 6 page size 13.17 x 17.06 in
hp photosmart 1115 series page size 13.17 x 17.06 in

Using other Drivers that I have installed (HP4, 5, 4050, and Color
LaserJet
5/5m) I get the correct 8.5 x 11 in page size. Wish I had better news
:-(

--
Ron W
www.WorksRite.com
"Stephen Lebans"

wrote in message ...
Hi Dieter,
I just posted the update to fix the issue you were encountering. Please
let
me know how it works for you.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

Stephen Lebans schrieb:
Hi Dieter,
thanks for sending me the Snapshot file. I was able to find the
problem. The printer Driver you are using is not filling in the
Devmode's PageWidth and PageHeight values. I have only seen this in
three specific instances: 1) Certain HP Printer Drivers
2) The Microsoft Office Document Image writer printer driver
3) A PDF printer driver

I am using a
Kyocera Mita FS-3820N

I am currently adding logic to handle this issue. A quick solution
would be for you to select a different printer driver than your
current setup. Thanks for helping me debug this issue. I will post
the
update later
tonight or early tomorrow. It's takes a bit of time as I have to
translate the page height and width values for all possible page
sizes supported by Windows.

It sounds good. Not the lot of work, but that there is a solution ;-).
I will wait for your solution because i think this problem could be
happend at my custumors.

--
So long Dieter

Hi Stephen,

good news!
It works!

I hope you will write Versions for A10 (XP) and A11 (2003)?!

--
So long Dieter

Hi Stephen,

sorry, but i didn't have read the headline on your hompage until now.

It works fine with A2000 and A2002 but there always is a Problem with A2003.

The error is the one you aleready know:
"Das Format, in dem Sie das aktuelle Objekt auszugeben versuchen, ist nicht
verfügbar"
The Title of the MsgBox: ReportToPDF:2282

--
So long Dieter

Hi Deiter,
I was not able to test every single page size. What page size is your report
formatted for?

Can you export the report that is failing to Snapshot format and Email me
the Snapshot please.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

sorry, but i didn't have read the headline on your hompage until now.

It works fine with A2000 and A2002 but there always is a Problem with
A2003.

The error is the one you aleready know:
"Das Format, in dem Sie das aktuelle Objekt auszugeben versuchen, ist
nicht
verfügbar"
The Title of the MsgBox: ReportToPDF:2282

--
So long Dieter