OraFAQ Forum: Reports & Discoverer » Is there a way to pass 'Delimiter' ',' in Reports Builder?

Home » Developer & Programmer » Reports & Discoverer » Is there a way to pass 'Delimiter' ',' in Reports Builder? (Report Builder 10.1.2.0.2)

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

Is there a way to pass 'Delimiter' ',' in Reports Builder? [message #486436]

Wed, 15 December 2010 09:21

averion
Messages: 42
Registered: January 2009
Location: US

Member

Hello Experts,

I need to produce Excel spreadsheet from report builder.

currently I am getting a format like,

ProductID;Count;CountUnique;
1001;12;16;
1002;11;6;
1004;16;666;
1006;60;86;

This format when opened in Excel does not group in separate columns resulting in all getting mixed up.

I am looking a format like,

ProductID,Count,CountUnique,
1001,12,16,
1002,11,6,
1004,16,666,
1006,60,86,

This opens up clearly on excel. items like Product,Count
are shown on separate columns along with the value.

I am still looking into delimited formatting.

Thanks,

Report message to a moderator

Is there a way to pass 'Delimiter' ',' in Reports Builder? [message #486451 is a reply to message #486436]

Wed, 15 December 2010 11:15

averion
Messages: 42
Registered: January 2009
Location: US

Member

Hello Experts,

Is there a way to pass 'Delimiter' ',' in the report builder.
I only see parameters like :DESFORMAT, :DESNAME etc.

Currently I am using :desformat :='DELIMITEDDATA' and I need to pass ',' as a delimiter from the report itself.

Is there a way to do this?

Thanks,

[EDITED by LF: Merged and renamed topics; the original title was Report Builder's version]

[Updated on: Thu, 16 December 2010 00:56] by Moderator

Report message to a moderator

Re: Is there a way to pass 'Delimiter' ',' in Reports Builder? [message #490673 is a reply to message #486451]

Wed, 26 January 2011 10:10

banksilp
Messages: 6
Registered: January 2011
Location: 66

Junior Member

I would prefer you 2 method
• DESTFORMAT= you can choose PDF, HTML, HTMLCSS, RTF, XML, SPREADSHEET, DELIMITED, DELIMITEDDATA and try

or try this query

SELECT
ProductID || ',' || Count || ',' || CountUnique AS "DELIMIT_DATA"
FROM
your_table
;
-- DESFORMAT = dlft
-- DESNAME = you_file.txt
-- DESTYPE = file
-- MODE = character

regards,
banksilp

Report message to a moderator

Previous Topic:	From report to text file
Next Topic:	Worksheet Identifier (Oracle Discoverer)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:48:54 CDT 2024