Monday, March 26, 2012

Problem in crosstab column

Hi All

I am using crosstab,in the column i have feilds like 'General-Appolo','Medical-Appolo','shopping'.....

in that in crosstab need to get only the fields which consists the name like 'appolo'

dont want the feilds with out having name like 'appolo'

Thanks a lotIn the suppress event of the field write this
not {Field}="Appolo"|||Thanks,

But it is check for only exact name is "Apollo"

But i want not like "%apollo%'
(not like functionality of sql server)|||Then try

not Instr({Field},"Appolo",1)>0

No comments:

Post a Comment