Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PD81
  • Order by date
  1. PD81

    IIF function issue not going to else part

    Thanks a ton. -cheers Puneet
  2. PD81

    IIF function issue not going to else part

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

    IIF function issue not going to else part

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

    How to find out the last Child of a Hierarchy Chain

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

    Supressing the group using formula

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

    Sorting a Hierarchical Group in specific Order

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

    Issue with Sub-Report/Joins...not displaying properly . please Help

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

    Issue with Sub-Report/Joins...not displaying properly . please Help

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

    Issue with Sub-Report/Joins...not displaying properly . please Help

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

    Issue with Sub-Report/Joins...not displaying properly . please Help

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

    sorting a complex alphanumeric daa

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

    sorting a complex alphanumeric daa

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

Part and Inventory Search

Back
Top