Link to home
Start Free TrialLog in
Avatar of Hagita
HagitaFlag for Israel

asked on

Format Crystal Report Fields

Hello Experts, need help to make a generic format for all the crystal report's fields to show chr(32) when the value is chr(34)- I know It can be done to each field - question is can it be done to all of them with one format command.
Avatar of James0628
James0628

You want to replace all double-quotes with a space?  I think you'll have to do that using a formula for each field.  I don't think there's any other way to do that in CR.

 James
Avatar of Hagita

ASKER

Meaning I will need to add a formula field to each field ?
SOLUTION
Avatar of James0628
James0628

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Hagita

ASKER

Great help mlmcc! Thank you both I learn alot since I have subscribed this web site.
Hagit
Good idea mlmcc.  I think the format idea crossed my mind, but I hadn't thought about formatting multiple fields at once, so I didn't see any real benefit.  That could really simplify things.

 And you're welcome Hagita.

 James