Solved

crystal report in notepad

Posted on 2004-10-10
5
377 Views
Last Modified: 2012-08-13
Hi all,
I have to perform an updating of field names and data in DB and wants to find out whether that field or data has been used in my crystal report so I can do relevant changes to the report as well.

I have to tools to search for all the text in a file, but because crystal report is not in text format, I can really use that tool, does anyone knows how can I change my existing report into text so that I can perform the searching of specific string (in the field name or hardcoded data ) in the report?

Thanks
Joey
0
Comment
Question by:monjoes
  • 2
5 Comments
 
LVL 27

Accepted Solution

by:
Dabas earned 125 total points
ID: 12273881
Hi monjoes,
In CR, click on the Export button (Looks like a small envelope) and then choose then choose report definition from the list and save to disk.
This will store all of the report information into a text file

Dabas
0
 
LVL 19

Expert Comment

by:arif_eqbal
ID: 12273889
What Language are you using if you'r using VB


Me.CrystalReport1.Destination = crptToFile
Me.CrystalReport1.PrintFileName = "C:\test1.rec"
Me.CrystalReport1.PrintFileType = crptCSV
Me.CrystalReport1.Action = 1

i.e. you need to specify the Destination as a File and provide the FileName, I think the Crystal report methods will be somewhat same in any language you use.

After your Rec file which is bacically a coma separated Text File is created you can read the file through your program and search for the string
0
 
LVL 27

Expert Comment

by:Dabas
ID: 12273911
I agree with arif's solution, as long as you do not have any formula that uses the field name as is now.
The solution I proposed will also let you check your formulas...

Dabas
0
 

Author Comment

by:monjoes
ID: 12366088
Thanks for your comment, I hve tried that and it works fine,
However, I had a formula in running total and it cannot be exported to the text file.
Any ideas?
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

708 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

18 Experts available now in Live!

Get 1:1 Help Now