Jump to content

Jasperserver Excel Output file


jasper-2013

Recommended Posts

  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Hi,

I suppose the version of the ireport is 4.5 and above because in these versions only changing the name of the sheets is possible.

This could be done easily following the steps:

1. Locate the Property pane for the report 

2. Then locate the Properties 

3. Then if you click on the properties then a pane will open and it will have an option to add click on it.

4. Then a pane will open which will ask the name and value of the property

5. The name of the property will be ' net.sf.jasperreports.export.xls.sheet.names.{arbitrary_name}'

6. In the value you need to add the desired names of the sheet(s) seperated with '/' .For instance 'Report page1/Report page2/Report page3'

You are ready now export the report as xls and you can see the desired names of the sheet . 

 

Hope that it helps

Regards.

Ankur Gupta

Link to comment
Share on other sites

Hi,

Actually I used the iReport 5.0.1 to develop the report and test the above way to generate the custom names for the sheets.

I can't comment for adhoc reports , but as far as I know adhoc reports have some limitations as it is targeted for creation of basic reports where in the possibility of cutomizations are less. As it gives a pretty simple flow of creating reports with basic settings, so possibly it would not support the customization of the sheet names in the excel export. But see I am not sure , so please check the same  and let me also know if you get to do this with adhoc Reports.

 

Well the above steps , work fine with the iReport , if you use that

 

Hope that it helps.

Thanks, 

Ankur Gupta

Link to comment
Share on other sites

Hi,

I also faced same problem earlier in  iReport based, ( not in Adhoc report).

 So to change the sheet name i just change the name of report in iReport. 

Go to report properties and change report name, whatever name you mention thier appear as sheet name when report export to excel from jasperserver.

To export adhoc view and adhoc report in excel with proper sheet name you should provide proper naming to your view ,report and other components which may be helpful.

Regards,

Ajinkya

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...