I have created a report that I need to export as text so it can be renamed into a VBS file. Everything works except that when the report is exported the formatting get's all messed up and the VBS will no longer compile. Is there any way to export to a text file and preserve the formatting exactly as it appears in the report? What I need is to have the line breaks appear exactly as it does in the report. What happens is when exported to text it just places the line breaks wherever so it chops off right in the middle of a line of what would be code. See below for an example:
Here are the first couple of lines in the report:
Const olAppointmentItem = 1
Set objOutlook = CreateObject("Outlook.Application")
Set objAppointment = objOutlook.CreateItem(olAppointmentItem)
Here are the same 3 lines as they appear when you export from Crystal to a text file:
Const olAppointmentItem = 1 Set objOutlook = CreateObject("Outlook.Application") Set objAppointment = objOutlook.CreateItem(olAppointmentItem)
As you can see the line breaks were not maintained so when the file is renamed to .vbs it will not compile. Any thoughts on how to export to text and preserve the line breaks? I am using Crystal Reports 11. Thanks for any ideas.
|