Special characters in formulas?

[Tim Keogh]

Hello,

I'm new to Crystal and am having a strange problem with one of my reports.
I am pulling from a database based on a "type code" field, with the
selection criteria

{GTRNS.CODE} = "#" and
cdate({MSTPO.CREATEDATE}) = CurrentDate()-1

But this report also ends up including records where the code is "%", not
"#". I assume this is some kind of special formatting character, so how can
I make crystal select only records with the literal value "#" for the code?
I tried adding the line

and {GTRNS.CODE} <> "\%"

to the formula, but still no luck. Google has been no help either. Thanks
in advance!

Tim

[atul sardana]

how to use record selection formulas for special characters

Post by Tim Keogh
Hello,
I'm new to Crystal and am having a strange problem with one of my reports.
I am pulling from a database based on a "type code" field, with the
selection criteria
{GTRNS.CODE} = "#" and
cdate({MSTPO.CREATEDATE}) = CurrentDate()-1
But this report also ends up including records where the code is "%", not
"#". I assume this is some kind of special formatting character, so how can
I make crystal select only records with the literal value "#" for the code?
I tried adding the line
and {GTRNS.CODE} <> "\%"
to the formula, but still no luck. Google has been no help either. Thanks
in advance!
Tim
Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Workflow Custom Input Forms
http://www.eggheadcafe.com/tutorials/aspnet/2a494ffa-c3b0-41e5-9847-80e7cdf3779a/sharepoint-workflow-custom-input-forms.aspx