Recent content by Atrzy

That worked. Thanks!

Is it possible to write a CASE statement using AND? Here's an example of what I'm trying to do: If Location = 0001E and Jobcode = 900922 Then return Director If Location = 0001 and Jobcode = 900922 The return Allocator Else NA I don't know how to properly write the CASE statement. I'm on...

It may mean that you cannot sort on a text field or ntext field. Are you trying to sort by a text field or include a text field in a WHERE clause?

Debchattin: Are you still sending out copies of your report? If so, I'd really like to have a copy!

What is the derived field you wrote that isn't working?

Try this (Example is with basic PS_Employees table): 1st Derivied Field SUBSTR("PS_Employees.SSN",6) 2nd Derived Field Use concatenation to combine 'XXX-XX-' with first derived field

I'm on Oracal 9 and don't write SQL directly so my reply may not help. However, it may give you some ideas. Since you haven't identified which tables/columns you are currently using in your report I'm just going to give you ideas. If you're looking to create a simple report with only those...

What is it that you want the derived field to do - return just those persons who are between 12-18? Also, what table/column have you used for age?

Your formula isn't written correctly. I think the placement of the derived formula you're using in this formula is wrong, and you haven't included an ELSE option. Try this: CASE WHEN (insert your "floor" derived formula here) <1 THEN 'less than 1 year' WHEN (insert your "floor" derived formula...

Thanks obiwaugh, I am on Orcale 9. I figured out the CASE statement earlier this week. It worked perfectly!

My report lists employees by name, job, comprate, etc. I want to group together all persons who earn between a certain rate of pay (comprate). For example, Group A would be between $7.00 and $9.00, Group B between $9.01 and $11.00, and so on (up to as many as 7 groups). Can I do this with a...