Recent content by PD81

Thanks a ton. -cheers Puneet

Thanks Guys, I started with IF...Else but somehow it was not going to the ELSE part. Now i copied over LB's code but It seems to be not working says ) missing I put that but still. @LB - yes the MatureStatus can be NULL, it will have value only when its is Mature. -cheers Puneet

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...

Thanks LB, As per me everything is correct only issue (i assume)is how I have linked subreport to the main report. I sub report I have 4 level of parent childs groups I have just linked the childid of the the top level with the parentid of main report. If you can give me ur mail id I can send...

any help on this is really appreciated. I have a review from the client on this reports. I need to display all the issues associated with all levels -cheers Puneet

Hi LB, Thanks so much for your response. Your solution always help me I am expecting to solve this time as well. Yes I am using Left outer join to joins the tables. there is no problem when I run the subreport seperately it gives me the correct output. I assume there is some problem how the...

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...

Thanks LB I am getting an error -- "This array must be subscripted" at line --> stringvar x := split(y,"."); I may found silly but, i need this to be sorted out. Please help -cheers Puneet

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...