mboyle Posted July 6, 2017 Share Posted July 6, 2017 Why is the input value always null? If we manually insert a value (say, 'mike') we get data. Otherwise, empty.<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="tempjson" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin ="20" topMargin ="20" bottomMargin="20" uuid="1e755737-89be-4155-ac0f-622514dc7ccc"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sample DB"/> <property name="ireport.jasperserver.url" value="http://localhost:8081/jasperserver-pro/"/> <property name="ireport.jasperserver.user" value="jasperadmin|Reports"/> <property name="ireport.jasperserver.reportUnit" value="/public/Blank_mainjr.meb"/> <parameter name="term" class="java.lang.String"/> <parameter name="net.sf.jasperreports.json.source" class="java.lang.String"> <defaultValueExpression> <![CDATA["https://itunes.apple.com/search?term=" + $P{term}]]> </defaultValueExpression> </parameter> <queryString language="json"><![CDATA[results]]></queryString>[/code] Link to comment Share on other sites More sharing options...
narcism Posted July 10, 2017 Share Posted July 10, 2017 What is "input value"? How do you run your report? Link to comment Share on other sites More sharing options...
mboyle Posted July 10, 2017 Author Share Posted July 10, 2017 We are using the JasperReportServer (6.3) and JasperStudio (6.4). Inside of our jasperReport (jrxml) we have defined a parameter ('term'):<parameter name="term" class="java.lang.String"/><parameter name="net.sf.jasperreports.json.source" class="java.lang.String"><defaultValueExpression><![CDATA["https://itunes.apple.com/search?term=" + $P{term}]]></defaultValueExpression> In the Preview pane, we get a prompt for the 'term' that we want to use in our search. But the value we enterinto the UI is not available when the defaultValueExpression is evaluated. We have no idea why or how to workaround this. Thanks. Link to comment Share on other sites More sharing options...
narcism Posted July 11, 2017 Share Posted July 11, 2017 Try setting evaluationTime to 'Early' and isForPrompting to 'false' for the json source parameter. Your JRXML should look like so:<parameter name="net.sf.jasperreports.json.source" class="java.lang.String" isForPrompting="false" evaluationTime="Early"><defaultValueExpression><![CDATA["https://itunes.apple.com/search?term=" + $P{term}]]></defaultValueExpression></parameter> Link to comment Share on other sites More sharing options...
mboyle Posted July 11, 2017 Author Share Posted July 11, 2017 Thanks for the ideas. Alas, they did not work for either the Community Edition nor the official Jaspersoft version. We did learn that modifying the jrxml file outside of the studio, we were able to modify the file in such a way that we could successfully run using this line.<parameter name="net.sf.jasperreports.json.source" class="json"> Again - thank you for the suggestion. I hope this 'trick' works going forward. 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