OraFAQ Forum: Reports & Discoverer » Report to Excel Conversion

Home » Developer & Programmer » Reports & Discoverer » Report to Excel Conversion

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report to Excel Conversion [message #310981]

Thu, 03 April 2008 02:56

hasnainlakhani
Messages: 24
Registered: January 2007

Junior Member

How to set format mask of Date and Number DataType in Report to Excel Conversion i-e- rpt2xls Package

Hasnain Raza

Report message to a moderator

Re: Report to Excel Conversion [message #311046 is a reply to message #310981]

Thu, 03 April 2008 05:18

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

well.what ever format you use on your report.
same will be transfered to excel sheet using RPT2XLS.

Do you want changed format while exporting to excel as
compared to your report???

[Updated on: Thu, 03 April 2008 05:19]

Report message to a moderator

Re: Report to Excel Conversion [message #311087 is a reply to message #311046]

Thu, 03 April 2008 06:57

hasnainlakhani
Messages: 24
Registered: January 2007

Junior Member

Will u please give me RPT2XLS Package and any report example
which sets format mask for excel as shown in report using RPT2XLS Package.

Hasnain Raza

Report message to a moderator

Re: Report to Excel Conversion [message #311100 is a reply to message #311087]

Thu, 03 April 2008 07:08

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

just use this

RPT2XLS.put_cell(11, 'AGM.DATE', FontColor => 44,
BgrColor => 47,  FontSize => 8, FontStyle => RPT2XLS.BOLD 
,Align => RPT2XLS.CENTER
  );

in format trigger of specific field.
set format mask of date field on report.

[Updated on: Thu, 03 April 2008 07:09]

Report message to a moderator

Re: Report to Excel Conversion [message #311422 is a reply to message #311100]

Fri, 04 April 2008 08:06

hasnainlakhani
Messages: 24
Registered: January 2007

Junior Member

I already know how to set FontSize, FontColor, FontStyle, Align
and BgrCOLOR. I want to know how to set Format Mask of Number and Date DataType using RPT2XLS.put_cell.

Hasnain Raza

Report message to a moderator

Re: Report to Excel Conversion [message #311818 is a reply to message #311422]

Mon, 07 April 2008 00:23

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

RPT2XLS.put_cell(11, your_column, FontColor => 1, FontSize => 8, Format => 'DD/MM/YY' ,Align => RPT2XLS.CENTER
);

Report message to a moderator

Re: Report to Excel Conversion [message #311860 is a reply to message #311818]

Mon, 07 April 2008 02:57

hasnainlakhani
Messages: 24
Registered: January 2007

Junior Member

Will u please mention me how to apply Number format masks.

I am trying to use the format mask as shown in Property Palette of Number Data Type but it couldn't work using format option as u mentioned in your last reply

Hasnain Raza

Report message to a moderator

Re: Report to Excel Conversion [message #311903 is a reply to message #311860]

Mon, 07 April 2008 06:03

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

Why don`t you set format mask on report level.

Also can you please post here put_cell code you are using
with number format you required.
Tell me number format you require so i can check it.

[Updated on: Mon, 07 April 2008 06:05]

Report message to a moderator

Re: Report to Excel Conversion [message #312162 is a reply to message #311903]

Tue, 08 April 2008 02:25

hasnainlakhani
Messages: 24
Registered: January 2007

Junior Member

What other options can be set using format keyword in rpt2xls.put_cell. Format Mask of Number and Date data Type are now set.
Please provide an example if any other task can be performed other than setting format mask

Thanks for your Corporation

Hasnain Raza

Report message to a moderator

Re: Report to Excel Conversion [message #312183 is a reply to message #312162]

Tue, 08 April 2008 02:47

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

For other options you better see RPT2XLS package.
As far as i concern it`s enough flexible to format your excel
file.
As u asked about other tasks you can add list and sorting.For this you have to change package according to your requirement.

Report message to a moderator

Re: Report to Excel Conversion [message #312691 is a reply to message #312183]

Wed, 09 April 2008 10:56

fiery_hanzy
Messages: 10
Registered: December 2007

Junior Member

use (NNN,NNN0.00)
EXCEL OUTPUT : 123.00 ==> for +ve no.
(123.00) ==> for -ve no.
0.09 ==> for no < 0.

Report message to a moderator

Re: Report to Excel Conversion [message #312696 is a reply to message #312691]

Wed, 09 April 2008 11:12

fiery_hanzy
Messages: 10
Registered: December 2007

Junior Member

or try dis in the main query

select decode(sign(emp.amount),
1,
to_char(emp.amount,'FM99999,999,999.00'),
-1,
'('||to_char(abs(emp.amount),
'FM99999,999,999.00')||')')
from employee emp

Report message to a moderator

Re: Report to Excel Conversion [message #315345 is a reply to message #310981]

Mon, 21 April 2008 04:08

blaze
Messages: 5
Registered: April 2008

Junior Member

But how can I use "CenterAcrossSelection"? How can I define in across which cells I need to put value?

Report message to a moderator

Previous Topic:	crosstab layout
Next Topic:	Converting columns into rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 13:20:56 CDT 2024