glassner Posted June 7, 2010 Share Posted June 7, 2010 Does anyone know how to generate Excel formula dynamically when using a crosstab ?This post is very helpful in decribing how to generate Execl formulas dynamically http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=74214in the post above, we set the following property:net.sf.jasperreports.export.xls.formula"=SUM(B2:B"+($V{REPORT_COUNT}.intValue()+1)+")"But in the context of a crosstab, does anyone know how to refer to the number of records in a group, or the number of columns in a group ? How does one replace "B2" with something that indicated the first column, the first row ...Or dynamic Excel formulas and crosstabs do not mix ? Link to comment Share on other sites More sharing options...
glassner Posted June 10, 2010 Author Share Posted June 10, 2010 Any pointers on this issue ? Link to comment Share on other sites More sharing options...
glassner Posted June 25, 2010 Author Share Posted June 25, 2010 Still nobody on this ? Could it be I am the only one with this problem ? Please if you know how, let me know.I cannot find anything on this topic in the forum and there is no documentation available Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted June 25, 2010 Share Posted June 25, 2010 you should try asking to the JasperReports forum Giulio Link to comment Share on other sites More sharing options...
glassner Posted June 25, 2010 Author Share Posted June 25, 2010 Thank you, Giulio.So, there is not a way of doing it in iReport ? Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted June 25, 2010 Share Posted June 25, 2010 If you can do it with jasperreports, you will do it in iReport, I'm just not sure how to do it from a jasper prospective, meaning I don't think there is a variable which gives you the number of columns or group.I'm sure Teodor or Lucian in the JasperReports forum can answer your question Giulio Link to comment Share on other sites More sharing options...
glassner Posted June 25, 2010 Author Share Posted June 25, 2010 Molte grazie, Giulio !I will certainly post something here if I get an answer that could help others. Grazia 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