I could not able to bring a '%' for a computed column values if I try to bring it in a excel format.. I don't remember the code but I will put a little here just for your idea.
TABLE FILE CAR PRINT CAR COMPUTE TEST/D12.2% = 10 * DEALER_COST; ON TABLE PCHOLD AS EXL2K END
In HTML, I can see the '%' coming for all values in a column (TEST) where as in EXCEL it is not.
I don't want to convert from packed decimal to alpha and concate % symbol
Any idea ?
Thanks!This message has been edited. Last edited by: Kerry,
This seems to work fine:
TABLE FILE CAR
COMPUTE TEST/D12.2% = 10 * DEALER_COST;
ON TABLE PCHOLD FORMAT EXL2K
What I have found is that the '%' sign is carried into excel for the report data but not subfoots. My fields were packed so I converted them to alpha using the PTOA() function and it pulled the '%' sign in, but they are now alpha values in the excel spreadsheet.
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
All data in headings, footings, subheadings and subfootings is in alpha string format. Just append a "%" to the result of the PTOA function.
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
|Powered by Social Strata|