Can we create multiple tabs in CSV output ?

gns_jde

Member
I have reached max limit of 81 columns in CSV output, but still need to add few more fields in output. Not sure if we can add more than 81 columns or can create multiple tabs in single file.
 
You can't create "tabs" in a CSV file because even though the file may open in Excel it is not a spreadsheet file, it is a text file containing CSV formatted data.
 
Not sure what you mean, max of 81 columns....
Excel 2007 and later supports 16,384 columns. Before that Excel's limit was 256 columns.

If you're think that's all RDA will allow, try making a custom paper size - the version of PDF EOne uses should support up to 200 inches wide or high (caveat: I haven't tried it, there may be other tooling limitations I don't know, that's just by looking at the PDF 1.4 specs)
 
Last edited:
You should be able to add as many columns as needed up to limits in Excel. Try adjusting the paper size of the report output. As a 2nd option, there are a number of business functions that can be used to create a flat file instead of using csv report output. Check out B34A010 or B76B0220. Those are just a couple examples. You can find others searching JDElist.
 
From Oracle Support:

Output to CSV Width Limitation of 45 Inches

In Report Design Aid, the maximum width allowable in Print Setup when setting a Custom paper size is up to approximately 45 inches. There is no way to override the maximum width in Print Setup. Therefore, the limit on the number of columns in RDA also cannot be overridden. When formatting a report for CSV output, all the information required for the report must be inserted in the available design space.

If this is not possible, as a workaround option, in RDA rather than using the option for Export to CSV, use the Database Output functionality to output a Comma Delimited file with a CSV file extension following the steps below:
1.Focus on the appropriate section and click on Section|Database Output
2.In the Mapping Targets screen,
◦Double-click on the Type cell and select Comma delimited file
◦Enter the name of the file with or without the path location.
◦Click Next
3.On the Mappings screen, select the mapping for each field to output to the flat file
◦For each Target Column, Double-click on the Source Section and choose the same section as in step 1
◦Double-click on the Source Object and choose the appropriate RV or BC object.
 
Back
Top