[Password History]

Did you check this page ? https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v60/configuring-user-password-options

for your password pattern, you need to come up with a regular expression. Below link will help you in creating a regex pattern.

https://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html

[Input Parameters are reset in new 6.5.0 Studio version]

I think the jasper studio clears out the cache when the report layout is modified. 

I dont think this can be disabled. 

 

[How to calculate the number of lines in a page which is going to change dynamically?(rather than the number of records in a page)]

did you try using Min Height To Start New Page option on the Groups ? 

[Reports fail in repository, work fine in IDE]

check if you have any deprecated functions or features being used in the jrxml. 

example : hTextAlign

 

[How to Add Dynamic Columns in Jasper Studio in jrxml file itself -]

try to write a SQL statement which would generate dates dynamically based on a given parameter month. 

then use that dynamic SQL in a crosstab to populate the jrxml

I use below Oracle SQL while generating dynamic dates

select  trunc(sysdate+1) + level -1 as business_date
from    dual
connect by sysdate + level -1 < sysdate + 30  

[ORA-28040 - no matching authentication protocol.]

Try using ojdbc7 on the data adapter driver classpath. 

https://stackoverflow.com/questions/24100117/ora-28040-no-matching-authentication-protocol-exception

 

[Set conditional expression, right way !]

try evaluating it a boolean

<conditionExpression><![CDATA[($F{OblPL}>0)==true]]></conditionExpression>

[Impossible to create Data Adapter for Oracle]

try using ojdbc7 and see if it works

[How to export pdf with font bold (advanced)]

Wow... This is a nice idea, if implemented successfully. 

I have been reading about the hot deployment techniques on tomcat and it should be applicable for jboss too. 

If your problem is bringing down the application server for deployments, then it can be resolved by using hot deployments.

try Jrebel or Bamboo. 

 

[What is the purpose of the "master" option for variable reset type]

I believe Master here references the Parent Jrxml with subreports/table elements. 

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v630/understanding-subreports

[How to use a parameter from the main data set in a second dataset]

even for the charts, you should have Dataset Options. 

when you drag the chart element into a band, the chart options configuration should allow you to configure the dataset options.

 

[How to use a parameter from the main data set in a second dataset]

If you are using a subreport or table element, Click on the Element and Navigate to Properties pane -> Dataset Options

In the dataset options, Parameters button should have these mapping options. 

Check this sample jrxml that I have created

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1  --><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="dataset" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="41ad4074-cb41-4a31-9d0a-7429b1f4304f">    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>    <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>            <topPen lineWidth="0.5" lineColor="#000000"/>            <leftPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>            <rightPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>            <topPen lineWidth="0.5" lineColor="#000000"/>            <leftPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>            <rightPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>            <topPen lineWidth="0.5" lineColor="#000000"/>            <leftPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>            <rightPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <subDataset name="SubDataset" uuid="28c1570d-9e49-44f1-ba39-75a28824b5d2">        <property name="com.jaspersoft.studio.data.sql.tables" value=""/>        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PRODSUP"/>        <parameter name="start_date" class="java.sql.Date"/>        <parameter name="end_date" class="java.sql.Date"/>        <queryString language="SQL">            <![CDATA[select * from dual]]>        </queryString>        <field name="DUMMY" class="java.lang.String"/>    </subDataset>    <parameter name="start_date" class="java.sql.Date"/>    <parameter name="end_date" class="java.sql.Date"/>    <queryString>        <![CDATA[select * from dual]]>    </queryString>    <field name="DUMMY" class="java.lang.String"/>    <background>        <band splitType="Stretch"/>    </background>    <columnHeader>        <band height="20" splitType="Stretch">            <staticText>                <reportElement x="0" y="0" width="80" height="20" uuid="a73fc6e4-9651-435d-8b29-9f09ed26e177"/>                <text><![CDATA[start_date]]></text>            </staticText>            <staticText>                <reportElement x="80" y="0" width="100" height="20" uuid="5c6c670f-062d-40e9-a799-70b38822b9ba"/>                <text><![CDATA[end_date]]></text>            </staticText>        </band>    </columnHeader>    <detail>        <band height="19" splitType="Stretch">            <textField pattern="MM/dd/yyyy">                <reportElement x="0" y="0" width="80" height="19" uuid="d1173bd3-c4ac-4c64-828e-7f496cdcc33e">                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                </reportElement>                <textFieldExpression><![CDATA[$P{start_date}]]></textFieldExpression>            </textField>            <textField pattern="MM/dd/yyyy">                <reportElement x="80" y="0" width="100" height="19" uuid="e413e867-b220-43d7-a124-039bffc39cc5"/>                <textFieldExpression><![CDATA[$P{end_date}]]></textFieldExpression>            </textField>        </band>    </detail>    <summary>        <band height="60" splitType="Stretch">            <componentElement>                <reportElement x="0" y="20" width="200" height="40" uuid="a7b41590-80d0-4153-8c4a-2ca50e253a9c">                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>                    <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>                    <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>                    <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>                </reportElement>                <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">                    <datasetRun subDataset="SubDataset" uuid="d6ff833e-fc16-4ebe-b4eb-414167f26146">                        <datasetParameter name="start_date">                            <datasetParameterExpression><![CDATA[$P{start_date}]]></datasetParameterExpression>                        </datasetParameter>                        <datasetParameter name="end_date">                            <datasetParameterExpression><![CDATA[$P{end_date}]]></datasetParameterExpression>                        </datasetParameter>                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                    </datasetRun>                    <jr:column width="100" uuid="83c0f516-06ae-49d3-9a94-6c186059493f">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>                        <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                        <jr:columnHeader style="Table_CH" height="20" rowSpan="1">                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                            <staticText>                                <reportElement x="0" y="0" width="100" height="20" uuid="89208895-8a53-411e-83a7-fbc538b59156"/>                                <text><![CDATA[start_date]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table_TD" height="20">                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                            <textField pattern="MM/dd/yyyy">                                <reportElement x="0" y="0" width="100" height="20" uuid="dc074a58-46d0-4869-8659-3cfbaa74f38a"/>                                <textFieldExpression><![CDATA[$P{start_date}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="100" uuid="1fee413f-54e7-473e-9cfa-58f517c6fa0a">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>                        <jr:columnHeader style="Table_CH" height="20" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="100" height="20" uuid="afc24d09-e545-4896-ae94-9647708029f4"/>                                <text><![CDATA[end_date]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table_TD" height="20">                            <textField pattern="MM/dd/yyyy">                                <reportElement x="0" y="0" width="100" height="20" uuid="57448548-15d5-4b6c-872b-1d06347fcf9b"/>                                <textFieldExpression><![CDATA[$P{end_date}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                </jr:table>            </componentElement>            <staticText>                <reportElement x="0" y="0" width="100" height="19" uuid="e41bfa2f-35af-4884-8218-3a78f95175ac"/>                <text><![CDATA[from SubDataset]]></text>            </staticText>        </band>    </summary></jasperReport>[/code]

 

[Migrate from Oracle reports to Jasper reports]

Oracle reports instance should have a tool called rwconverter.exe, through which you can get the SQL out of the Oracle reports.

thats the only salvageable part from the oracle reports. There is no tool which can  directly convert rdf to jrxml's. 

From the effort standpoint, you are looking at designing the reports from scratch. 

[Report output format only csv or xlsx]

This kind of feature is not available with the current version of jasper. 

Report basis export options are not available. If I were you, I would hide the report elements from displaying on PDF's or other formats by using config reference properties.

[Anyone know of Jasperreport developers]

@George it could be a simple datasource issue. Try editing the report on server and select a datasource from repository. 

post your jrxml if you can. 

[Anyone know of Jasperreport developers]

are you getting any Server error (or) is it returning a blank report ? 

[Is there any possibility of finding the NEXT record in ireport?]

by writing a variable, this could be possible, but It gets complicated with jasper if you have multiple record groups. 

but i have achieved this kind of calculations using Oracle functions (lead and lag functions are the best). These functions can handle multiple record groups using grouping functions.

http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1194471268

[Interactive PDF]

there is already an enhancement request opened for this feature. 

but at this point of time, this feature is not available

https://community.jaspersoft.com/wiki/issue-involving-tibco-jasperreports-pdf-output-fillable-format

[[SOLVED] how do you backup jasperreports server]

three options

1. login as jasperadmin and right click on the root folder and click Export. https://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v550/import-and-export-through-web-ui
2. use js-export through command line. https://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v550/import-and-export-through-command-line
3. Create a snapshot of the VM being used and restore when necessary

[Display top N elements in bar chart [resolved]]

instead of $P{LIMIT_ROW}, use $P!{LIMIT_ROW}

 

[Is posible to Export via REST API to PPT?]

REST supports pptx.

https://localhost:8080/jasperserver/rest_v2/reports/reports/report.pptx

I have used the above rest call and it downloaded the pptx file

[how to calculate < 30days from the expiry date from my coloumn expiry date]

    <style name="Style1">        <conditionalStyle>            <conditionExpression><![CDATA[DAYS($F{EXPIRY_DATE}, new Date() ) < 30 ? true : false]]></conditionExpression>            <style mode="Opaque" backcolor="#FF0400"/>        </conditionalStyle>[/code]

Use $F{EXPIRY_DATE}, new Date() ) < 30 ? true : false as an expression. 

Here is the entire jrxml

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1  --><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="style" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="55132001-98e6-4a24-9027-0b028c086f0f">    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>    <style name="Style1">        <conditionalStyle>            <conditionExpression><![CDATA[DAYS($F{EXPIRY_DATE}, new Date() ) < 30 ? true : false]]></conditionExpression>            <style mode="Opaque" backcolor="#FF0400"/>        </conditionalStyle>    </style>    <queryString>        <![CDATA[select to_date('10/02/2017', 'MM/dd/yyyy') as expiry_date, 'PRODUCT1' as ID from dual union allselect to_date('09/15/2017', 'MM/dd/yyyy') as expiry_date, 'PRODUCT2' as ID from dual union allselect to_date('06/30/2017', 'MM/dd/yyyy') as expiry_date, 'PRODUCT3' as ID from dual]]>    </queryString>    <field name="EXPIRY_DATE" class="java.sql.Timestamp"/>    <field name="ID" class="java.lang.String"/>    <background>        <band splitType="Stretch"/>    </background>    <columnHeader>        <band height="30" splitType="Stretch">            <staticText>                <reportElement x="0" y="0" width="80" height="30" uuid="1347b6a7-b19a-49e5-8bd2-33c66e12417e"/>                <text><![CDATA[iD]]></text>            </staticText>            <staticText>                <reportElement x="80" y="0" width="100" height="30" uuid="8cd28213-afae-4ef0-b506-938f0d5a9996"/>                <text><![CDATA[EXPIRY_DATE]]></text>            </staticText>        </band>    </columnHeader>    <detail>        <band height="35" splitType="Stretch">            <textField>                <reportElement x="0" y="0" width="80" height="30" uuid="9aeaa559-cb74-4e54-9785-683c8326523f"/>                <textFieldExpression><![CDATA[$F{ID}]]></textFieldExpression>            </textField>            <textField>                <reportElement style="Style1" x="80" y="0" width="100" height="30" uuid="b5fec6d7-a50d-4348-8b1f-a253065858cc"/>                <textFieldExpression><![CDATA[$F{EXPIRY_DATE}]]></textFieldExpression>            </textField>            <textField>                <reportElement x="180" y="0" width="100" height="30" uuid="7ec6a95d-e06b-4b82-a279-20b7ba4df41c"/>                <textFieldExpression><![CDATA[DAYS($F{EXPIRY_DATE}, new Date() ) < 30 ? true : false]]></textFieldExpression>            </textField>        </band>    </detail></jasperReport>[/code]

 

[[SOLVED] how do i import jasperreport into jaspersoft server]

please refer to this documentation

https://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v550/import-and-export-through-web-ui

[Displaying Percentage Sign in Crosstab]

On the Crosstab field Text Field Properties, you should be able to see Pattern Properties.

Click on the 3 dots button and select a Percentage Pattern.

It should add a % symbol to the crosstab value. 

[unable to resolve class net.sf.jasperreports.compilers.GroovyEvaluator]

I'm using jasperreports-6.4.3.jar in my build path and the class can be still found. 

I dont see that the GroovyEvaluator being deprecated

http://jasperreports.sourceforge.net/api/net/sf/jasperreports/compilers/GroovyEvaluator.html

Check if you are missing the jar