Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

crystal report in notepad

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
monjoes
Asked:
monjoes
  • 2
1 Solution
 
DabasCommented:
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
 
arif_eqbalCommented:
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
 
DabasCommented:
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
 
monjoesAuthor Commented:
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
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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