Search results for query: *

You need a derived field. It will be something like this. SUM(DISTINCT DECODE("REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWEARNSCD",'B' ,"REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWEARNSAMT",0 )) This says that when the earnings code is 'B' put the amount in the column. If there's no amount enter '0'.

Hi, I have the report set up as follows: PERSONAL_DATA is linked to JOB by EMPLID JOB is linked to GENL_DEDUCTION by EMPLID and EMPLID_RCD_NBR. JOB is linked to PAY_CHECK by EMPLID and EMPLID_RCD_NBR PAY_CHECK is linked to PAY_DEDUCTION by COMPANY, LINE_NBR, OFF_CYCLE, PAGE_NBR, PAY_END_DT...

This is a payroll client (not autolink) so instead of the AL tables I use PAY_CHECK AND PAY_DEDUCTION. I can only check 'unmatched records' from one table. When I try to check it for multiple tables (i.e. PAY DEDUCTION and GENL_DEDUCTION) I get the following error message: ORA-01417: a table...

I am trying to create a report that will list the employees general deductions from the GENL_DEDUCTION table and the deduction from the employees pay check from the PAY_DEDUCTION table. The problem is that if the deduction is not listed on the PAY_DEDUCTION table (because nothing came out of...

I am trying to create a report which will be pulling 4 to 5 check dates (depending on the month). Each check date needs to be in it's own column. Does anyone know how to accomplish this? Thanks!!!

That did not work. Does anyone else have any suggestions?

I am creating a Crosstab report and want to be able to suppress lines where the count = 0. Is there an option when creating the report that does this the key here is it's a Crosstab and the totals are created by the Crosstab function.

Hi, I have created a report that pulls the history rows of the JOB table. Now I need an Order By or Row Number derived field. I have been unable to create this. Any suggestions? The background on this report is that I only want the last 5 rows from the history of the JOB table. Unfortantly...

Hi, I have a derived field set up to take the annual rate and times it by certain numbers. I want to then take that total and I want it to just give me the first three digits in the thousands place. For example, if the derived field returns anywhere between 1,000 and 9,999 I want it to return...

I am now wondering if I should be using a Length function instead of a RTRIM. Does anyone have any input on that? Thanks!

Derived field: RTRIM("PS_PERSONAL_DATA"."NAME",30) My Starting data is: Smith,Wendy L My expected output is: Smith,Wendy L (with spaces after the L that would total 30 in length. If the name is longer than 30 it should cut off the name at 30) My Actual output is: Smith,Wendy L (then when I save...

I have created a fixed length derived field Rtrim(fieldname, length) and am trying to save it as a txt file. However, when I save this as the txt file it is not retaining it's format, and does not seem to matter that I click the retain format button. Does anyone have any suggestions as to how...