Greetings, clever internet-people,
I'm pretty new to Crystal Reports, so forgive me if the answer to my question ought to be painfully obvious even to a squirrel, but I can't seem to find a pre-made answer to it anywhere... Perhaps my Google-fu has become weak.
My problem is this:
My report loops through a string in each record, counting the occurences of certain characters. If the string is entirely composed of several of these characters, specifically #, Z, X, *, Y, N, O, and Y, I want to exclude the record from the report, so my formula says:
shared stringvar rangestring;
local numbervar l := length(rangestring);
local numbervar c := 0;
local numbervar i :=1;
for i :=1 to l
do
(
if rangestring ['i] in ["Y","*","X","-","Z","#","O","N"] then
c := c+1
);
if c = l then 1
else 0
Of course, when I specify "
{@myformula} <> 1" in the Select Expert, I get a message saying that no, I can't use it because the formula must be evaulated later. Is there any way I can tell Crystal to run the rotten thing anyway, and disregard those records after the event?
Oh, and I'm using Crystal XI.
Thanks muchly,
Jack
Edited by OmniPants - 10 Mar 2010 at 3:07am
IP Logged
