Coverting a Crosstab Report to PDF

[Letsgojacks]

Right now, I just use the Adobe Acrobat convert menu on the report I want to
convert. WIth all other reports no problems.

Except for the Crosstab report.

I've got Adobe Acrobat 7.0 Professional and the menu for converting to PDF
is right on the access menu (far right). When I want to convert my crosstab,
it goes through the motions with a green status bar - it gets to halfway.

Beep! Then this messge:

"Adobe PDF printer failed to create PDF file."

Thoughts?

Thanks,
Brian L.

 

[Chris Reveille]

I use CutePDF. It is freeware that converts anything printed to PDF. I wish
I had Adobe converter.

 

[Duane Hookom]

Can we ask how you are creating the report? Are you using a set of standard
column headings? Or, are you using the ugly solution that opens a recordset
based on the crosstab and loops through its fields collection?

 

[Letsgojacks]

No idea if its the "ugly solution" or not. The column headings are fields
from a table (locations). I need to set up a report that has all sorts of
employees (rows) working at all sorts of locations (columns). Some employees
haven't worked at any place yet and some locations have never had an employee
work there yet, as well.

What you do suggest I do?

Thanks,
BL

 

[Duane Hookom]

I suggest you post the SQL view of your crosstab and let us know if the
report is running any code.

 

[Ron Weiner]

Duane

I have been using "The Ugly Solution" in several app for many years with no
problem, other than the amount of code that needs to be executed and the
(ahem) pregnant pause to build and finally display/print the report. Do you
have "A Pretty Solution" for these kind of Xtab reports (and forms for that
matter) where you do not know how many or what the columns are gonna' be at
design time? I'd for one be very interested in a better way to do this.

Thanks

Ron W.

 

[Duane Hookom]

Check the Crosstab download from
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. There is
a Crosstab.mdb in the zip file that basically applies an alias to each
potential column heading. For instance if your column headings would be:
Apple
Orange
Pear
Grape
Apricot

They end up as:
A Apple
B Apricot
C Grape
D Orange
E Pear

If you only want 4 columns in your report, Pear would get A on a second
level so it would wrap below. You set up your report and code for a maximum
number of columns.

There is a table in the MDB that explains the solution.

 

[Ron Weiner]

Nice

Never looked at it like that. Not a bad trade off to add a temp table to
save all of the code I use to determine what the columns will be and how
they should be placed on the form. The stacking idea seems to work well
too. I will probably steal your code that next time I need to generate one
of these bad boys.

Thanks

Ron W

 

[Duane Hookom]

The solution is there for the stealing/taking.