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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.