Portlight

Here is a pretty good tutorial. Additionally there are instructions with each version release at the download site.

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?