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.
dionidAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.