jogrey

I found the solution : net.sf.jasperreports.export.xls.exclude.origin.band.title=title net.sf.jasperreports.export.xls.exclude.origin.band.pageHeader=pageHeader net.sf.jasperreports.export.xls.exclude.origin.band.columnHeader=columnHeader net.sf.jasperreports.export.xls.exclude.origin.band.columnFooter=columnFooter net.sf.jasperreports.export.xls.exclude.origin.band.pageFooter=pageFooter net.sf.jasperreports.export.xls.exclude.origin.band.lastPageFooter=lastPageFooter #### the solution ##### net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.Product=Product net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.Product=groupHeader net.sf.jasperreports.export.xls.exclude.origin.keep.first.group.Product=Product net.sf.jasperreports.export.xls.exclude.origin.band.Product=Product net.sf.jasperreports.export.xls.exclude.origin.band.Product=groupHeader net.sf.jasperreports.export.xls.exclude.origin.group.Product=Product

I have a quite similar problem, if i succeed correctly to remove from export page titles, and column headers, i'am not able to do the same with a group band. I tried this with success : net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter And this without success (Product is the name of the group): net.sf.jasperreports.export.xls.exclude.origin.band.3=columnHeader net.sf.jasperreports.export.xls.exclude.origin.band.4=groupHeader net.sf.jasperreports.export.xls.exclude.origin.group.5=columnHeader net.sf.jasperreports.export.xls.exclude.origin.group.6=groupHeader net.sf.jasperreports.export.xls.exclude.origin.band.7=Product net.sf.jasperreports.export.xls.exclude.origin.group.8=Product Column headers are always exported, is there something special for groups ? Thank you. Post Edited by jogrey at 10/13/2010 10:03

Doing this modification, we directly render the page : <action-state id="setPdfOutput"> <set name="flowScope.reportOutput" value="'pdf'"/> <transition to="checkForParams"/> </action-state> But we cannot choose anymore the export we want to do ! As it opens the exported result in the same windows than the jasperserver page, overriding this last one (the user has to click on the back button of the browser to go back to JS). Is anyone of you succeed to change the default render mode of a report without loosing the "export tool bar" ? I really want to avoid the ugly html rendered pages. Thank you :)

The code seems to be ok, but, it opens the pdf on the same page, and not in the rendered page as html. Could we, at least if it is not possible, open the pdf in a new page ? Thank you anyway ! Post Edited by jogrey at 06/23/2010 14:00

Is anyone using 3.7 succeed to generate pdf directly ?

Ok, it should be the same in the CE JdbcDaoImpl seems to have an issue with my version too. So, how do you succeed to peform this operation ? Thank you :)

Thank you for the link, but with the 3.7CE it seems to be not comptatible, I can't get it working, certainly the xml changed since the version used in the link you gave me.

Could we use the jdbcDaoImpl with JS CE 3.7.0 ?

Anyone of you tried to do such "pdf visualizator" ?

What about passing images as ressources to your report from JS and use repo:RESSOURCE_NAME as image location in your jrxml ?

So JdbcDaoImpl will not work neither with JS CE 3.7.0 ? We must implement Jaas classes ?

Hi, i have a problem, i must use some specifics jrxml, with a lot of rectangles inside, and as we know the JRHtmlExporter got troubles with them so i tried to : Avoid the html render in copying DefaultJasperViewer.jsp into a new one, commenting //exporter.exportReport(); to mask the ugly rendered page, this point is ok. But i don't know how to directly display the pdf, or flash output into an iframe for instance, or at least into a new page. How to directly call the pdf generator instead of the html one, is there an option for that ? Thank you :)

After deeper checks, the solution is really axed on a simple new dimension and not on complicated functions with attractives and seducing names :) Thank you again Mr S.

I tried to add a dimension, with one level and unique name, on the same data than i want to "group by", it seems to work, is the good way to do ? I have this kind of mdx query : WITH MEMBER [Measures].[groupby] AS Power( 10, Sum( [DimPds].[pds].members, log10( [Measures].[FPY_TOT] ) ) ) SELECT [temps].members ON COLUMNS, [Etablissement].members ON ROWS FROM [EvolutionFPY] WHERE [Measures].[groupby] Post Edited by jogrey at 02/23/2010 13:08

Maybe this should be done in the mdx statement only ? I found some aggregates functions, but i don't know if it fits my requierments. Thx.