charts don't load for large files

[rutica]

I'm using Access 2003.

I have a report that contains a subreport. The subreport contains a line chart.

I open the report in View mode, then go to File, Print and choose Adobe PDF to make a pdf file. i have Adobe Acrobat 8 Professional.

All works well if the report is about 165 pages (there is one chart about every 3 pages). But I tried with a report that was 199 pages (again, one chart about every 3 pages) and the charts in Adobe are just a blank box. I can see where the chart should be, but it's not there--there is just a box.

It seems like there wasn't enough memory to load all the charts correctly in Adobe?

Is there a work around for this?

Thanks,

 

[PNGBill]

Sometimes adobe can take a long time to get all the data open.

Have you tried restarting your pc just before printing the report to acrobat.
Just a one time test that may indicate the pc ram size is an issue.

Are you using acrobat distiller or printer ?

A workaround could be to print pages 1 - 100 first and then 101 -199 second and then in acrobat, insert the 2nd file into the first with "after last page"

We don't use printers and have acrobat distiller as our default printer. Had one report 2,388 pages on the weekend and no problems with acrobat 5. no graphs though.

There are also settings on your printer preferences that may assist.

 

[rutica]

thanks for writing.

I tried your suggestions, but no luck. I am using Adobe Acrobat 8 Professional. I have Acrobat Distiller 8.

--I rebooted, then tried printing my file, but still couldn't see my charts. I ran a windows cleaner to remove temp files, but still no luck.

--I tried printing just a few pages, but still couldn't see my charts. For example, in the Print Dialog box, in the Print Range section, I tried "Pages From 1 To 2", but still couldn't see my charts, even with only a 2 page PDF file. The only way I can see my charts is to go into the Record Source of my Access report and limit the query to produce less records. But that is not feasible for my purposes.

Any other suggestions?

Thanks again,

 

[PNGBill]

Just another task, that may not produce a result, is to compact and repair the database.
If you create temp tables these can blow up the database size and may cause problems. I have seen reference that access has a limit to it's size. 1gb I understand.

 

[rutica]

thanks again for writing. i just tried compacting and repairing, but still no luck.

My database is 78 MB.

You had written: "There are also settings on your printer preferences that may assist."

What settings?

Thanks again.

 

[PNGBill]

yeah, 78mb not too big.

Just like any other printer, acrobat distiller and printer are in your settings, printer from start menu.

Any other way you can isolate the problem?
Can you display the whole report on your screen? I know charts could be an issue but with just data, you can run the query and see all the data rather then running the report.

Acrobat can do macro type tasks. eg, we often insert a pdf flyer page as the last page of hundreds of .pdf files so we combine our mail merge with then adding a publisher created document at the end and fax/email the result to the respective persons.
The insert process is automated and takes a few seconds to do.

Could acrobat add your charts after then first part is created?

Sorry not much help

 

[rutica]

this is really weird, but i think i found the problem. In the query behind my chart, i used FormatCurrency in a field:

ActualCosts: FormatCurrency(IIf([release]="Dev",[ActualCostDev],IIf([release]="Maint",[ActualCostMaint])),0)

I found when I removed the FormatCurrency from the field in the query, my charts load successfully in Adobe. I changed the field in the query to: ActualCosts: IIf([release]="Dev",[ActualCostDev],IIf([release]="Maint",[ActualCostMaint]))

I don't understand why it works, but now everything works for me. Maybe Adobe couldn't understand 'FormatCurrency'?

I just ouput a 600 page adobe file with charts every 3 pages, and it all works!!

Thanks for all your suggestions, though.