jasperserver Version: 6.0.0Build: 20141128_1450
my report contains a title band with a customized title depending on input parameters and then the detail band contains a table for the subquery.
the table has a column header row which is repeated for each of my pdf pages. However, if I specify xlsx output, I don't want it to repeat. If I run the query directly from jasperserver and then use the file icon to select export as xlsx, I get my 2 rows of title and 1 row of column header. If I run the query via my visualize.js calls, I get 2 rows of title, and the column row is repeated every page. How do I get rid of that? I have the following properties in my jrxml
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="TECInternal"/>
<property name="ireport.jasperserver.user" value="jasperadmin"/>
<property name="ireport.jasperserver.report.resource" value="/public/Test_Data/ContributionsByFilerID_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/public/Test_Data/ContributionsByFilerID"/>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
<property name="net.sf.jasperreports.export.xls.ignore.cell.background" value="true"/>
<property name="net.sf.jasperreports.export.xls.ignore.anchors" value="true"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.1" value="pageFooter"/>
I have tried <property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.2" value="columnHeader"/> but it changes nothing so I removed it.
The following is the container I use. I get multiple rows of just column headers. The code $outputformat in red below is either pdf or xlsx.
Container code:
var t = encodeURIComponent("u=PUBLIC2|expireTime=';
echo $expire;
echo '");
visualize({
auth: {
token: t,
preAuth: true,
tokenName: "tec-pp"
}
}, function (v) {
//render report from provided resource
var $button = $("#button");
var is_ready = false;
var export_pending = false;
var report = v.report({
resource: "';
echo $reportString;
echo '", container: "#container",';
echo $parmString;
echo ',
error: handleError,
success: onVisualizeReady
});
//show error
function handleError(err){
alert(err.message);
}
function onVisualizeReady(){
is_ready=true;
if (export_pending) {
alert("running pending")
doExport();
}
}
function doExport(){
report.export({ outputFormat: "';
echo $outputformat;
echo '" }).done(function (link) {
window.open(link.href); // open new window to download report
}).fail(function (err) {
alert(err.message);
});
}
$button.click(function () {
if (is_ready) {
doExport();
}
else {
alert("pending");
export_pending = true;
}
});