Hello there,
Today I experienced a new issue and sure that its not a excel version issue. Here is the scenario.
In our report we are holding and printing the SQLORA file which includes some sql packages. Data is coming as expected. In some columns the data has % symbol in it like "TES%T". The out put is same in PDF and HTML. But when the same is taken on to a excel the % symbol is getting stripped off and displaying as "TEST".
Please assist. Thanks,

This message has been edited. Last edited by: <Kathryn Henning>,

Taking your Oracle package out of the equation and trying to render an '%' with a simple request in EXL2K format works fine:

TABLE FILE CAR
PRINT COUNTRY
COMPUTE TEST/A20 = 'TEST%ME';
ON TABLE PCHOLD FORMAT EXL2K
END

How about this:

SQL SQLORA
<your PL/SQL call here>
;
TABLE ON TABLE HOLD AS HDATA
END
-RUN

TABLE FILE HDATA
PRINT *
ON TABLE PCHOLD FORMAT HTML
END

Does that keep your '%' sign intact?

If so, try then changin the format to EXL2K and see what happens.

As the report is now being produced out of a binary HOLD file, at least you can take Oracle out of consideration and focus on what may be causing the '%'character to dissapear ... or not.

This message has been edited. Last edited by: njsden,

Thanks for your response. Here is the example to explain my issue better. let suppose

SQL SQLORA

FIELD1 (ACTUAL FIELD LENGTH - A300V)
FIELD2 (ACTUAL FIELD LENGTH - A4000V)
;
ON TABLE HOLD AS HDATA
END
-RUN



TABLE FILE HDATA
PRINT
FIELD1
FIELD2
ON TABLE PCHOLD FORMAT HTML/PDF
END
O/P:
FIELD1 FIELD2
For%testing%purpose TES%T01
For%testing%purpose TES%T

Same date when pulled on to an exl2k, % symbol is getting stripped off. However for field 1, the % symbol is showing up.
TABLE FILE HDATA
PRINT
FIELD1
FIELD2
ON TABLE PCHOLD FORMAT EXL2K
END
O/P:
FIELD1 FIELD2
For%testing%purpose TEST01
For%testing%purpose TEST

If we keep a compute field with data type A300V as that of FIELD1 its working. Not sure how.

TABLE FILE HDATA
PRINT
FIELD1
COMPUTE/A300V =FIELD2; AS FIELDS2_1
ON TABLE PCHOLD FORMAT EXL2K
END
O/P:
FIELD1 FIELD2_1
For%testing%purpose TES%T01
For%testing%purpose TES%T

There might be strings with more than A300V for which the report might break. Please assist. Thanks.

Try trapping the MHT output from the EXL2K format and look at it in your favorite editor app. If you see the data with the '%' inclusion then it's MS Excel causing you issues, otherwise contact support.

T

In spite of trying with the .mht (Excel) format option, I am still not able to get the % symbol in the Excel output.
To isolate the issue. Please check the below example
TABLE FILE CAR
PRINT
COMPUTE TEST/A600V = 'SAMP%LE%';
CAR
ON TABLE PCHOLD FORMAT EXL2K
END
For PDF, % is being displayed on the O/P for col TEST.
For excel its simply showing as SAMPLE. However if i change the data type from A600V to A575V it is working fine. Not sure why it is getting broken after A575V. Please assist. Thanks.

This message has been edited. Last edited by: Prabhakar,