BIRT Runtime and Excel data sources

entomo

<p>I've created a report in BIRT designer and it runs fine, however when I try to render it with BIRT runtime, it can't find the Excel files that are the data sources.  The following stack trace dumps out:</p><p> </p><div>Caused by: org.eclipse.datatools.connectivity.oda.OdaException: Unable to locate the specified Excel data source folder or file (details_clean.xlsx).</div><div>        at org.eclipse.birt.report.data.oda.excel.impl.util.ExcelFileSource.populateHomeDir(ExcelFileSource.java:176)</div><div>        at org.eclipse.birt.report.data.oda.excel.impl.util.ExcelFileSource.<init>(ExcelFileSource.java:88)</div><div>        at org.eclipse.birt.report.data.oda.excel.impl.ExcelFileQuery.prepareMetaData(ExcelFileQuery.java:180)</div><div>        at org.eclipse.birt.report.data.oda.excel.impl.ExcelFileQuery.getMetaData(ExcelFileQuery.java:632)</div><div>        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:423)</div><div>        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:390)</div><div>        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:407)</div><div>        ... 46 more</div><div> </div><div>I'm running from the same directory the report file and excel files are located in:</div><div> </div><div><div>C:UsersjchoytworkspaceEBMO>f:birt-runtime-4_4_0ReportEnginegenReport.bat -f HTML -p "component=****" CommoditySpendingOverview.rptdesign</div></div><div> </div><div>I've tried moving the excel files to the birt runtime directory and it's lib (hoping for a classpath fix).  I've also tried manually changing the rptdesign file to prepend . to the excel file names.</div><div> </div><div>Any idea how to tell BIRT Runtime where these files are?</div><div> </div><div>Thanks!</div>

pricher

<p>Hi,</p><p> </p><p>When you define your Data Source and you point to your Excel file, are you using a Relative or an Absolute path? If you use an Absolute path, it will work. To define the source as an absolute path, click on the little down arrow on the Browse button. By default, if you click only on the browse button, the path is relative to your BIRT project. There might be a way to configure the runtime engine to use a relative path, but I have not found it. Using Absolute path is your best bet!</p><p> </p><p>Hope this helps,</p><p> </p><p>P.</p>