baggypants

Was it made configurable then?

Clearly you're bonkers. Why bother with an excellent xhtml layout engine if your going to ignore it? It's not even in viewReportBeans.xml as an optional exporter. Is it in the Pro edition? Can I buy my way to better web reports? If anyone feels inclined they can vote for the bug I filed two months ago here http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4433 Otherwise an impressive piece of software. Well Done.

select *, company.co_name from contactmst, company where contactmst.co_id=company.co_id and contactmst.co_id=$P{co_id} and $P!{OrderByClause}='t' Where $P!{OrderByClause} can be 'is_customer' or 'is_supplier' selected by what ever report generation system you use.

Yes. That's how the html renderer works. versions since about 3.6 have an XHTML renderer which supports overlapping elements.

It's not really wrong, the java default minimum number of days in the first week of a year is 1, so the 1st and 2nd (and maybe 3rd depending on your locale) would be in week 1. Weeks start on either Sunday or Monday do the 4th would be in week 2. Post Edited by baggypants at 01/08/2010 09:30

On my crosstabs I generate a simple number column in the SQL for sorting, admittedly it uses a goodly number of case statements, then use it as a hidden row/column group in the crosstab. Post Edited by baggypants at 01/05/2010 10:09

The default view of the new repository view has a filter in place to filter out those sorts of things. Even if you click on the specified folders. If you select the drop down boxes in the bottom left of tyhe view to "show all" then you should be able to see them. I've also noticed that you can duplicate folders in a 3.5 import as 3.7 has different resource names but the same visible name so check your looking in the correct folders.

I'd do it in the SQL using COALESCE or some other equivalent (NVL for Oracle) Also I don't think java can use != try new Integer($V{month_COUNT}.equals(null) ? 0 : $V{month_COUNT} ). Post Edited by baggypants at 12/09/2009 16:30

I believe this is because excel isn't as flexable as Jasper as regarding cell colour. Have a look here http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/faq.html?group_id=252#FAQ10

You seem to be trying to set the heap for an app called HelloWorld that dosn't exist. Have you tried somthing like this? How to set java heap size in Tomcat? Stop Tomcat server, set environment variable CATALINA_OPTS, and then restart Tomcat. Look at the file tomcat-install/bin/catalina.sh or catalina.bat for how this variable is used. For example, set CATALINA_OPTS=-Xms512m -Xmx512m (Windows, no "" around the value) export CATALINA_OPTS="-Xms512m -Xmx512m" (ksh/bash, "" around the value) setenv CATALINA_OPTS "-Xms512m -Xmx512m" (tcsh/csh, "" around the value) In catalina.bat or catallina.sh, you may have noticed CATALINA_OPTS, JAVA_OPTS, or both can be used to specify Tomcat JVM options. What is the difference between CATALINA_OPTS and JAVA_OPTS? The name CATALINA_OPTS is specific for Tomcat servlet container, whereas JAVA_OPTS may be used by other java applications (e.g., JBoss). Since environment variables are shared by all applications, we don't want Tomcat to inadvertently pick up the JVM options intended for other apps. I prefer to use CATALINA_OPTS. if your running on windows then there is a setenv.bat in the apache-topcat\bin folder.

I have a report that looks at the users second role in their role list and filters accordingly. For all the users I've managed to create the user, assign them ROLE_USER as the first role in the list and the role Shop_(number 1 - 20) as the second one. Apart from Shop_4 which insists on being the first role in the list for some reason. Obviously My assumption that roles are in the order they are added is wrong, so I either need to find a way of forcing the role order, or searching roles in the report to find a match. Attached is an example of a report that filters by ROLE.

Theres a jolly good post in the subject here: http://mdahlman.wordpress.com/2009/09/09/jasperreports-first-dates/

You would be better served by posting in the JasperServer dedicated forum http://jasperforge.org/plugins/espforum/browse.php?group_id=112&forumid=102

when I get this I find it helps to bung an ORDER BY clause on the SQL

Well, the general approach of Jasper as I understand it, is this. Jasper Reports are a Java reporting Engine, a jar file. You can use this engine to builld your own java based reporting programs iReport is a report designer for Jasper Reports, you design your report and save it in either a precompiled .jasper file to use in your program or a jrxml if your program is compiling them itself JasperServer is a Business Intelegence platorm that uses Jasper Reports built on the Web application server Tomcat. An example or reference of what can be done with the engine. There is a Jasper Report Viewer somewere around, a Java based report viewing program. But I don't know how up-to-date it is.

"It looks to me like not everyone will want the XHTML exporter to be used by default." Well, you always get your lunatic fringe I suppose. Frankly the new XHTML renderer looks great when I've tried it in iReport, I can't think of any situation where I wilfully want report elements to be hidden under other ones. An option to use it as the default HTML output would be much appreciated. Having it as a download option seems redundant as there are far nicer download options such as pdf. Also, what would happen to the pagination of a download HTML output?

Mozilla Firefox 3.5.5 and I.E. 8.0.6001.18702 Is there a demo site so I could check if its my install?

British

Yes Crosstabs can do this. However in iReport by default they stack multiple measures in the column so you would have to have Bucket <Num> down the left and Bucket <Letter> accross the top. See Attached pdf for one I've done. Post Edited by baggypants at 10/21/2009 09:23

See if you can find a thread on Cascading input controls.

Your looking for something like Sybase JDBC driver for whatever version of the Db your using. In ireport, got to Tools>Options>iReport>Classpath tab click on Add Jar and choose the jar In the toolbar click on Report Datasources > New > Database JDBC Connection, > fill in the relevent data in the Wizard Box

If your using 9i or 10g there should be an ojdbc14.jar in your oracle dir somewhere, otherwise yes.

On their TODO http://jasperforge.org/projects/ireport/tracker/view.php?id=4238

apache-tomcat/webapps/jasperserver/WEB-INF/bundle/jasperserver_config.properties Post Edited by baggypants at 10/12/2009 08:35 Post Edited by baggypants at 10/12/2009 08:36

Have a look at this thread http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=31306