uhurusurfa

Not sure what your issue was/is but possibly it is the empty string for the attribute ..... we do not have a "fontName" attribute in any of our files - not even with the empty string. This allows the reports to render the default font defined in jasperreports.properties and we can change the font on the fly at render time per report. these files worked in 3.6.0, 3.7.2, 4.0.2 and 4.1.1

Most likely your data contains the value of 0 for the points that are displayed. If the value came out as NULL then it would not display the line chart data points where there is a null value.

Do not think it is possible. Look in JRStyledTextParser.java and search for "u2022". The code simply finds all <li> tags and replaces them wtih the bullet character (\u2022) and all </li> with a newline character (\n). The markup tags are discarded.

Thanks for the feedback but it does not solve our problem.

We have experienced the same issue. However, it appears to be an issue with at least the 3.7.* release. We have been running 3.0.0 on OpenJDK and it works fine when generating PDFs. However when generating the IDENTICAL JRXML in 3.7.3 or 3.7.4 the text in charts does not appear. NOTE:: - this is run on the same machine with the same JRXML and OpenJDK but a different Jasper version. - exporting the same report as HTML or any other format works fine - the chart labels are visible Since it works in 3.0.0 the assumption is that either the way JFree is instantiated from Jasper has changed or some configuration setting that passed information to JFree about where to find the fonts to use has changed. We are busy trying to debug this but if anyone has any idea how the font location is passed to JFree it would be appreicated. Post Edited by uhurusurfa at 08/05/2010 13:09

3.7.3 fixed the problem for us.

Does anyone know if there were significant changes to the way crosstabs should be configured between 3.6.* and 3.7.*? All our crosstab reports work perfectly on 3.6.* but when trying to run the exact same crosstab report using 3.7.* they randomly render only a small portion of the data and the ordering is messed up if it does render it. Note that we took the jrxml file and opened it in ireports 3.7.1 and the problem is the same as using the 3.6.* compiled version ... it does not render correctly at all and this is for every single crosstab that correctly runs in 3.6.*. This may be related to the fact that in 3.7.* it seems to ignore the "Data Is Presorted" flag and attempts to order the data anyway.

Is there way to set the font size for the value printed above each bar when "Show Label" is checked?

Does anyone know if there were significant changes to the way crosstabs should be configured between 3.6.* and 3.7.*? All our crosstab reports work perfectly on 3.6.* but when trying to run the exact same crosstab report using 3.7.* they randomly render only a small portion of the data and the ordering is messed up if it does render it. Note that we took the jrxml file and opened it in ireports 3.7.1 and the problem is the same as using the 3.6.* compiled version ... it does not render correctly at all and this is for every single crosstab that correctly runs in 3.6.*. This may be related to the fact that in 3.7.* it seems to ignore the "Data Is Presorted" flag and attempts to order the data anyway. Post Edited by uhurusurfa at 04/09/2010 10:55 Post Edited by uhurusurfa at 04/09/2010 13:50

The problem was not in Jasper. check that you have all readers and writers instantiated on both HTTP connection and DB connection set to UTF-8. Dont assume the reader or writer is UTF-8 for tomcat sepcifically: 1. Set the property URIEncoding=UTF-8 in the config 2. Set the response writer using : resp.setContentType( "text/html; charset=UTF-8" ); Verifying that you are definitely seeing UTF-8 characters can be a trying exercise as there are automatic conversions that take place base on LOCAL settings that you are not aware of and will fool you into thinking you are seeing UTF-8 when in fact it is Latin1 or some other character set.

Jasper supports a limited set of styled text tags. Set the "Is styled Text" attribute on the field. Tags supported <br/>, <li>, <b>, <u>, <i> <font> plus a few others.

Create a sub report as if it is a main report that has a query and lay out your data as if it is a self standing report but do not include page headers and footers (these will be done in the main report). For each different query you create a separate file and lay out the data. As long as the sub reports are referenced from a group band in the main report (create three groups with no "Group Expression" set), you can set the main report to always call the sub reports and does not need a query in the main report -> in "Report Properties" select the "More..." tab and for the field "When no data" select "All pages no detail" You must pass a report connection to the sub reports though so in the sub report report properties you must set the connection parameter.

Check the height of your fields. They must be at least one pixel bigger than the font size although 2 pixels will guarantee it renders. It depends on the font you choose exactly how much space is needed. Also make sure you set the "Stretch with overflow" attribute on the text field or make the field big enough to hold the data. NOTE: even though you see the text fitting in the text field in the designer, the text might be one pixel too big to fit and then it will not render it.

Suggest you create a subreport per product sized appropriately with the table layed out in the sub report. If you name the sub report file correctly you can dynamically link in the sub report with the product into your main report. Use a sub report file name that includes the product name (say there were products fishing_rod, bicycle, etclike fishing_rod_1_table.jrxml then include the sub report in the main report using a report definition like : $P{SUB_REPORT_PATH} + $F{productName} + "_table.jasper NOTE: This assumes your product name is retrieved from an SQL statement in the main report but this might give you the starting point. You could equally add other fields into the name of the file to uniquely identify the products "table" sub report such as product code etc.

The "isStyledText" option supports limited embedded formatting. Bold, underline, italics, text size and colour, strikethru and I think subscript and superscript.

Depends if your sub report has a query or not. ~Since it only renders static text it probably does not and therefore setting the report "Blank when no data" or any of the other options will not help you since this will either never render anything or always render something. So you need to control the calling of the sub report from the main report using a "printwhen" expression if it is conditional on data in the top level report.

Jasper does not support multiple queries in one report file - you use sub reports for that. Sub datasets are only for crosstab reports and charts. First: 1. Create a sub report for each of the three queries and the layout in the appropriate bands for the query data. Next: 1. Create three separate groups in the main report. 2. Add a sub report to each group header band pointing at the sub reports you created in first part. NOTE: You could have one query in the main report with the layout for that queries data in the main report and add only 2 sub reports for the other queries by creating 2 groups instead of three. Don't use default bands (Column header/footer, page header/footer summary) for sub reports as there is less control over the sub report layout from the top level that way.

Any non standard character that is retrieved from a database (anything with accent/umlaut etc) is not printing correctly or causes complete failure to print of the text field it renders in (although not sure what the exact combination is that causes the failure to print the field versus printing incorrect characters). We are using mySql as DB backend with JDBC connection for our data source. The problem exists using 2.01, 2.00, 1.3.4, 1.3.3 and 1.3.2 (have not tested on earlier versions but assume same holds). I have lost count of the number of reports in the forums I have come across with identical problem but none seem to have a solution or if there is everyone is keeping very quiet about it. Have checked: 1. UTF-8 set as default encoding in XML report definition header and in encoding property. 2. DB encoding - set to UTF-8 at all levels including forcing UTF-8 encoding on any connection irrespective of request params 3. JDBC connection string - added "charSet=UTF-8&useUnicode=true&characterEncoding=UTF-8" to ensure no problems there but still no joy 4. Verified that pasting static text with same accented characters into text field that renders the text from the DB. The static text renders correctly but DB text does not so text field config cannot be the problem since I also edited XML file and verified detected encoding is UTF-8. The characters render correctly in a web browser using our application and the JDBC connection is identical to the one used for Jasper, the HTTP data stream is UTF-8 encoded and the HTML page header specifies UTF-8 encoding so we are certain that it is not a DB issue. Using the iReports build option "Text Preview (iReports)" the text is correct in the output file and editing the file confirms that UTF-8 encoding is detected but using HTML, PDF, ODF or the "JRViewer Preview" options does not. If anyone has the key to this seemingly extensively reported problem it would be very much appreciated. Post edited by: uhurusurfa, at: 2007/10/01 12:03 Post edited by: uhurusurfa, at: 2007/10/01 12:47 Post edited by: uhurusurfa, at: 2007/10/01 12:47

There is a simple example of all report types in the Jasper reports "project" download. NOTE: Time series chart did not work in 1.2.5

Try version 1.2.8. Did not work at all for me in 1.2.5 and upgraded to 1.2.8... Worked fine.

Try version 1.2.8. Did not work at all for me in 1.2.5 and upgraded to 1.2.8... Worked fine.