Friday, January 4, 2013

Split Text in Crystal Reports

We have the below text.

"IFR - Issued For Review"

Need to split the text from "-" and display only "IFR" in the report.

To achieve this add a new Formula Field to the report and add the below formula.


You need to change the "dtSquadCheckDetails.RevisionStatus" part according to your report.

dtSquadCheckDetails - Is the data set bind to the report.
RevisionStatus - Is the column containing the text to be split. 

Now you can drag and drop the Formula Field into you'r report.

No comments:
Write comments
Recommended Posts × +