Home » Developer & Programmer » Reports & Discoverer » MATRIX REPORT TO EXCEL FILE
icon5.gif  MATRIX REPORT TO EXCEL FILE [message #261353] Wed, 22 August 2007 06:39 Go to next message
vidya.soujanya
Messages: 4
Registered: August 2007
Location: chennai
Junior Member
hi,
can any one help me out how to generate matrx report to excel file. i have done this . but the exact layout is not getting diplayed in the excel file.
I have attache the layout i ma trying to export to excel.

I am attaching the out put file also

Please help me out.....
  • Attachment: layout.doc
    (Size: 106.00KB, Downloaded 1435 times)

[Updated on: Wed, 22 August 2007 06:40]

Report message to a moderator

Re: MATRIX REPORT TO EXCEL FILE [message #261368 is a reply to message #261353] Wed, 22 August 2007 07:11 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

here is an example ...i think it will be help full..
RPT2XLS procedure is used ...
Re: MATRIX REPORT TO EXCEL FILE [message #261369 is a reply to message #261353] Wed, 22 August 2007 07:13 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

plus read this and i think u can easily export ur matrix report to EXCEL..
  • Attachment: readme.txt
    (Size: 3.26KB, Downloaded 1680 times)
Re: MATRIX REPORT TO EXCEL FILE [message #261374 is a reply to message #261369] Wed, 22 August 2007 07:21 Go to previous messageGo to next message
vidya.soujanya
Messages: 4
Registered: August 2007
Location: chennai
Junior Member
hi,
i am uploading my rdf file to this. pleas check the export to excel coding i have specified in afterparameter form.


please help me out.......
Re: MATRIX REPORT TO EXCEL FILE [message #318654 is a reply to message #261374] Wed, 07 May 2008 08:27 Go to previous messageGo to next message
Fomich
Messages: 1
Registered: May 2008
Location: Russia, Moscow
Junior Member
Hi, all.

I try to launch MATRIX_DEMO.rdf with inserted RPT2XLS.Run into AfterReport Trigger.
The parameters is
2008-05-07 17:04:59: startrep.exe "RWRUN.exe" userid="FOMICHEV/***@TEST10G" REPORT="c:\MATRIX_DEMO.rdf" PRINTJOB=NO DESTYPE=file DESNAME="1.xls" MODE=Bitmap COPIES=1 DESFORMAT=PDF BACKGROUND=No PARAMFORM=NO P_TITLE="Report"
as written in readme.txt.

But i receive bad XLS file as shown in picture below.

When i change DESFORMAT to DELIMITED, then i receive error message
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: BACKGROUND is deprecated. See help for more information.
REP-1401: 'afterreport': Fatal PL/SQL error occurred.
ORA-43356: Message 43356 not found; product=RDBMS; facility=ORA

305500: non-ORACLE exception

I have Oracle Reports 10g ( 9.0.4), Windows 2000 SP 2, MS Office Excel 2003 Service Pack 3 and Oracle 10.2.0.3.0.

Can you help me ?
  • Attachment: 1.gif
    (Size: 24.99KB, Downloaded 577 times)
Re: MATRIX REPORT TO EXCEL FILE [message #529633 is a reply to message #261368] Wed, 02 November 2011 04:26 Go to previous messageGo to next message
shantysaggu007
Messages: 6
Registered: July 2011
Location: ludhiana
Junior Member

Sir Simple Report Is Possible,
Can U Tell Me Idea How To Convert Matrix Report With Have Group By Field,
In This The Col Function Count Sequence So The Location Cannot Proper Position In Xls

[Updated on: Wed, 02 November 2011 04:43]

Report message to a moderator

Re: MATRIX REPORT TO EXCEL FILE [message #529640 is a reply to message #529633] Wed, 02 November 2011 04:44 Go to previous messageGo to next message
shantysaggu007
Messages: 6
Registered: July 2011
Location: ludhiana
Junior Member

THE OUT PUT OF REPORT
Re: MATRIX REPORT TO EXCEL FILE [message #553714 is a reply to message #529640] Tue, 08 May 2012 02:26 Go to previous messageGo to next message
jolieassaad
Messages: 18
Registered: May 2012
Location: Lebanon
Junior Member
HI, I use the same package but for more then 3 columns . I call the rdftoxls.put_cell in the repeating frame which contains all the data that I want.
But I find in the excel, duplicate data for the first record of each report page.
Could you please help me with this?

Regards,
Hala
Re: MATRIX REPORT TO EXCEL FILE [message #554722 is a reply to message #261353] Wed, 16 May 2012 18:09 Go to previous message
dude4084
Messages: 213
Registered: March 2005
Location: Mux
Senior Member
Excellent Guidence.

Made my first experince wonderful and hence my love with orafaq is increased.
Thanks musman.


What i acheived is: Matrix Report converted in Excel. The column had two variables and so the sum field. The matrix data can be from 2 columns to 2 x n times.



Previous Topic: reporting against aphold.release name
Next Topic: rwclient.sh key mapping
Goto Forum:
  


Current Time: Wed Apr 16 07:33:57 CDT 2014

Total time taken to generate the page: 0.08852 seconds