Excel with jasper

Classic Servoy
1

Hello

I pass a foundset for my form to jasper (IReport 3.7.1) and want to get an excel file.
Here my code:

var vj = globals.g_heute.getFullYear().toString();
var vscheisse = globals.g_heute.getMonth() + 1;
var vm = vscheisse.toString();
var vd =globals.g_heute.getDate().toString();
var vdstring = vj+"_"+vm+"_"+vd
var vfilename = globals.GKP_Projekt+"_Kontakte_"+vdstring+".xls";
var bytes = plugins.jasperPluginRMI.runReport(forms.Auswahl_Kontakte.foundset, "Export_Kontakte.jasper", vfilename , OUTPUT_FORMAT.EXCEL, new Object());
plugins.file.writeFile(vfilename,bytes,"application/xls");

Everything is working, but in the resulting excel file the columnheaders are missing???
See attched files (excel result and IReport definition)
[attachment=1]screenshot2.jpg[/attachment]
[attachment=0]screenshot3.jpg[/attachment]

I tried to put the column headers( just labels) in different IReport aeras (page header,title,column header)
No success, allways the same result in excel?
What do i miss?
Regards
Albert

screenshot3.jpg
screenshot3.jpg948×156 36.8 KB

screenshot2.jpg
screenshot2.jpg1590×241 59.3 KB

2

Have you tried with other reports to export to excel?
Presumably if you do not use a foundset you get same results?
What is the band height & print when expression for the header?
Does the internal iReport preview (or change to OUTPUT.VIEW) look ok or is it missing the header as well?.
What version of the plugin are you using?

3

Hello Thomas

When defining a report in IReport with a SQL Statement and then calling it from Servoy (database instead of foundset) everything is OK.
Regards
Albert

4

Hello Everybody
I found the Problem.
I need a ‘print repeated values’ for the labels!!!
Sorry for wasting your time.
Best regards
Albert