H
HKLE
Guest
Hi fellows
I have a special problem. I need to export reports to pdf format (which I am doing with either Acrobat 6 prof or the - very good - Freeware "Freepdf XP"). The report contains hyperlink fields.
originally - and most comfortably - I thought of file server addresses of the type "file://xxx/yyy/123.pdf". (My files are located on this file server) For some reason, I never found a working syntax for creating a link, that works with Acrobat reader (7.0.7).
So I thought I have to cope with "http://" type adresses. Now, there is some strange phenomenon. I combine the link from several parts into a working link. This is working perfectly on table level. Converted into an Access report, the link is dead. Converting the access report into pdf, links are working again - but not always. Somehow lately, they get corrupted - i.e. during the conversion, some letters or numbers are added to the original link address - I have no idea, where they come from.
So finally - I try to play with "xml" export possibilities. Ì have a report based on a filled field in a form. That means, that the report looks for the contents of that field in this form. I tried to create a makro for export to xml, but there is a devil`s circle in this:
If I open the report and want to export it to xml, I get a message, that I have to close the report before exporting it.
If I try to select the report and right click for "export", it asks me for the contents of the form field.
If I write a makro,which I open from this form - with the basic commands (1) "select the report xxx" and then (2) use "export" command, it renders the form useless (i.e. opens the "export to" window) and I get the request for the form field again.
I do not want to loose my flexible report - form relationsship.
So finally my questions
1) Is there a possibility for pdf export with working links (file server addresses preferred because of system speed)
2) how may I export reports in this configuration to xml - and is it worth it ?? (My reports have a lot of subreports with special layout - therefore the pdf export on the first hand ...)
Sorry for this long message
Thank you
I have a special problem. I need to export reports to pdf format (which I am doing with either Acrobat 6 prof or the - very good - Freeware "Freepdf XP"). The report contains hyperlink fields.
originally - and most comfortably - I thought of file server addresses of the type "file://xxx/yyy/123.pdf". (My files are located on this file server) For some reason, I never found a working syntax for creating a link, that works with Acrobat reader (7.0.7).
So I thought I have to cope with "http://" type adresses. Now, there is some strange phenomenon. I combine the link from several parts into a working link. This is working perfectly on table level. Converted into an Access report, the link is dead. Converting the access report into pdf, links are working again - but not always. Somehow lately, they get corrupted - i.e. during the conversion, some letters or numbers are added to the original link address - I have no idea, where they come from.
So finally - I try to play with "xml" export possibilities. Ì have a report based on a filled field in a form. That means, that the report looks for the contents of that field in this form. I tried to create a makro for export to xml, but there is a devil`s circle in this:
If I open the report and want to export it to xml, I get a message, that I have to close the report before exporting it.
If I try to select the report and right click for "export", it asks me for the contents of the form field.
If I write a makro,which I open from this form - with the basic commands (1) "select the report xxx" and then (2) use "export" command, it renders the form useless (i.e. opens the "export to" window) and I get the request for the form field again.
I do not want to loose my flexible report - form relationsship.
So finally my questions
1) Is there a possibility for pdf export with working links (file server addresses preferred because of system speed)
2) how may I export reports in this configuration to xml - and is it worth it ?? (My reports have a lot of subreports with special layout - therefore the pdf export on the first hand ...)
Sorry for this long message
Thank you
Last edited:
