OraFAQ Forum: Reports & Discoverer » Export data from RDF to Excel

Home » Developer & Programmer » Reports & Discoverer » Export data from RDF to Excel (Reports 10g)

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

Export data from RDF to Excel [message #405488]

Thu, 28 May 2009 01:00

ashok_lila
Messages: 9
Registered: April 2006
Location: New Delhi

Junior Member

Hi All,

I stuck in a issue.
I want to generate the excel output from a RDF.
If I am using the DESFORMAT=DELIMITED then I am getting unformated data and some time I am getting less data as per PDF output.
There are about 25 queries with interrelated way.

Can anyone suggest How can I get the output in excel from a RDF.

In Reports 6i Functionality was working while we were running reports because of reports were running in Previewer mode but in 10g reports output coming in PDF format.

Please help me in urgent.

Thanks in advance.

Ashok K Gupta

Report message to a moderator

Re: Export data from RDF to Excel [message #406946 is a reply to message #405488]

Sun, 07 June 2009 22:38

sysman2007
Messages: 24
Registered: March 2009

Junior Member

SET DESFORMAT = SPREADSHEET

DECLARE
  V_PAR_OTHERS VARCHAR2(512);
BEGIN
  V_PAR_OTHERS := 'DESFORMAT = SPREADSHEET'; 
END;

[Updated on: Sun, 07 June 2009 22:38]

Report message to a moderator

Re: Export data from RDF to Excel [message #407548 is a reply to message #406946]

Wed, 10 June 2009 07:55

gaurav.mcabanti
Messages: 5
Registered: May 2007

Junior Member

hi

please tell us.. where to write the code mentioned by you for setting the desformat.

i am setting this in the property of desformat in reports 6i

but result is report not converted to excel.

please help.

Gaurav Kumar Sharma

Report message to a moderator

Re: Export data from RDF to Excel [message #408259 is a reply to message #407548]

Mon, 15 June 2009 09:05

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi,

even i have the same problem. i am using oracle 8i. where should one write the code. i will be needing in every rdf report. i tried to set desformat = spreadsheet in the property palatte, but couldn't achieve the result. Pl explain it in detail.

thanks in advance

Report message to a moderator

Re: Export data from RDF to Excel [message #408274 is a reply to message #408259]

Mon, 15 June 2009 09:31

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi,

I did try using the code in the property pallette validation trigger. how do i get the report in excel form. i did try to save it giving an xls extension, but i don't get the desired result

where have i gone wrong?

lacchhii

Report message to a moderator

Re: Export data from RDF to Excel [message #408710 is a reply to message #408274]

Wed, 17 June 2009 06:42

ashok_lila
Messages: 9
Registered: April 2006
Location: New Delhi

Junior Member

Hi,

You can set the desformat for tabular type reports and it will give you the approxiate result but while we have group above or other type of reports we can't just set as Desformat and can't get the proper formatted result in excel.

For this we have to use the another code functionality at format triggers of different level frames:

declare
v_FileID Utl_File.File_Type;
BEGIN
IF NOT (Utl_File.Is_Open(v_FileID)) THEN
v_FileID:= Utl_File.Fopen(Location=>'FLS_ORAOUT',
FileName=>:p_filename, Open_Mode=>'W', Max_Linesize =>
32767);
END IF;
Utl_File.Putf(v_FileID, '\n');
Utl_File.Put(v_FileID,'Eqpt. No.'||chr(9));
Utl_File.Put(v_FileID,'Qty.'||chr(9));
Utl_File.Fclose(v_FileID);
END;

This code we have to write on different level of frames.
In initial code we have to arite a new file and then we have to append the data in our next codes.

Using of this code you can set formatting of your report output in any manner without loosing you cirrent report layout.

Thanks
Ashok

Report message to a moderator

Re: Export data from RDF to Excel [message #411569 is a reply to message #408710]

Sun, 05 July 2009 08:20

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi ahok,

01) could you pl give me a screenshot of the different level frame where the code has to be entered

In initial code we have to arite a new file and then we have to append the data in our next codes.

i could get this point. could you pl explain it in detail. Sorry i am quite new to oracle.

02) After writing this code and the report generated, how do i save it in excel file?

thanks in advance

lacchhii

Report message to a moderator

Re: Export data from RDF to Excel [message #514693 is a reply to message #408710]

Tue, 05 July 2011 23:31

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

sir i past this code in
DESFORMAT/Validation/Trigger

declare
v_FileID Utl_File.File_Type;
BEGIN
--IF NOT (Utl_File.Is_Open(v_FileID)) THEN v_FileID:= Utl_File.Fopen(Location=>'FLS_ORAOUT', FileName=>:p_filename, Open_Mode=>'W', Max_Linesize => 32767);
IF NOT (Utl_File.Is_Open(v_FileID)) THEN v_FileID:= Utl_File.Fopen(Location=>'FLS_ORAOUT', FileName=>'fahim.xls', Open_Mode=>'W', Max_Linesize => 32767);
END IF;
Utl_File.Putf(v_FileID, '\n');
Utl_File.Put(v_FileID,'Eqpt. No.'||chr(9));
Utl_File.Put(v_FileID,'Qty.'||chr(9));
Utl_File.Fclose(v_FileID);
END;

1. when i try to comply that give me error of declare line
then i remarks this line --declare and complied

2. when i run this report that give me error
REP-1401 : 'desformatvalidtrigger': Fatal PL/SQL error occurred.

please give me idea how i convert my report to xls format

best regard

fahim

Report message to a moderator

Re: convert matrix report to excel [message #517326 is a reply to message #405488]

Mon, 25 July 2011 07:12

shantysaggu007
Messages: 6
Registered: July 2011
Location: ludhiana

Junior Member

hello to all
i m converting a matrix report to excel,
but i m facing problem row over right on format trigger( fram across),
so it not send all data in excell
if any one have any idea plzz help meeee.[/color]

byeeee.....

Attachment: order_balance.RDF
(Size: 152.00KB, Downloaded 1862 times)

[Updated on: Mon, 25 July 2011 07:13]

Report message to a moderator

Previous Topic:	Migrate from reports 6i to reports 11g
Next Topic:	Report Field Value to be Printed Partially in 3 Places

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 09 23:27:12 CST 2024