[Added driver to classpath, but not showing up]

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]

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 ?

 

[Prompt not working for iReport 4.7 ?]

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 ?

 

[Disable email]

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.

[Dynamic Parameters]

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.

 

[Embed jasper reports in web appplication]

 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>

 

 

 

[Dynamic date in iReports and JasperServer]

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

[how to compare multiple date ranges - find gaps]

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

[Cannot upload JRXML file in repository]

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 ?

[Error when entering more than one email recipient in schedule]

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

[Cannot upload JRXML file in repository]

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

[User Is as Parameter]

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

 

[User Is as Parameter]

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>

[Default value of parameter while scheduling on jasper server 4.0.0]

 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

[Scheuled report different that manul report]

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.

 

[Embed JasperServer in another app]

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.

 

 

[Testing reports]

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

 

[Testing reports]

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.

 

[Jasperserver Enterprise Pro Chart not displaying]

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.

 

[Jasperserver Enterprise Pro Chart not displaying]

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.

 

 

 

 

[What could be causing an infinite Loop]

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.

[Schedule reports - files download to file system]

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

[Should I upgrade?]

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.

[Querying the JasperReport server MySQL database]

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.

 

[Jasper Server report scheduling question]

Perhaps you can create a second report that uses current_date inside the query for end date. Other than that you need to setup dynamic dates that does a run time calculation to figure out dates. For instance "Yesterday", "Last Week", etc. Seach this wiki for dynamic dates and you should see some examples.