Portlight
-
Posts
138 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by Portlight
-
-
I have read the "cookbook" and frankly just do not know where to start. Should I use external authentication or should I try to setup a CAS server (I think this would not be a good solution based on the customers criteria), or token based authentication.
-
I have my primary web server as iis (this can not be changed). The Primary application has a custom built login and sso method. There is a cookie passed in the header.
I am implementing jasperServer 5.6.1
I need to be able to take this cookie and create the log on for jasper - this needs to be a true logon. I am not sure how to go about this. I have read all of the documentation but there are holes that I do not know how to fill.
Any help is appreciated.
-
I have a strange thing happening - I can execute/run my stored procedure and I get the expected data return. BUT when I execute the stored procedure from withing the report it blows up and gives an error. I KNOW that is had something to do with the date variable but can not put my finger on it.
Stored procedure
DELIMITER ///* Author: Jessie Brown Date: 8/17/13 Notes: Template Creation Comments: Comments created in the header area will NOT be stored in the database write Comments created AFTer the begin statement will be retained within the database write*/-- checks to see if stored procedure exists-- if exists the procedure is dropped and recreatedDROP PROCEDURE IF EXISTS `reportLogExceptions`//-- Creates new procedureCREATE PROCEDURE reportLogExceptions ( IN groupId int, IN logId int, IN fromDate varchar (50), IN toDate varchar (50)) BEGIN /* report name: Log Exceptions Test Query: CALL reportLogExceptions('-1','-1','1359676800','1362095999') -------------------------------------------------------------------------- Declare variables*/ DECLARE logInS varchar (50); DECLARE groupIdS varchar (50); DECLARE startDate bigint; DECLARE endDate bigint; /* Sets the variables to use for the SELECT query */ SET logInS = CASE logId WHEN '-1' THEN '%' ELSE logId END; SET groupIdS = CASE groupId WHEN '-1' THEN '%' ELSE groupId END; SET startDate = fromDate/1000; SET endDate = toDate/1000; SELECT g.groupId,g.name AS groupName,l.logId,l.name AS logName, i.itemID, i.name AS itemName, le.userName,completed, i.optimalMin,i.optimalMax ,value FROM groups g JOIN logs l ON g.groupID = l.groupId JOIN logExceptions le ON l.logID = le.logID JOIN items i ON l.logId = i.logId WHERE l.logID LIKE logInS AND g.groupID LIKE groupIdS AND le.completed BETWEEN FROM_UNIXTIME(startDate) AND FROM_UNIXTIME (endDate) ; END// DELIMITER ; [/code]jrmxl file
<?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="LogExceptions" pageWidth="612" pageHeight="792" whenNoDataType="AllSectionsNoDetail" columnWidth="612" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="df46ce6b-2d7c-4374-870e-d638c474254b"> <property name="ireport.scriptlethandling" value="0"/> <property name="ireport.encoding" value="UTF-8"/> <property name="ireport.zoom" value="1.5"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <import value="net.sf.jasperreports.engine.*"/> <import value="java.util.*"/> <import value="net.sf.jasperreports.engine.data.*"/> <import value="org.joda.time.*"/> <parameter name="groupId" class="java.lang.Integer"/> <parameter name="logId" class="java.lang.Integer"/> <parameter name="fromDate" class="java.lang.String"> <defaultValueExpression><![CDATA["1360495085000"]]></defaultValueExpression> </parameter> <parameter name="toDate" class="java.lang.String"> <defaultValueExpression><![CDATA[$P{dateRangeTitle}.equals("All") ? "":(new DateTime(Long.parseLong($P{fromDate}), DateTimeZone.forID($P{timeZone})).getMonthOfYear() + "/" + new DateTime(Long.parseLong($P{fromDate}), DateTimeZone.forID($P{timeZone})).getDayOfMonth() + "/" + new DateTime(Long.parseLong($P{fromDate}), DateTimeZone.forID($P{timeZone})).getYear() + " to " + new DateTime(Long.parseLong($P{toDate}), DateTimeZone.forID($P{timeZone})).getMonthOfYear() + "/" + new DateTime(Long.parseLong($P{toDate}), DateTimeZone.forID($P{timeZone})).getDayOfMonth() + "/" + new DateTime(Long.parseLong($P{toDate}), DateTimeZone.forID($P{timeZone})).getYear())]]></defaultValueExpression> </parameter> <parameter name="dateRangeTitle" class="java.lang.String" isForPrompting="false"/> <parameter name="timeZone" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["US/Pacific"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[CALL reportLogExceptions $P{groupId},$P{logId},$P{fromDate},$P{toDate}]]> </queryString> <field name="groupId" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="groupName" class="java.lang.String"/> <field name="logId" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="logName" class="java.lang.String"/> <field name="itemID" class="java.lang.Long"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="itemName" class="java.lang.String"/> <field name="userName" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="completed" class="java.sql.Timestamp"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="optimalMin" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="optimalMax" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="value" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <sortField name="groupId"/> <sortField name="logId"/> <sortField name="completed"/> <variable name="itemCount" class="java.lang.Integer" calculation="Count"> <variableExpression><![CDATA[$F{itemID}]]></variableExpression> </variable> <group name="logID"> <groupExpression><![CDATA[$F{logName}]]></groupExpression> <groupHeader> <band height="35"> <staticText> <reportElement uuid="8cbaa707-f287-4d90-82ba-f1e07bb483ef" mode="Opaque" x="51" y="17" width="48" height="17" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#999999"/> <textElement verticalAlignment="Middle"> <font size="9" isBold="true"/> <paragraph firstLineIndent="5"/> </textElement> <text><![CDATA[Log:]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement uuid="55bfe099-40aa-456a-9d3d-bb7e983be9fa" mode="Opaque" x="98" y="17" width="465" height="17" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#999999"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{logName}]]></textFieldExpression> </textField> <staticText> <reportElement uuid="758d22cc-5037-452e-91c1-4c537092f0be" mode="Opaque" x="51" y="0" width="48" height="18" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#999999"/> <textElement verticalAlignment="Middle"> <font size="11" isBold="true"/> <paragraph firstLineIndent="5"/> </textElement> <text><![CDATA[Group:]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement uuid="32ceb095-b50e-48c7-90d1-314a5691f4c9" mode="Opaque" x="98" y="0" width="465" height="18" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#999999"/> <textElement verticalAlignment="Middle"> <font size="9"/> </textElement> <textFieldExpression><![CDATA[$F{groupName}]]></textFieldExpression> </textField> </band> <band height="13"> <staticText> <reportElement uuid="ab84b7a8-a287-48ce-993b-fdf04f9fddc2" mode="Opaque" x="51" y="0" width="75" height="12" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#4C4C4C"/> <textElement> <font size="9"/> <paragraph firstLineIndent="5"/> </textElement> <text><![CDATA[Date]]></text> </staticText> <staticText> <reportElement uuid="ed11b905-910b-4b1c-b02b-6345553db2bc" mode="Opaque" x="126" y="0" width="50" height="12" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#4C4C4C"/> <textElement> <font size="9"/> </textElement> <text><![CDATA[Time]]></text> </staticText> <staticText> <reportElement uuid="9a14d055-9966-4f49-976a-b84d4cefb3cb" mode="Opaque" x="273" y="0" width="139" height="12" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#4C4C4C"/> <textElement> <font size="9"/> </textElement> <text><![CDATA[item]]></text> </staticText> <staticText> <reportElement uuid="4bdb9ee7-5fe8-4b52-ab69-12c575637c54" mode="Opaque" x="411" y="0" width="53" height="12" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#4C4C4C"/> <textElement> <font size="9"/> </textElement> <text><![CDATA[Value]]></text> </staticText> <staticText> <reportElement uuid="ca63e29f-f319-4403-b4bd-f7a2e9b40d77" mode="Opaque" x="464" y="0" width="50" height="12" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#4C4C4C"/> <textElement> <font size="9"/> </textElement> <text><![CDATA[Opt. Min]]></text> </staticText> <staticText> <reportElement uuid="4213ba72-9bc9-4c86-a39d-9f2cde2b9e1d" mode="Opaque" x="513" y="0" width="50" height="12" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#4C4C4C"/> <textElement> <font size="9"/> </textElement> <text><![CDATA[Opt. Max]]></text> </staticText> <staticText> <reportElement uuid="7dddf474-1374-4b6e-8494-e5d405dc6888" mode="Opaque" x="176" y="0" width="97" height="12" printWhenGroupChanges="logID" forecolor="#FFFFFF" backcolor="#4C4C4C"/> <textElement> <font size="9"/> </textElement> <text><![CDATA[Employee Name]]></text> </staticText> </band> </groupHeader> </group> <group name="Group"> <groupExpression><![CDATA[$F{groupName}]]></groupExpression> <groupHeader> <band/> </groupHeader> </group> <pageHeader> <band height="17"> <staticText> <reportElement uuid="71302475-be34-4723-b4d7-3610684c19ac" x="424" y="5" width="64" height="12"> <property name="local_mesure_unitx" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="px"/> </reportElement> <textElement> <font fontName="SansSerif" size="9" isBold="true"/> </textElement> <text><![CDATA[Date Range: ]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement uuid="0d6bf3fa-5afa-4873-9b70-550940c37871" x="488" y="5" width="75" height="12"/> <textElement> <font fontName="SansSerif" size="9"/> </textElement> <textFieldExpression><![CDATA[$P{dateRangeTitle}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band/> </columnHeader> <detail> <band height="16" splitType="Prevent"> <textField pattern="MM/dd/yyyy" isBlankWhenNull="true"> <reportElement uuid="a3f6eead-ce34-4394-b236-2958b1013415" x="51" y="0" width="75" height="12"/> <textElement> <font size="8"/> <paragraph firstLineIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{completed}]]></textFieldExpression> </textField> <textField pattern="HH:mm" isBlankWhenNull="true"> <reportElement uuid="490c52bb-759b-4ae3-ac06-baee01703914" x="126" y="0" width="50" height="12"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{completed}]]></textFieldExpression> </textField> <textField> <reportElement uuid="70a74430-f04b-4511-93b4-550e43f57a01" x="273" y="0" width="139" height="12"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{itemName}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement uuid="a2d92a3a-2dc2-4695-869f-9887f2f0b242" x="411" y="0" width="53" height="12" forecolor="#FF0033"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{value}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement uuid="ec091218-ced0-4894-b953-e072835521b2" x="464" y="0" width="49" height="12"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{optimalMin}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement uuid="74bdcd95-5a4e-4662-bb99-4be3da054883" x="513" y="0" width="50" height="12"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{optimalMax}]]></textFieldExpression> </textField> <line> <reportElement uuid="95131222-a51f-4d35-8ec4-88f274ccc8b0" mode="Transparent" x="50" y="13" width="513" height="1" forecolor="#CCCCCC" backcolor="#CCCCCC"/> <graphicElement> <pen lineWidth="0.5"/> </graphicElement> </line> <textField> <reportElement uuid="0bc783e4-8486-4006-9158-a51889db7af6" x="176" y="0" width="97" height="12"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{userName}]]></textFieldExpression> </textField> </band> </detail> <pageFooter> <band/> </pageFooter> <noData> <band height="50"> <printWhenExpression><![CDATA[new Boolean ($V{logID_COUNT} < 1)]]></printWhenExpression> </band> </noData></jasperReport>[/code]
error thrown
Compiling to file... D:plantLogPlantLog-ReportProjectStandardLog ExceptionsReport.jasper
Compilation running time: 743!
Filling report...
Locale: English (United States)
Time zone: Default
Error filling print... Error executing SQL statement for : LogExceptions
Setting up the file resolver... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : LogExceptions at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1087) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:668) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3,-1,'1360495085000','1378811885000'' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 12 more
Print not filled. Try to use an EmptyDataSource...
any suggestions
-
The best solution for this will be to set a style, then apply that style to the output.
-
I have created a report with the following bands: group header1, group header 2, details
I would like for the details to only print in the detail bands - however when the report is executed and the data will print in column2 group header bands.
This is how the report prints now:
How can i limit what bands the data reprints in? The Enter App printed in the second column I would like to start where UserPhone is?
Is that possible?
-
I am on windows 7 - my java_home does point to it....eclipse works fine, ireport works...jaspserSoft appears to be trying to look within it's own directory NOT at the java_home variables...is there a way to manually set the java_home within studio 1.3.1
-
I have tested this and am finding the following - which I need some input on!
1. Logging in using the time zone needed does indeed give me the correct time data.
2. Scheduling the report to run when logged in with the needed time zone does NOT give me the need calculations in the report.
I need to be able to schedule these reports to run and automatically apply the time conversions found when logging in and setting the time zone.
Suggestions?
-
In This instance we are indeed using jaspserServer and I have tested using login timeZone choice...it works perfectly - what I need to know is if I create a schedule of report execution while logged in using the altered timeZone will it apply to the reports ....
-
I am trying to use jasperStudio however I get a jvm error.
How can I point studio to look at a different location for the jvm.
error: a JR or JDK must be available....
looking in jaspersoftjaspsersoft studio-1.3.1jrebinjavaw.exe
Have tried to open and manually change classpath .... this is as far as i get.
-
I have a report which is being pulled from a server in the cdt zone - I need the timesStamps stored in the DB to be converted to EST zone within the report.
I have tried to set the report_time_zone within the compile error. This makes no change.
I am open to suggestions...
1. how could i do this within the report using java code
or
2. should i attemp to alter within the stored procedure.
using 4.5
This is a high priority due to the hurricane which just hit!
-
Try something similiar to this
new Boolean ($V{sum_amount} > 0)
Place the code in the "print when expression" of the group header.
Let me know if it works....
-
Can you attach your jrxml?
-
Please email me privately. at knottysuki@gmail.com...I believe that I can help you with this.
Sincerely
Jessie
-
Is there a way to notate which version of jasperServer or iReport a file was made to be compatable with.
I use serveral versions of jasperServer - however not all past report files work with the newer version. I would like a way to notate the versions which compiled the report?
-
I have two crosstab tables...I would like to FORCE one to print on a new page.
I have tried printing on top band...does not work
Suggestions.
-
Currently we deploy use the jasperreports.jar file only to compile reports. We are deploying the application with glassfish. Do you need to install the virtualizer with apache or can the virtualizer be used with galssfish - fessing up here, on a time constraint and have not read all of the documentation yet!
thanks in advance
-
I have a report that is working on EVERY development environment I have. When deployed to the field the report gives errors.
Originally the jasperreports.jar version was 3.7.0
This gave me an sql error when the reort ran -
Operand type clash: uniqueidentifier is incompatible with float
I updated to the jasperreports.jar version 4.1.0
Now the report returns the error attached. I am also attaching the jrxml if that helps.
-
We are seeing memory usage go beyond the jvm's configured limit when loading reports that have lots of data/pages.
The line of code that fills the report is:
JasperPrint jasperPrint = JasperFillManager.fillReport(reportStream, parameters, connection.getConnection(ConnectionsFile.CONTEXT_TYPE_GENERAL, i));
It is obvious by watching the logs that the memory issue occurs during the fill - when the result set is already loaded.
I am hoping jasper has a fix or a setting that we can use to control it better. Has anyone seen this before or can someone point me in a direction to further investigate a fix. -
I have a report that is I need to create a xy chart with. I have done several charts and have not come back with this error.
The report compiles fine. When I execute the chart within the application I get the following error:
Null 'orientation' argument
I am attaching my jrxml. What am I missing.
-
Interestingly enough I found the solution - if not the issue!
When java 6 v31 downloads automatically from java.com - it does something to both jasperServer AND ireport - regardless of versioning.
IF you download from
http://java.com/en/download/manual.jsp
do a manual install, select Yes to re-install, the jasperServer starts beautifully as does all versions of iReport.
Post Edited by mgeise at 03/02/2012 01:50 PM -
I am using jasperServer-ce-3.7.0
After an automatic update to java 6 version 30 or 31 the jasperServer crashes - will not start.
Has anyone else seen this?
If so, how did you fix the problem.
-
I have a SRP that I developed several months ago. Since then I have learned a few more tricks with iReport and Jasper, so I will be updating this SRP soon. Posting the older one for you now. Will post the newer one when done - if you are still interested.
-
I have been tasked with creating a schedule type report.
I am using ms sql for the database
I am using jaspser 4.5 for reporting
I need to be able to display the information aas such
Times across the table in increments of 30 minutes
The rows underneath filled with color (different per event) so that overlaps can be shown.
Any suggestions?
-
this has been completed
Files changes were required for the following files:
jsServiceSetup and the
\jasperserver-ce-3.7.0\apache-tomcat\bin\service
How to use jasperserver source code with eclipse?
in Products
Posted
Here is a pretty good tutorial. Additionally there are instructions with each version release at the download site.