Recent content by DarkCloud2

Excellent, the solution worked beautifully. Thank You very much. I was able to solve my other problem of Award or Training and bid by the following formula: if {table.type} in ["AWARD","TRAINING"] then 1 else if {table.type} = "BID" then 1000 else 1000000

Thanks for both of your replies. I actually went with LB's approach since the time to process the report was much quicker. Thanks Again

Thanks LB, Yes, the claimant must have both an award claim and a training claim and no others. Your sample gives me all instances where a claimant has either a award claim only or a training claim only or both an award claim and a training claim only. What I need is for the claimant to have...

Crystal Reports 8.5 Oracle 9i/ODBC I have about 75,000 rows of claimant's claims. I am only interested in displaying claimant's who only have award claims and training claims. Thus I do not want to display claimant # 001 since that claimant has claims other than AWARD and TRAINING. I have...

Crystal Reports 8.5 Oracle 9i/ODBC I have about 75,000 rows of claimant's claims. I am only interested in displaying claimant's who only have award claims. Thus I do not want to display claimant # 001 since that claimant has claims other than AWARD. I have tried to use a global variable in a...