Search results for query: *

iif({Command.OLDSTATUS} in ["Cancel","CNCLACCT"], "CANCEL", iif({Command.MATURESTATUS}="M","Mature", iif({Command.SEC_TYP_CD} in ["OVND","TD"] and {Command.YESTERDAYTRADEID} <> 0,"ROLL", "New") ) ) I have this function which does take the 3rd contion if I comment 2nd line...

Hi, I am working on a report which deals with Hierarchy parent-child relationship. The database is MS Access and using Crystal report 2008. Requirement:- I need to show 3 fields of top most table (supress rest) and have to show all fields of the last-most table in the chain. Relationship I have...

I have written a formul BP_name Which is 2nd group in the report. I want to supress the Bp_Name group where:- 1) the formula "not found" 2) data value doesn't start with "C2" or "C3" (i have not written this in formula. I am supressing the group using below :- {@BP_Name}="not found" and...

This may be v simple but I am finding it hard to diplay. My report displays the parent-child capabilities in Hierarchical order. I need to change the sorting of 2nd group that is first child in specific order. 2nd group 1 =if {Capabilities_1.Name} like ""*(Set Up)" 2 =if...

I have a table which store all the capabilities object in one table which is distinguished by Capabilities Parent table. I have created a sub report which displays the issues related to the capabilities in each level. But When I link it to the main report it just shows the issues for the top...

Hello Techie frends, I have a requirement to sort a list of data in particular order. I tried val(table.fieldname) but the order of number and alphabets are not same. I am posting some sample data which i need to be sorted. PLease help C.211.d.2.1 Validate securities trade formats C.211.d.2.10...