Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
CSV file from classical model
Migrateduser
<p> Hi ,<br>
I am trying to generate a csv file from the Classical Model . I first generate the rptdocument and use it to create my csv file .<br>
When i view the CSV file , my column headers are displayed as the names of the Columns from the Classical Data Set .<br>
Can anyone explain me , why might this be happening ?<br><br>
Attached is my rpt design .</p>
<p> </p>
<p>And this is my code</p>
<p> </p>
<p>IEngineTask task=null;<br>
IRunTask runTask=null;<br>
String rptDocument = "c:\\reports\\testing2Csv"+".rptdocument";<br><br>
EngineConfig config = new EngineConfig();<br>
try {<br>
<br>
Platform.startup(config);<br>
ReportEngine engine = new ReportEngine(config);<br>
File csvFile = new File("c:\\reports\\testing2CsvFile.csv");<br>
<br>
ObjectOutputStream om = new ObjectOutputStream(new FileOutputStream(csvFile));<br>
<br>
//MY RPTDESIGN<br>
IReportRunnable design = engine.openReportDesign("C:\\documents\\columnordering.rptdesign");<br>
runTask = engine.createRunTask(design);<br>
runTask.run(rptDocument);<br>
<br>
<br>
//MY RPTDOCUMENT<br>
IReportDocument iReportDocument = engine.openReportDocument("c:\\reports\\testing2Csv.rptdocument");<br>
task = engine.createDataExtractionTask(iReportDocument);<br>
<br>
<br>
ICSVDataExtractionOption extractionOptions = new CSVDataExtractionOption();<br>
<br>
extractionOptions.setOutputFormat("csv");<br>
extractionOptions.setSeparator(",");<br><br>
extractionOptions.setOutputStream(om);<br>
extractionOptions.setOutputFile("c:\\reports\\testing2CsvFile.csv");<br>
<br>
IDataExtractionTask iDataExtractTask = (IDataExtractionTask)task;<br>
iDataExtractTask.extract((IExtractionOption)extractionOptions);<br>
System.out.println(task);<br>
<br>
<br>
<br>
}catch (BirtException e) {<br>
e.printStackTrace();<br>
} catch (FileNotFoundException e) { <br>
e.printStackTrace();<br>
} catch (IOException e) {<br>
e.printStackTrace();<br>
} <br>
<br>
}</p>
Find more posts tagged with
Comments
There are no comments yet