Solved

CRYSTAL REPORTS:  Replace a word with new word

Posted on 2011-03-17
4
268 Views
Last Modified: 2012-05-11
Experts:

How can I replace a word with a new word..  Example:  On the status column I want to replace "Closed" with "Completed"?

I was thinking
If "Closed"({Maintenance.Status}) then
   "Completed"
Else
   CStr({Maintenance.Status})

But that doesn't work

Thanks
0
Comment
Question by:Maliki Hassani
[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
  • 3
4 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35156806
Try

If ({Maintenance.Status} = "Closed") then
   "Completed"
Else
   {Maintenance.Status}

mlmcc

0
 

Author Comment

by:Maliki Hassani
ID: 35156883
ha ha thanks...  Still looking at your other replies on open questions of mine.. Thanks a  bunch
0
 

Author Comment

by:Maliki Hassani
ID: 35156940
Oh and what if I wanted it to be a wild card like "Close%",  sine there may be other words after?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

632 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