nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

XLSX generation via genReport not working

wohu64

<p>Hello,</p>
<p> </p>
<p>i tried to generate xlsx-reports via batch-command (genReport) - no success

</p>
<p> </p>
<p>my batch-file:</p>
<p> </p>
<div>Set BIRT_HOME=C:\Birt\birt-runtime-4_4_0</div>
<div>call %BIRT_HOME%\ReportEngine\genReport.bat -runrender -o "%BIRT_HOME%\test.xlsx" -f XLSX "%BIRT_HOME%\WebPivotZR.rptdesign"</div>
<div> </div>
<div>(you see, I have installed birt-runtime 4.4)</div>
<div> </div>
<div>I got a html-file instead of an xlsx-file - funny thing!</div>
<div> </div>
<div>Is it possible to generate other formats than HTML or PDF via genReport?</div>
<div> </div>
<div>Thanks in advance</div>
<div>wohu</div>
<div> </div>

Find more posts tagged with

Comments

wohu64

<p>Hi,</p>
<p> </p>
<p>I found the solution in an other topic: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/29918-genreportbat-only-produces-html-fallback-files/'>http://developer.actuate.com/community/forum/index.php?/topic/29918-genreportbat-only-produces-html-fallback-files/</a></p>
<p> </p>
<p>Solution: Just change the command line and delete the command-parameter "-runrender"!</p>
<p> </p>
<p>My new batch-File:</p>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Set BIRT_HOME=C:\Birt\birt-runtime-4_4_0</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">call %BIRT_HOME%\ReportEngine\genReport.bat<strike> -runrender</strike> -o "%BIRT_HOME%\test.xlsx" -f XLSX "%BIRT_HOME%\WebPivotZR.rptdesign"</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">That's all.</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Thanx to all</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Bye</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">wohu</div>

mwilliams

I think it is limited to HTML or PDF, but I could be wrong. It sure sounds that way if you're not able to get xlsx to work. Have you tried any other outputs? If you can't get any other outputs, to change this, you'd have to change the source for the ReportRunner or build your own class to use to run reports from the command line.

Robsen

<p>I can confirm that in the actual runtime XLSX can created with the command line.</p>
<p> </p>
<p>This is what i am using:</p>
<p><span style="color:#000000;"><span style="font-family:helvetica, sans-serif;">D:\birt-runtime-4_4_1\ReportEngine\genReport.bat -F

\birt-runtime-4_4_1\ReportEngine\samples\myparams2.properties -f XLSX -o test6.xlsx â€“F

\birt-runtime-4_4_1\ReportEngine\samples\test2.rptdesign</span></span></p>
<p> </p>
<p>I put my parameters into a property file and dont use the -p option in the example above.</p>

mwilliams

Thanks, Robsen.