Home » Developer & Programmer » Reports & Discoverer » Is there a way to pass 'Delimiter' ',' in Reports Builder? (Report Builder 10.1.2.0.2)
Is there a way to pass 'Delimiter' ',' in Reports Builder? [message #486436] Wed, 15 December 2010 09:21 Go to next message
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,
Is there a way to pass 'Delimiter' ',' in Reports Builder? [message #486451 is a reply to message #486436] Wed, 15 December 2010 11:15 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: From report to text file
Next Topic: Worksheet Identifier (Oracle Discoverer)
Goto Forum:
  


Current Time: Tue Apr 07 01:44:00 CDT 2020