I have set up a report in my dbase which is supposed to export out into .rtf. It works really well, but the formatting is all over the place. Sometimes the fields are in the right place, other times not. Is there a way to have it export out and keep the formatting as it appears in the report?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Converting a report to .rtf loses formatting
- Thread starter 060159
- Start date
I have had this issue, and this is how i kind-of solved it.
If you have labels that are in bold increase the length of the border around it, so that when it export to rft, the label has got some to grow, and it stops putting text else where in the report.
If you use any graphics there is not way of transferring these over.
I have issues with access creating random pages in between records, which to be honest i have not solved - but if you do please let me know.
The only way to get around all these issue, and get the report looking like to want it is to replicate the report in Crystal Report - it does it perfectly. Instead of inserting text into the rft file, it create text box's etc, and formats it exactly like you want - it takes over graphics also.
You would think since its an MS talking to another MS product it would work, but as ever other application can do it better...
I hope i've been some help.
If you have labels that are in bold increase the length of the border around it, so that when it export to rft, the label has got some to grow, and it stops putting text else where in the report.
If you use any graphics there is not way of transferring these over.
I have issues with access creating random pages in between records, which to be honest i have not solved - but if you do please let me know.
The only way to get around all these issue, and get the report looking like to want it is to replicate the report in Crystal Report - it does it perfectly. Instead of inserting text into the rft file, it create text box's etc, and formats it exactly like you want - it takes over graphics also.
You would think since its an MS talking to another MS product it would work, but as ever other application can do it better...
I hope i've been some help.
- Thread starter
- #3
Thanks for this-as far as your random pages goes, I have this too-I get rid of any borders and lines and ensure everything fits onto one page-the reason it gives a blank page is because some fields are too long or something like that. Out of interest, what is Crystal Report?
Have a look at this link
It is good, I am currently migrating away from access for doing my report to crystal.
I do prefer access, but it is what i am used to, you know how it goes.
It is good, I am currently migrating away from access for doing my report to crystal.
I do prefer access, but it is what i am used to, you know how it goes.
- Thread starter
- #5
FancyPrairie
Programmer
The only way I have found for exporting a report without loosing any of its formatting is to save the report as a Snapshot rather than an rtf. Works great and everyone should have the Snapshot already installed on their machine.
If you've got Adobe you could also Print to the PDFWriter and save your files as PDF format.
For your recipients, Adobe offers free download of the PDF reader on their Website.
The snp format also works well. For recipients that do not have the snp viewer, to downlodd the snapshot viewer go here.
Hope this helps.
For your recipients, Adobe offers free download of the PDF reader on their Website.
The snp format also works well. For recipients that do not have the snp viewer, to downlodd the snapshot viewer go here.
Hope this helps.
- Status
Similar threads
- Locked
- Question
- Locked
- Question