martin_48

Turns out it doesn't like static text being inter-mingled using text fields with fixed text works fine. just another example of the rough edges

Hi, I'm trying to display 3 text fields flowing downwards. Doesn't sound that hard, but studio is display massive gaps between the fields,whereas i want them to come one after the other with no gaps. eg 11111 11111 222 33333 But what i'm getting is like this 11111 11111 222 33333 Each text field is stretch with overflow, and float. I've played with stretch type, but it doesn't seem very useful I also have a table element below these elements. the band is free layout, split type null Thanks Martin

Hi I've got a report using a table with a sub data set. My simple test works, but when I move to something more complicated (main dataset sorted and filtered) I get an error like this... net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: ((net.sf.jasperreports.engine.data.JsonQLDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("attrs.*") at com.jaspersoft.studio.editor.preview.view.control.ReportController.fillReport(ReportController.java:550) at com.jaspersoft.studio.editor.preview.view.control.ReportController.access$18(ReportController.java:525) at com.jaspersoft.studio.editor.preview.view.control.ReportController$1.run(ReportController.java:443) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: ((net.sf.jasperreports.engine.data.JsonQLDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("attrs.*") at net.sf.jasperreports.engine.fill.JREvaluator.handleEvaluationException(JREvaluator.java:284) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:316) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:672) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:640) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:1169) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:522) at net.sf.jasperreports.components.table.fill.FillTableSubreport.evaluateSubreport(FillTableSubreport.java:105) at net.sf.jasperreports.components.table.fill.FillTable.evaluate(FillTable.java:133) at net.sf.jasperreports.engine.fill.JRFillComponentElement.evaluate(JRFillComponentElement.java:110) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:383) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:548) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2583) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:813) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:264) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:615) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135) at java.lang.Thread.run(Thread.java:748)Caused by: java.lang.ClassCastException: net.sf.jasperreports.engine.fill.SortedDataSource cannot be cast to net.sf.jasperreports.engine.data.JsonQLDataSource at findingIdCounts_1568296982745_524343.evaluate(findingIdCounts_1568296982745_524343:220) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:302) ... 16 more[/code]So this looks pretty bad to me. Tables and sub datasets work when the main dataset isn't sorted, but when its sorted if throws up. Is there a solution to this issue? I guess sort and filter up stream of jaspersoft.... Thanks Martin

Thanks for the response C-Box, Maybe features should be labelled according to their maturity level. :-) Save a lot of wasted time

HI, I'm trying to display some content (an html table ) in an html component. Unfortunately the text in the table cells does not wrap. instead, the text shrinks so it can display on one line. The HtmlComponent sample behaves this way too. I've tried <td style='word-wrap:break-word'>sfg sfg sdfg </td> without success. Does anyone know how to make it work correctly? My source data is json with some nesting. I'm not using report server. Just jaspersoft studio. Currently my boss sugests I ditch jaspersoft and render in plain html..... Thanks Martin

I am concluding filters with text strings are very buggy. I've resolved the initial issue by having an integer substitute for severity, which works as expected I have another situation filtering with string expressions, which again, doesn't work.However if i use the SEARCH function it does work. I am confident I am searching for the whole string, but == doesn't work, only SEARCH(...)>-1 This is basic stuff. Shame its not reliable

Seems to be some interaction with sort expression :-( Turn around and tap your head 3 times makes it work

My filter is AND($F{severity}=="High",$F{isFound}==false) but data preview includedes non-compliant values....

Did you find an answer? I am interested in this type of problem too

Jasper Reports Ultimate Guide 3rd edition (maybe out of date) states... " Subreports behave in the same way and expect to receive the same kind of input when they are being filled. You can supply to your subreport either a data source using the <dataSourceExpression> element or a JDBC connection for the engine to execute the subreport’s internal SQL query using the <connectionExpression> element. These two XML elements cannot both be present at the same time in a <subreport> element declaration. This is because you cannot supply both a data source and a connection for your subreport. You must decide on one of them and stick to it" Seems to imply the only data connection type that's supported is JDBC. What about XML, JSON, CSV etc?

Hi JasperSoft, Why are there so many inconsistencies between how different data connections/adapters/sources work? for example XML data source vs json data source... The examples included on install don't work the same for these data sources. the json data source customer orders subreport scenario seems to require the parameter passed from master to sub <subreportParameter name="net.sf.jasperreports.json.source"> <subreportParameterExpression><![CDATA["data/northwind.json"]]></subreportParameterExpression> </subreportParameter>[/code]however the xml example doesn't have this parameter, relying instead of the configuration in the subreport itself. This is fair enough, but if i remove the parameter from the json master report, it doesn't fall back on using the sub report datasource. Have i misunderstood something, or is this expected behaviour? Kind Regards Martin

Hi, I'm reporting from a json file data adaptor. I'm trying to get a subreport showing for each record of the main report. Right now, not even a dummy subreport (no data source, static text in title) shows up. How should i debug this? subreport: <?xml version="1.0" encoding="UTF-8"?><br><!-- Created with Jaspersoft Studio version 6.9.0.final using JasperReports Library version 6.9.0-cb8f9004be492ccc537180b49c026951f4220bf3 --><br><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="dummySub" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="116f64f0-93d4-41c2-ac28-61f0aa20cd96"><br> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/><br> <queryString><br> <![CDATA[]]><br> </queryString><br> <background><br> <band splitType="Stretch"/><br> </background><br> <summary><br> <band height="51" splitType="Stretch"><br> <staticText><br> <reportElement mode="Opaque" x="0" y="0" width="555" height="51" backcolor="#0EF052" uuid="a02d415b-50d4-4730-a914-018da7540177"/><br> <text><![CDATA[static Text]]></text><br> </staticText><br> </band><br> </summary><br></jasperReport><br>[/code]main report: <?xml version="1.0" encoding="UTF-8"?><br><!-- Created with Jaspersoft Studio version 6.9.0.final using JasperReports Library version 6.9.0-cb8f9004be492ccc537180b49c026951f4220bf3 --><br><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Servers" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="af215306-8336-4607-a62d-5fa963dc2e6c"><br> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="instancesSummary"/><br> <property name="com.jaspersoft.studio.unit." value="mm"/><br> <property name="com.jaspersoft.studio.unit.pageHeight" value="mm"/><br> <property name="com.jaspersoft.studio.unit.pageWidth" value="mm"/><br> <property name="com.jaspersoft.studio.unit.topMargin" value="mm"/><br> <property name="com.jaspersoft.studio.unit.bottomMargin" value="mm"/><br> <property name="com.jaspersoft.studio.unit.leftMargin" value="mm"/><br> <property name="com.jaspersoft.studio.unit.rightMargin" value="mm"/><br> <property name="com.jaspersoft.studio.unit.columnWidth" value="mm"/><br> <property name="com.jaspersoft.studio.unit.columnSpacing" value="mm"/><br> <queryString language="jsonql"><br> <![CDATA[findingsCountByServer]]><br> </queryString><br> <background><br> <band splitType="Stretch"/><br> </background><br> <title><br> <band height="126"><br> <subreport isUsingCache="false"><br> <reportElement x="50" y="17" width="530" height="98" uuid="bd501738-6599-46fb-b627-30619cadf27f"><br> <printWhenExpression><![CDATA[true]]></printWhenExpression><br> </reportElement><br> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><br> <subreportExpression><![CDATA["dummySub.jasper"]]></subreportExpression><br> </subreport><br> </band><br> </title><br></jasperReport>[/code] Thanks Martin