Hello,

I have data that always comes back in four rows. The first column is text and is unique. The second column is a numerical value. I need to show the numbers of the first three rows with no decimal place, but the forth row must show two decimal places. Can anyone help?


Grant

Grant -
Here is a link to a discussion about varying the format.

link

Thanks for the info. I use stored procedures and not master files, so I am not sure on where I should be placing the formatting code. Here is a sample of the beginning of my fex file:

-DEFAULT &INDATE = 'DATENOW'
-DEFAULT &FMT = 'PDF'
ENGINE SQLORA SET DEFAULT_CONNECTION DATABASE_NAME
ENGINE SQLORA EX STORED_PROCEDURE_NAME '&INDATE';
-RUN
TABLE FILE SQLOUT

PRINT
PRODUCT AS ''
DAILY_AMOUNT/MYFORMAT AS 'Daily,Amount'
DAILY_PLAN/D20 AS 'Plan'
PLAN_VALUE/D20 NOPRINT
WEEKLY_AVG/D20.1 AS 'Weekly,Avg'

Where would I place the following code so that the DAILY_AMOUNT column is formatted with my custom formatting?

MYFORMAT/D20 = DECODE PRODUCT('Truck Sales' 'D20.4' ELSE 'D20.1')


Thanks,


Grant

DEFINE FILE SQLOUT

quote:

MYFORMAT/D20 = DECODE PRODUCT('Truck Sales' 'D20.4' ELSE 'D20.1');

END

TABLE FILE SQLOUT
...

I now recieve this error:

FORMAT ERROR IN DECODE OR FILE ELEMENT: 'D20.2'

The PRODUCT column will always return text, so I'm not sure if this decode statement will work to try to format the other columns.


-Grant

small typo. the define should be:

  
MYFORMAT/A8 = DECODE PRODUCT('Truck Sales' 'D20.4' ELSE 'D20.1');

Excellent, that worked! Thanks all for all your help.


Grant

Grant

I think you need to do something with a counter in combination with the above formating function, unless the 4 the row is based upon the value of the first (text) value.

Yeah, the number of decimal places depends on what the value of PRODUCT is only, so I think this will work out fine.


Grant