• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1096
  • Last Modified:

Can I export to plain text format using Crystal Report ActiveX Viewer?

Hi everyone. I need to export a report to plain text format using the Crystal Report ActiveX Viewer for ASP, but this option is not available in the export dialog box. Is there a way I can get around this? Are there other CRViewer versions that I can download with this option? I'm using the viewer that came with CR Enterprise Edition 8.5. I really need to be able to export to plain text, as exporting to RTF inserts page numbers into the file. Thanks in advance.
0
dionid
Asked:
dionid
1 Solution
 
mlmccCommented:
What do you mean by plain text?  Do you want just the data or do you want a formatted text file that looks like the report?

mlmcc
0
 
zoomboCommented:
You could use the following formats

a) Character-Seperated Values
b) Comma-Seperated Values (then open with NotePad)
c) Tab-Seperated Text
d) Tab-Seperated Values
e) Text (Crystal 8.5 and up).

-Zoombo
0
 
dionidAuthor Commented:
I just need the data in the report. My report actually looks like a simple text file (no columns, headings, delimiters, or formatting whatsoever) since it was designed based on the customized file format requirements of our clients. Our clients download/export the report from the web as a text file and use it (without making any modifications to the file) in their own systems as input. It's just that the CRViewer Export Report dialog box only has the following format options available (*.rpt, *psd, *rtf, *.xls, *.doc). Using these format options affects the "desired" format of the file, either by adding page numbers and/or nonprintable characters to the file.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
mlmccCommented:
One of to things is going on.

First and the correctable problem.  The .txt export dlls are not on the client machiens therefore the export optioni doesn't show up.  The Crystal viewer actually looks to see which dlls are available and displays the appropriate export options.

The second and I don't believe fixable problem.  CR for the web has limited capability to export.  I'll try to find the reference in the CR knowledge base.

mlmcc
0
 
mlmccCommented:
When you say CR Enterprise Edition 8.5 do you have Crystal Report 8.5 or Crystal Enterprise 8.5?

Look at
http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr85_exportlimitations.zip.asp

Here is the link
http://support.crystaldecisions.com/library/kbase/articles/c2007681.asp

mlmcc
0
 
dionidAuthor Commented:
I have Crystal Report 8.5.

Based on the CR kbase article, it seems that the report viewer's export capabilities were intentionally limited.

Do you think it's possible (and legal) to make my own customized CR viewer based on the references used by the default CR viewer, then adding the export dll for plain text format? I tried experimenting with this using the ff as references:
CRViewer.dll
SwebRS.dll
SViewHLP.dll
ReportParameterDialog.dll
CSelexpt.ocx
XQViewer.dll

I got a gray area instead where the report should be. Any ideas?
0
 
mlmccCommented:
I would think it is legal but not sure it is possible.

What is ff?  

I didn't like the way CR8 exported to Excel so I wrote my own export routine.  The users wanted just the data in columns not looking like a report.

Since a txt file really won't support much in graphics or formatting that would also be a possibility.

mlmcc
0
 
dionidAuthor Commented:
Yeah, I never got that custom CRViewer experiment to work. Just got a lot of grey areas on my browser. Thanks to everyone who commented on this post though.

Sorry, by ff i meant "following".

By the way, was your export routine called from a VB client or ASP?

0
 
mlmccCommented:
We are only running VB.  It really isn't hard to write a routine to export the data from teh recordset.  However the method I used gets only the underlying data and doesn't include any formulas or manipulations done in Crystal.

mlmcc
0
 
twinfreyCommented:
Use the scheduler . . . the Plugin Interface Report Options when you schedule it

Dim reportFormatOptions
Set reportFormatOptions = MyPluginInterface.ReportFormatOptions
'4 = rtf
'From Crystal Enterprise
'<option value='1'>Excel
'<option value='9'>Excel (Data Only)
'<option value='2'>Word
'<option value='3'>Acrobat
'<option value='4'>Rich Text
'<option value='5'>Plain Text
'<option value='6'>Paginated Text
'<option value='7'>Tab-separated Values
'<option value='8'>Character-separated Values
Select case request("VIEWTYPE")
case "CRYSTAL"
      reportFormatOptions.Format = 0
case "EXCEL"
      reportFormatOptions.Format = 1
case "PDF"
      reportFormatOptions.Format = 3
case "WORD"
      reportFormatOptions.Format = 2
case "EXCEL-DATAONLY"
      reportFormatOptions.Format = 9
End Select
'
'Once all information about the SchedulingInfo object has been specified,
'Use the Schedule method of the InfoStore object to schedule the report.      
MyInfoStore.Schedule(MyReportCol)

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now