Solved

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

Posted on 2003-10-30
10
1,048 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
10 Comments
 
LVL 100

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
 
LVL 100

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 100

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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

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 100

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 100

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now