[How do I pass a field to a subreport as parameter?]

I pasted it in using your xml code block and the little pop up occurred to repaste and this is what it did.  You need to fix your code block 

[How do I pass a field to a subreport as parameter?]

I am using jasper studio 6.1.1.  I am trying to pass a field as a parmeter to my subreport and then use that parameter in a sql query to retrieve additional data to ouput in the subreport.   the following is my main report code eventDetails.jrxml.

 

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1  --><!-- 2016-03-21T17:12:26 --><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="eventDetails" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fd461282-d8ef-4693-b392-8099d8766ec1"> <property name="net.sf.jasperreports.print.create.bookmarks" value="true"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="ProjectEvents_DATAADAPTER.xml"/> <parameter name="SRP_STATUSID" class="java.lang.Integer" isForPrompting="false"/> <queryString>  <![CDATA[]]> </queryString> <field name="eventDate" class="java.sql.Date">  <fieldDescription><![CDATA[eventDate]]></fieldDescription> </field> <field name="eventType" class="java.lang.String">  <fieldDescription><![CDATA[eventType]]></fieldDescription> </field> <field name="title" class="java.lang.String">  <fieldDescription><![CDATA[title]]></fieldDescription> </field> <field name="eventId" class="java.lang.Integer">  <fieldDescription><![CDATA[eventId]]></fieldDescription> </field> <field name="eventProjectId" class="java.lang.Integer">  <fieldDescription><![CDATA[eventProjectId]]></fieldDescription> </field> <field name="statusId" class="java.lang.Integer">  <fieldDescription><![CDATA[statusId]]></fieldDescription> </field> <field name="state" class="java.lang.Integer">  <fieldDescription><![CDATA[state]]></fieldDescription> </field> <field name="descriptionId" class="java.lang.Integer">  <fieldDescription><![CDATA[descriptionId]]></fieldDescription> </field> <background>  <band splitType="Stretch"/> </background> <title>  <band splitType="Stretch"/> </title> <pageHeader>  <band height="43" splitType="Stretch">   <staticText>    <reportElement x="227" y="13" width="100" height="17" uuid="f76bb01e-b410-464b-b1e9-fe86cef089a3"/>    <textElement textAlignment="Center" verticalAlignment="Middle"/>    <text><![CDATA[Event Details]]></text>   </staticText>  </band> </pageHeader> <columnHeader>  <band height="91" splitType="Stretch">   <staticText>    <reportElement x="-10" y="0" width="100" height="30" uuid="6e8f583e-6f25-459a-bdb0-bda5abacb1c0"/>    <text><![CDATA[eventProjectId]]></text>   </staticText>   <staticText>    <reportElement x="-10" y="61" width="50" height="30" uuid="8121ba38-fa4e-40bf-b4ef-59b0e2c4a9c7"/>    <text><![CDATA[eventType]]></text>   </staticText>   <staticText>    <reportElement x="50" y="60" width="60" height="30" uuid="7e6ebe78-83e5-454d-bff4-ab822ba0dac6"/>    <text><![CDATA[eventDate]]></text>   </staticText>   <staticText>    <reportElement x="120" y="60" width="100" height="30" uuid="4e5d5b03-fa70-470f-a9de-618a35b62f5f"/>    <text><![CDATA[title]]></text>   </staticText>   <textField>    <reportElement x="100" y="6" width="100" height="24" uuid="644e28b1-ae00-418c-a0af-ec1eb66eb675"/>    <textFieldExpression><![CDATA[$F{eventProjectId}]]></textFieldExpression>   </textField>   <staticText>    <reportElement x="230" y="60" width="100" height="30" uuid="b31a04ff-1ed5-47c9-b43d-add75d17a91c"/>    <text><![CDATA[statusId]]></text>   </staticText>   <staticText>    <reportElement x="340" y="60" width="100" height="30" uuid="e529e96a-2026-4c97-a881-09fcc1177370"/>    <text><![CDATA[state]]></text>   </staticText>  </band> </columnHeader> <detail>  <band height="493" splitType="Stretch">   <textField>    <reportElement x="-10" y="10" width="50" height="30" uuid="4e3895a1-e748-4427-b97e-e804eb7ecfd8"/>    <textFieldExpression><![CDATA[$F{eventType}]]></textFieldExpression>   </textField>   <textField>    <reportElement x="50" y="10" width="70" height="30" uuid="45ab8789-3c11-400e-8138-063f71448213"/>    <textFieldExpression><![CDATA[$F{eventDate}]]></textFieldExpression>   </textField>   <textField>    <reportElement x="127" y="10" width="100" height="30" uuid="496d1577-a0c9-487d-a28d-42e031aeb61f"/>    <textFieldExpression><![CDATA[$F{title}]]></textFieldExpression>   </textField>   <textField>    <reportElement x="240" y="10" width="100" height="30" uuid="18ddee79-a371-4a97-b0f7-bfa1bd5b018c"/>    <textFieldExpression><![CDATA[$F{statusId}]]></textFieldExpression>   </textField>   <textField>    <reportElement x="350" y="10" width="100" height="30" uuid="897850be-8029-4e18-9180-55669a664811"/>    <textFieldExpression><![CDATA[$F{state}]]></textFieldExpression>   </textField>   <subreport>    <reportElement positionType="Float" x="-10" y="80" width="550" height="110" uuid="edc4d949-7837-4b66-967d-f5587d491a4a"/>    <subreportParameter name="SRP_STATUSID">     <subreportParameterExpression><![CDATA[$F{statusId}]]></subreportParameterExpression>    </subreportParameter>    <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>    <subreportExpression><![CDATA["eventDetails_Sub1.jasper"]]></subreportExpression>   </subreport>  </band> </detail> <columnFooter>  <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter>  <band height="54" splitType="Stretch"/> </pageFooter> <summary>  <band splitType="Stretch"/> </summary></jasperReport>

[/code]

and here is my eventDetails_Sub1.jrxml

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1  --><!-- 2016-03-21T17:14:46 --><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="eventDetails_Sub1" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d6db356c-97ea-4adb-805e-51998e2088b2"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="CubeValue_SQL_DATAADAPTER.xml"/> <parameter name="SRP_STATUSID" class="java.lang.Integer" isForPrompting="false">  <parameterDescription><![CDATA[]]></parameterDescription> </parameter> <queryString>  <![CDATA[sELECT *FROM ConfigValuesWHERE  configvalues.`configValueID`  =$P{SRP_STATUSID}]]> </queryString> <field name="configValueID" class="java.lang.Integer">  <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="configType" class="java.lang.Integer">  <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="projectID" class="java.lang.Integer">  <fieldDescription><![CDATA[projectid=zero is the defaults for all projects (global system values)]]></fieldDescription> </field> <field name="name" class="java.lang.String">  <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="displaySeq" class="java.lang.Integer">  <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="workflowSeq" class="java.lang.Integer">  <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="allowUse" class="java.lang.Boolean">  <fieldDescription><![CDATA[]]></fieldDescription> </field> <background>  <band splitType="Stretch"/> </background> <title>  <band splitType="Stretch"/> </title> <pageHeader>  <band splitType="Stretch"/> </pageHeader> <columnHeader>  <band splitType="Stretch"/> </columnHeader> <detail>  <band height="37" splitType="Stretch">   <textField>    <reportElement x="220" y="3" width="100" height="30" uuid="5024bf79-ee18-416d-aa68-921099d619d0"/>    <textFieldExpression><![CDATA["Testing"]]></textFieldExpression>   </textField>   <textField>    <reportElement x="-10" y="0" width="150" height="30" uuid="2086b756-eed5-436c-b3ec-a5f2f46e5da0"/>    <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>   </textField>  </band> </detail> <columnFooter>  <band splitType="Stretch"/> </columnFooter> <pageFooter>  <band splitType="Stretch"/> </pageFooter> <summary>  <band splitType="Stretch"/> </summary></jasperReport>

[/code]

 

[exceptions in jaspersoft studio while testing jpa adapter]

I'm trying to use Jasper studio with JPA by using the EJBQL Connection.  I can;t seem to get the correct jars to load. I keep getting a different exceptions when testing the adapter where I then go find a jar to cover the exception and then move on to the next exception generated, so and so.  

I am currently getting a NoSuchMethodError on javax.persistence.NamedQuery.lockmode of which I cannot find the correct jar for.    The current jar listing I am using is the following list, plus the JasperRports library and JRE 1.6 included with studio

hibernate-jpa-2.1-api-1.0.0.Final.jar

mysql-connector-java-5.1.22-bin.jar

javax.persistence-2.1.1.jar

c3p0-0.9.2.1.jar

annotations-1.3.2.jar

hibernate-c3p0-5.1.0.Final.jar

hibernate-commons-annotations-5.0.1.Final.jar

hibernate-core-5.1.0.Final.jar

hibernate-ehcache-5.1.0.Final.jar

hibernate-entitymanager-5.1.0.Final.jar

hibernate-validator-5.2.1.Final.jar

slf4j-api-1.7.5.jar

slf4j-log4j12-1.7.5.jar

log4j-1.2.17.jar

jboss-logging-3.3.0.Final.jar

avalon-framework-impl-4.2.0.jar

classmate-1.3.1.jar

javax.servlet-api-3.1.0.jar

javaee-api-7.0.jar

This should not be that difficult to use the studio,  Please assist with a jar list that works or any other help you can provide

Thanks