Solved

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

Posted on 2003-10-30
10
1,072 Views
Last Modified: 2007-11-27
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
Comment
Question by:dionid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 9657318
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
 

Expert Comment

by:zoombo
ID: 9668640
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
 

Author Comment

by:dionid
ID: 9684100
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
LVL 101

Accepted Solution

by:
mlmcc earned 155 total points
ID: 9691948
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 9691985
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
 

Author Comment

by:dionid
ID: 9692251
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 9863634
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
 

Author Comment

by:dionid
ID: 9864023
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 9871105
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
 

Expert Comment

by:twinfrey
ID: 12360807
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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question