hal_1

I have multiple parameter-dependent parameters in my report that is executed through the rest API. When I select the first parameter, none of the data for the second and third parameters change. Is there an option that has to be set to have the data to refresh when parameters change? If that is the case, is that done when the report is requested or in the actual report created with Jasper Studio? Please point me to the directions on how to make this work properly? Thanks for any help you can provide. Hal

I am surprised I haven't heard from anyone concerning this issue. Am I the only one using cascading parameters in an embedded report or am I the only one with this issue? I could use some help.

I believe jasper refers to this as cascading parameters. Are you running your reports from Jasper Server or have you integrated your reports to be executed from a web-based application? I have found that cascading parameters work great when executing reports directly from Jasper Server but not when the reports are executed from within an application. Also, I use the community edition of Jasper Server, so that may make a difference. The second parameter query will need to have the first parameter included in the query after it is selected to narrow down the list for the 2nd parameter.

How does this work if you are embedding reports in your web application using Res API? The 2nd parameter input doesn't recognize different selections for the first input.

I have reports using cascading input controls where the parameters are dependent on what is selected for previous parameters. This works great when I run the report directly through jasper server. When I run the report through the web app that the report is embedded, it appears the default values of the parameters are used instead of the newly selected parameters. Is there a way to refresh the parameters so it uses the new value selected when selecting a parameter that depends on a previous parameter entered? I'm using the community edition.

Here is the error message: Caused by: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: calculator_Aggregate32Response32Report_1524483576138_349733: 350: class org.codehaus.groovy.ast.expr.CastExpression, with its value '(java.lang.String) field_record_type.getValue()', is a bad expression as the left hand side of an assignment operator at line: 350 column: 71. File: calculator_Aggregate32Response32Report_1524483576138_349733 @ line 350, column 71. 1 error at org.codehaus.groovy.control.ErrorCollector.failIfErrors(ErrorCollector.java:310) at org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:946) at org.codehaus.groovy.control.CompilationUnit.doPhaseOperation(CompilationUnit.java:593) at org.codehaus.groovy.control.CompilationUnit.processPhaseOperations(CompilationUnit.java:569) at org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:546) at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:102) ... 6 more Thanks, Hal

I created a small report to demonstrate how I understand the java.collection to work. The parameters term_select and SelectForm_Status should both work finding any item the user selects and if they don't enter anything for the parameter, all records are returned. If I don't enter a valid option for the java.collection parameters, I don't find any records. Here's the code: <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1 --> <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="Blank_Letter_Landscape" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1d7a2027-5a37-43de-a7c1-713306fb74e0"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="xxxxxxx"/> <property name="ireport.jasperserver.url" value="http://xx.xx.xx.xx:8080/jasperserver/"/> <property name="ireport.jasperserver.user" value="xxx"/> <property name="ireport.jasperserver.reportUnit" value="/Time2Track/Administrators/Blank_Letter_Landscape"/> <property name="ireport.jasperserver.report.resource" value="/Time2Track/Administrators/Blank_Letter_Landscape_files/main_jrxml"/> <parameter name="school_id" class="java.lang.String"/> <parameter name="Select_Form" class="java.lang.String"/> <parameter name="Select_Form_Status" class="java.util.Collection" nestedType="java.lang.String" evaluationTime="Early"> <defaultValueExpression><![CDATA[new ArrayList(Arrays.asList())]]></defaultValueExpression> </parameter> <parameter name="term_select" class="java.util.Collection" nestedType="java.lang.String" evaluationTime="Early"> <defaultValueExpression><![CDATA[new ArrayList(Arrays.asList())]]></defaultValueExpression> </parameter> <parameter name="submission_start_date" class="java.util.Date"/> <parameter name="submission_end_date" class="java.util.Date"/> <queryString language="SQL"> <![CDATA[-- value_counts subquery select -- form_submission_items.`form_item_id` as form_item_id, -- case when $Xx{IN,null,term_select} then 1 else 0 end as term_null, "" as term_null, form_submission_items.value as value, case when form_submission_items.value like "%|%" then form_submission_items.value_label else form_item_values.label end as value_label, form_submission_items.value_label as label, count(distinct (case when form_submission_items.value in ("N/A","N/R","N/O") then null else form_submission_items.id end)) as value_count from form_submission_items left join form_submission_sections on form_submission_items.`form_submission_section_id` = form_submission_sections.id left join form_submissions on form_submission_sections.`form_submission_id` = form_submissions.id left join practicums on practicums.id = form_submissions.practicum_id left join form_item_values on form_submission_items.`form_item_id` = form_item_values.`form_item_id` and form_submission_items.value = form_item_values.value left join forms on form_submissions.form_id = forms.id where forms.school_id = $P{school_id} and forms.id = $P{Select_Form} and ($X{IN,null,Select_Form_Status} or $X{IN, form_submissions.status, Select_Form_Status}) >>>>> This is where I'm having a problem and ($X{IN,null,term_select} or $X{IN, practicums.term_id,term_select}) >>>>> This is where I'm having a problem I want to find all records if nothing is entered for term_select -- and (case when $Xx{IN,null,term_select} then 1 else 0 end = 0 or $Xx{IN, practicums.term_id, term_select}) and ($P{submission_start_date} is null or date(form_submissions.requested_at) between $P{submission_start_date} and $P{submission_end_date}) and form_submission_items.`input_type` in ("radio", "checkbox","select","text_area") group by form_item_id,value order by form_item_id,value]]> </queryString> <field name="form_item_id" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="form_item_id"/> <property name="com.jaspersoft.studio.field.tree.path" value="form_submission_items"/> </field> <field name="term_null" class="java.lang.String"/> <field name="value" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="value"/> <property name="com.jaspersoft.studio.field.tree.path" value="form_submission_items"/> </field> <field name="value_label" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="value_label"/> </field> <field name="label" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="label"/> <property name="com.jaspersoft.studio.field.tree.path" value="form_submission_items"/> </field> <field name="value_count" class="java.lang.Long"> <property name="com.jaspersoft.studio.field.label" value="value_count"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band splitType="Stretch"/> </title> <pageHeader> <band height="11" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="152" height="15" uuid="b1cc853b-3667-444c-a331-3906097e574b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="11ee2ebd-abb3-40b6-b273-5a217c08af82"/> </reportElement> <text><![CDATA[form_item_id]]></text> </staticText> <staticText> <reportElement x="152" y="0" width="150" height="15" uuid="a8bab78a-1f92-440f-9a92-edd5bfeaf88a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="def49dd4-2c7c-4c2a-8345-9250be174ffc"/> </reportElement> <text><![CDATA[value]]></text> </staticText> <staticText> <reportElement x="302" y="0" width="150" height="15" uuid="8d7e6058-5abc-49a3-8443-267ca11da29e"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="dc96bfc9-4581-496b-ba04-87f7650f71d1"/> </reportElement> <text><![CDATA[value_label]]></text> </staticText> <staticText> <reportElement x="452" y="0" width="150" height="15" uuid="20eb8f99-e07d-450c-ad81-a690d13bc9d6"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7ea9a36c-8ad2-4b3d-a768-a5a766220bc2"/> </reportElement> <text><![CDATA[label]]></text> </staticText> <staticText> <reportElement x="602" y="0" width="150" height="15" uuid="f847718d-7450-42f6-9a35-e8fdc36dbbfa"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="af80e1f4-8c05-47e9-bb32-3ea29bfd3e86"/> </reportElement> <text><![CDATA[value_count]]></text> </staticText> </band> </columnHeader> <detail> <band height="20" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="152" height="15" uuid="0ce4bcdb-83cf-44f3-a3be-796974c7699b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="11ee2ebd-abb3-40b6-b273-5a217c08af82"/> </reportElement> <textFieldExpression><![CDATA[$F{form_item_id}]]></textFieldExpression> </textField> <textField> <reportElement x="152" y="0" width="150" height="15" uuid="0f4f5d5f-a7e3-437a-bc33-063b58a5fafe"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="def49dd4-2c7c-4c2a-8345-9250be174ffc"/> </reportElement> <textFieldExpression><![CDATA[$F{value}]]></textFieldExpression> </textField> <textField> <reportElement x="302" y="0" width="150" height="15" uuid="af03504d-00f2-47b2-af1a-80d00c9517bb"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="dc96bfc9-4581-496b-ba04-87f7650f71d1"/> </reportElement> <textFieldExpression><![CDATA[$F{value_label}]]></textFieldExpression> </textField> <textField> <reportElement x="452" y="0" width="150" height="15" uuid="4b788aa1-cc8f-4d76-8ff3-85cf76ce756f"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7ea9a36c-8ad2-4b3d-a768-a5a766220bc2"/> </reportElement> <textFieldExpression><![CDATA[$F{label}]]></textFieldExpression> </textField> <textField> <reportElement x="602" y="0" width="150" height="15" uuid="6e60f3d6-f953-4f9c-a5f6-0ef60f71d168"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="af80e1f4-8c05-47e9-bb32-3ea29bfd3e86"/> </reportElement> <textFieldExpression><![CDATA[$F{value_count}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="21" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport> Thanks, Hal

I have setup a parameter as a java.util.collection, let's call it var1 I use this in my where clause so if nothing is selected for the parameter, I will get a match. It looks like this: and ($X{IN,null,var1} or $X{IN, column_1, var1}) I've been doing this for over 5 years and now it doesn't want to work when I don't select anything for the parameter. Any ideas why?

I've been using Jasper Server for about 3 years and have successfully created many reports that use input parameters. Simple one and multi-select cascading input parameters. I've started having an odd problem when executing the reports from jasper server. When I'm in ireports, I have a connection to my server and can run the reports from the server. The reports execute properly, the cascading input parameters work great. The problem is when I run the report in jasper server. I log in, select the report and the parameters may not even execute. Sometimes they will execute and I select the 1st input control. The 2nd input executes a query based on the first entry. The 2nd query does not execute the query so I can't select the input control for the 2nd input control. In other cases, the input controls don't display at all. These are reports that have worked in the past but for some reason aren't working. Is there something I can check with the server that could cause this problem?

Did you ever get an answer to your question?

I ran this same report with minimal output on the report and it worked just fine.

We have embedded jasper in our application and it mostly works. Sometimes we have issues that we could use help from others. My current issue it we have a report that runs great if executed it through iReports 5.6 or through logging into jasper server. The report takes about 5-6 seconds to produce the report. When I execute it through our app, it either fails or gets stuck at executing. Sometimes the embedded report will work and then sometimes it won't. Sometimes, narrowing the output i will work. We've checked everything we know to check. Is there a specific source of help or community of users embedding jasper community version in their app? We're embedding it in a ruby app.

I have been using hyphens (-) in naming some of my images and subreports. It's been working just fine on jasper server Product Version: 5.5.0 Build: 20131024_0957 We setup a new server with the same version of jasper server and exported and imported everything so it's the same as the server I've been running without a problem. Now when my report tries to retrieve an image file containing hypens, I get an error message. Same with subreports. Of course, I'm assuming it's the name that's causing the problem. It's not finding the file. Any ideas why my previous server continues to work and the new server can't find the images and subreports?

We're using the option of embedding jasper reports inside the navigation of our app to product pdf reports. Is there a way to export a .csv with the way we've embedded jasper? We're using the community edition. Thanks.

I have a report that is a series of reports based on the same data from a that can take a considerable amount of time to execute. Each report is in a different subreport. The only difference in each report is how it's formatted, grouped and ordered. Is there a way I can execute 1 query and use the results in multiple reports?

I want to save my iReport files to a different drive on my mac. When I try to save/open a report file I don't see a way to navigate to a different hard drive. Am I missing something obvious?

I'm creating a variable to select the lowest value of a field. I need to have it only return 0 if that is the only number available. So if there is a number larger than 0 I want that number, if not then 0.