brooneyx1

Added driver to classpath, but not showing up. I added a drive rto my classpath via ireport and when I go to new jdbc connection it does not show up ? Any hints on how to debug ? I did this with 5.0 as well as 5.0.1. The same driver worked when I added it to Service/Database and i could connect ?

Multi select for 4.7 seems broken, I have a multi select input selector that works fine in 4.2.1 but when I try the same in 4.7, it is not working. It is a integer collection that gets returned, but in 4.7 it is just returning the first item regardless of what I have choosen. Any one else having this issue ? Any workaround or fix on the way ?

I am being hit by the same bug - I find this ridiculous that it is not fixed immediately. I will be looking at a Pentaho solution if this is not fixed soon.

I started using iReport 4.7 and I can't seem to get it to prompt for a parameter. I checked the box but no affect. Anyone else run into this ? Any workaround ?

At times I need to disable email and I usually just stop the server but that sends out nagios alerts that I do not want at times I was thinking I could just change the email host to disable email while leaving the serber running. Any other way to stop email but keep the server running or does that sound like a good way to handle it.

I have a write up on how I did this along with a sample report and jar file for the code. See http://reptics.com/ - Might help you with how you are thinking of doing this.

You need to add a URL parameter to change the theme &theme=embed for instance and you would also need to install the theme so it can be used. I got the attached embed.zip file from jaspersoft as an example so I included it here for you. There may be some other way of doing this, but this is how I was going about it. I think using the REST API may be a better solution,getting the theme right and making it look like the app we embedded in was a pain so we stopped that approach and did not embed it. <iframe marginwidth="0" marginheight="0" hspace="0" vspace="0" align="middle" frameborder="0" height="700" scrolling="no" width="100%" src=" echo $username ?>&j_password=<?php echo $password ?>"></iframe>

I added a sample report as well as download links to my jar files and jrxml sample for the way I implemented dynamic dates in Jasper. I use this for scheduled reports to get the functionality needed for user pickable dates that are releative to the date when the report is run. See reptics.com for a write up and downlaod links. Aslo attached files to this message. Post Edited by brooneyx1 at 06/17/2012 12:49

I think you need to do this in the query where clause. Where invoice.startdate between $P{StartDate} and $P{EndDate} or // Next where cluase

I got this to work by editting the file: WEB-INF/classes/esapi/security-config.properties And setting: security.validation.input.on=true I had it set it to false previously in order to fix a bug in scheduled email. With a multi user recipient list, scheduling breaks unless I set this to false. So setting it to false fixed that bug and caused this one. Anyone else have a different fix for the email bug ? Can you all check if you have this values set to false also ?

Posted to the wrong thread, but still applicable to this one: If I set to false it breaks resource upload. I got this to work by editting the file: WEB-INF/classes/esapi/security-config.properties And setting: security.validation.input.on=true I had it set it to false previously in order to fix a bug in scheduled email. With a multi user recipient list, scheduling breaks unless I set this to false. So setting it to false fixed that bug and caused this one. Anyone else have a different fix for the email bug ? Can you all check if you have this values set to false also ? Post Edited by brooneyx1 at 02/22/2012 15:46

We are having the same problem. I cannot upload any files, when I try I get the error message: The file was not uploaded I can however over write files that are already there without a problem ! Post Edited by brooneyx1 at 02/12/2012 19:01

Yes, sorry about leaving out that important peice of information. The report will only work in jasperserver, not in iReport !

I attached a small jrxml file that I use to display the properties assigned to the logged in user. I usually add $P{LoggedInUser} in my reports to show who ran the report. http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> Code: <?xml version="1.0" encoding="UTF-8"?><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="UserData" language="groovy" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="LoggedInUser" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User" isForPrompting="false"/> <parameter name="LoggedInUsername" class="java.lang.String" isForPrompting="false"/> <parameter name="LoggedInUserFullName" class="java.lang.String" isForPrompting="false"/> <parameter name="LoggedInUserEmailAddress" class="java.lang.String" isForPrompting="false"/> <parameter name="LoggedInUserEnabled" class="java.lang.Boolean" isForPrompting="false"/> <parameter name="LoggedInUserExternallyDefined" class="java.lang.Boolean" isForPrompting="false"/> <parameter name="LoggedInUserTenantId" class="java.lang.String" isForPrompting="false"/> <parameter name="LoggedInUserRoles" class="java.util.Collection" isForPrompting="false"/> <parameter name="LoggedInUserAttributes" class="java.util.Map" isForPrompting="false"/> <parameter name="LoggedInUserAttributeNames" class="java.util.Collection" isForPrompting="false"/> <parameter name="LoggedInUserAttributeValues" class="java.util.Collection" isForPrompting="false"/> <background> <band splitType="Stretch"/> </background> <title> <band height="468" splitType="Stretch"> <frame> <reportElement mode="Opaque" x="28" y="0" width="476" height="172" backcolor="#CCCCCC"/> <textField> <reportElement mode="Transparent" x="111" y="0" width="318" height="20" backcolor="#FFFFFF"/> <textElement/> <textFieldExpression><![CDATA[""+$P{LoggedInUser}]]></textFieldExpression> </textField> <textField> <reportElement mode="Transparent" x="111" y="20" width="318" height="20" backcolor="#FFFFFF"/> <textElement/> <textFieldExpression><![CDATA[$P{LoggedInUsername}]]></textFieldExpression> </textField> <textField> <reportElement mode="Transparent" x="111" y="40" width="318" height="20" backcolor="#FFFFFF"/> <textElement/> <textFieldExpression><![CDATA[$P{LoggedInUserFullName}]]></textFieldExpression> </textField> <textField> <reportElement mode="Transparent" x="111" y="60" width="318" height="20" backcolor="#FFFFFF"/> <textElement/> <textFieldExpression><![CDATA[$P{LoggedInUserEmailAddress}]]></textFieldExpression> </textField> <textField> <reportElement mode="Transparent" x="111" y="80" width="318" height="20" backcolor="#FFFFFF"/> <textElement/> <textFieldExpression><![CDATA[$P{LoggedInUserTenantId}]]></textFieldExpression> </textField> <textField> <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="-107" y="60" width="318" height="20" backcolor="#FFFFFF"/> <textElement/> <textFieldExpression><![CDATA[""+$P{LoggedInUserRoles}]]></textFieldExpression> </textField> <textField> <reportElement mode="Transparent" x="111" y="120" width="100" height="20" isRemoveLineWhenBlank="true" backcolor="#FFFFFF"/> <textElement/> <textFieldExpression><![CDATA[""+$P{LoggedInUserAttributes}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Transparent" x="0" y="0" width="100" height="20" backcolor="#FFFFFF"/> <textElement/> <text><![CDATA[user]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="0" y="80" width="100" height="20" backcolor="#FFFFFF"/> <textElement/> <text><![CDATA[TenantId]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="0" y="60" width="100" height="20" backcolor="#FFFFFF"/> <textElement/> <text><![CDATA[Email]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="0" y="40" width="100" height="20" backcolor="#FFFFFF"/> <textElement/> <text><![CDATA[Full Name]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="0" y="20" width="100" height="20" backcolor="#FFFFFF"/> <textElement/> <text><![CDATA[userName]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="0" y="140" width="100" height="20" backcolor="#FFFFFF"/> <textElement/> <text><![CDATA[Roles]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="0" y="120" width="100" height="20" backcolor="#FFFFFF"/> <textElement/> <text><![CDATA[Attributes]]></text> </staticText> </frame> </band> </title></jasperReport>

You would either need 2 reports or create a dynamic date entry taht allows you ot choose from a pre-defined list: I use something like: "This Week", "Last 7 Days", Last 30 Days", "Month to Date", etc. This allows me to send reports on any of the defined time slices. So I can schedule a monthly on the first by choosing "Last Month", etc. I have a writeup on this at: http://reptics.com/?p=1 And I will be releasing the cdoe behind it shortly. Others probably did something simular, so search around if how I did it doesn't fit. Post Edited by brooneyx1 at 01/24/2012 10:57