honeyani Posted September 22, 2008 Share Posted September 22, 2008 Hi All,Through iReport is it possible to set header for the excel sheet properties,Ican set header for a page and header for each page through iReport.My query : Throguh iReport i should be able to set single header for the generated excel file(this is done),but when i give for print header for each page should be set ,i mean to say header for each page will happen if we set it in Excel sheet page set up properties .is it possible to set anything like that ( Excel sheet page set up properties)through iReport tool? Link to comment Share on other sites More sharing options...
honeyani Posted September 22, 2008 Author Share Posted September 22, 2008 Hi All,As far as i have investigated in the available tutorialsiReport tool supports only below 3 ways to set header: <title> - will appear once at top of report (which we have used on our report). <page Header> -will appear at top of every page. <columnHeader> - if there exists more than 2 column value on our report, this can be set for each column. Is it possible to set cutom property for header (to set page set up property of excel sheet) using iReport tool? Link to comment Share on other sites More sharing options...
honeyani Posted September 23, 2008 Author Share Posted September 23, 2008 honeyaniWrote: Hi All, As far as i have investigated in the available tutorials iReport tool supports only below 3 ways to set header: <title> - will appear once at top of report (which we have used on our report). <page Header> -will appear at top of every page. <columnHeader> - if there exists more than 2 column value on our report, this can be set for each column. Is it possible to set cutom property for header (to set page set up property of excel sheet) using iReport tool? Hi Friends,I fixed this using an external Java API Apache's POI-HSSF API ,which helps us to set header and footer for each page that too during print section alone... :)Hope this mght help u too..!! Thx,Ani Link to comment Share on other sites More sharing options...
honeyani Posted September 23, 2008 Author Share Posted September 23, 2008 honeyaniWrote: honeyani Wrote: Hi All, As far as i have investigated in the available tutorials iReport tool supports only below 3 ways to set header: <title> - will appear once at top of report (which we have used on our report). <page Header> -will appear at top of every page. <columnHeader> - if there exists more than 2 column value on our report, this can be set for each column. Is it possible to set cutom property for header (to set page set up property of excel sheet) using iReport tool? Hi Friends, I fixed this using an external Java API Apache's POI-HSSF API ,which helps us to set header and footer for each page that too during print section alone... :) Hope this mght help u too..!! Thx, Ani Eventhough have fixed it using some external API , I need a confirmation on its possiblity or impossiblility using iReport tool .Can anyone plz confirm us on thiz???????(it will save our time on more investigation with the tool)... Link to comment Share on other sites More sharing options...
Teodor Danciu Posted September 23, 2008 Share Posted September 23, 2008 Hi,I don't think we fully understood what headers you are talking about.Is it about suppressing the page header section of the report on subsequent pages, when exporting to XLS?If it is about that, then note that you can filter out content from a report when exporting to XLS based on element origin, using exporter hints such as those explained in this FAQ here:http://jasperforge.org/uploads/publish/jasperreportswebsite/JR%20Website/jasperreports_faq.html#How%20can%20I%20suppress%20page%20headers%20and%20footers%20when%20exporting%20to%20XLS?I hope this helps.Teodor Link to comment Share on other sites More sharing options...
honeyani Posted September 24, 2008 Author Share Posted September 24, 2008 teodordWrote: Hi, I don't think we fully understood what headers you are talking about. Is it about suppressing the page header section of the report on subsequent pages, when exporting to XLS? If it is about that, then note that you can filter out content from a report when exporting to XLS based on element origin, using exporter hints such as those explained in this FAQ here: http://jasperforge.org/uploads/publish/jasperreportswebsite/JR%20Website/jasperreports_faq.html#How%20can%20I%20suppress%20page%20headers%20and%20footers%20when%20exporting%20to%20XLS? I hope this helps. Teodor Hi Teodor, Thanks for your reply! I didn't mean supression of header .If i want the header to appear once on the document hope, i can use title tag in iReport.But my requirement is,on jasper report generated Excel i should be able to see the header only once,if i go and view the Page set up property of Excel sheet i should be able to find my custom header set here,so that the header will be set during print on each page alone.If we set header/footer using POI API ,it sets on header/footer property of the Excel sheet and it gets printed on each page when we give for print.In the same manner do we have anyways to set our custom properties for excel sheet using iReport tool...Waiting for your reply or confirmation at the earliest..Thanks,Anitha Link to comment Share on other sites More sharing options...
holla Posted May 10, 2012 Share Posted May 10, 2012 Did you find a soulution? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now