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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment