I use Visual Studio 2005 with Crystal Report and i create an application, that read DB via ODBC. So i have a big problem, that i can't solve. The Report has couple of Formula Fields with code like this:

if {table.GlobalTypeCode} = 0 then
   {table.Name}

Everything works fine, but the problem is that the fields with GlobalTypeCode = 0 are 10 and all fields is about 3000, so i have report with 165 blank pages . Is there a way to remove this blank records from the report with some specific else of something???
Thanks in Advice!


Edited by as.yanev - 05 Jun 2011 at 11:41pm

I tried, but I have problem with the inner join 
Command for the report is :

SELECT `TagCfg`.`tgName`, `TagCfg`.`tgDescriptor`, `TagCfg`.`tgDeviceType`, `TagCfg`.`tgDeviceIOadd`, `TagCfg`.`tgOPCItemName`, `ptGlobalTypes`.`tgGlobalTypeCode`, `ptSystemTgTypes`.`SystemTagStr`
FROM   (`TagCfg` `TagCfg` INNER JOIN `ptGlobalTypes` `ptGlobalTypes` ON `TagCfg`.`tgGlobalTypeCode`=`ptGlobalTypes`.`tgGlobalTypeCode`)
INNER JOIN `ptSystemTgTypes` `ptSystemTgTypes` ON `TagCfg`.`tgTypeCode`=`ptSystemTgTypes`.`tgSystemTagCode`

I don't know where to set `tgGlobalTypeCode`= 0. 

Thanks Man! It's much easier than i thought...

Edited by as.yanev - 06 Jun 2011 at 11:30pm