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

I have a scheduled report that has "ignore pagination" set. When I run this manually it does the right thing (No paging), but when I run it via the scheduler it does pagination. Any one run into this or have a hint how to fix. It seems like there is a copy of the report saved somewhere for scheduling that it did not update when I changed the "ignore pagination" setting in the jrxml file.

Looking to see how others did when trying to embed JasperReports in another app. Was it actually do-able ? Did it meet your requirements ? Would you recommend I go down this path ? I have a company client facing web app that needs a reporting tab and I currently do reporting with Jasper Enterise 4.5 - Any insight is apreciated and I will share what I find.

What I decided to do was to create a servlet that runs any report via an http get call.The report data is returned as csv export. I then wrote a junit test that run the report and does a diff against another file with expected results. I am doing a small write up on it at: http://reptics.com/?p=22

Looking to figure out how to go about testing a set reports that are in production. Does anyone have advice on what they do, my guess is that testing is a manual process (probably because that is what i do) . In the greater scheme of the work done for reporting, this usually takes a back burner, but as a one man shop for creating/delivering reports, it would be nice to have some automated way to check on things.

Thanks for the response, I also found that at times when you set pagination to true and move to a new page and back , the charts seems to randomly appear. Also as a side note, does anyone else find it ridiculus that there is no way to let support for the paid version know of a bug you found unless you pay for support. I actually talked to my sales rep about this and all he kept saying is if you pay we can address it. Shouldn't companies take responsibility for problems and at least make an effort to address them without requiring the client reporting it to pay.

Hi All. I am running Jasperserver Enterprise 4.2.1 and when I use pro charts, they are not showing up in the jarperserver web UI from FireFox or Chrome. Anyone run into this ? The charts show up fine in PDF and FLash output as well as html initiated from iReport.

I had infinite loop problem when I mistakenly set my subreport to be the same as the main report, so it is recursive. Just double check yor your report to see if you have the same problem.

They are all in the database, the actual file is stored in the table JIContentResource, they are not saved to the file system.

I recommend the upgrade since you already tested it, you get bug fixes as well as positioning yourself for future upgrades. I have upgraded to 4.1 and all went great. I use the themes options that were released with 4.0. Also saved Options are a nice feature.

I suggest that you export all the jrxml files and then use linux tools like grep, sed, etc to make the changes. Then import them back into place. I always keep a exact copy of the jrxml files on disk (subversion or csv), then these changes are much easier to do.