[How to send only status email notifications]

Hi,

 

you may need to set disableSendingAlertToOwner property to true in /WEB-INF/applicationContext-report-scheduling.xml config file.

Check Admin Guide for more details:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v640/configuring-scheduler#Failure_Notifications

Hope, this help

Best regards,
Andrew

[REST API Export remove Column headers not working]

Hi,

you may need to play with 'ignorePagination' and/or 'onePagePerSheet' parameters in the call:

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v640/reports-service

Best regards,

Andrew

[Passing parameters to a dataset]

Hi,

have you tried a solution provided in the similar question?

http://community.jaspersoft.com/questions/823038/passing-main-parameter-sub-datasets-jasperstudio

Best regards,

Andrew

[Set expression image with a field]

Hi,

after adding an Image element to report, you should be able to use any field from report dataset in image expression. In JRXML it looks like

            <image>
                <reportElement x="9" y="18" width="50" height="50" uuid="fd0c1fc5-742f-472b-b048-bc48c461a58f"/>
                <imageExpression><![CDATA[$F{img}]]></imageExpression>
            </image>

Have you tried it?

Best regards,
Andrew

[Custom Roles and Permissions]

Hi,

according to Admin Guide, least restrictive permission should be applied:

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v62/repository-permissions-0

 

Best regards,
Andrew

[Create Table Element in jasper Programically]

Hi,

please find attached a sample Java code to create Table component dynamically.

Hope, this helps you to achieve your requirements

Best regards,
Andrew

[Role Based Access to a Row]

Hi,

it depenends on your requirements. You mentioned users in question:

if I login from User A, Department A data should be displayed

You can use any of the built-in parameters per your scenario.

Best regards

[Create Table Element in jasper Programically]

Hi,

jJasperDesign object can be created dynamically, without using a prepared JRXML file.

Please review provided sample:

http://jasperreports.sourceforge.net/sample.reference/noxmldesign/index.html

Best regards,

Andrew

[Space between series values in tooltip HTML5 charts]

Hi,

you can try to use Tooltip Formatter function to customize tooltip:

http://community.jaspersoft.com/wiki/functions-can-be-used-format-html5-datalabels-and-tooltips

Best regards,

Andrew

[Role Based Access to a Row]

Hi,

what you can try is to use LoggedInUsername buit-in parameter to retrieve logged in user and use it in a query
to retrieve requried records:

http://community.jaspersoft.com/wiki/built-parameters-logged-user

Best regards,
Andrew

[Jasper Data Source Connection error]

Hi,

have you copied required JDBC driver (oajc.jar I guess) to WEB-INFlib folder?

Best regards,
Andrew

[Convert Varchar to Float via Domain Calculated Fields]

Hi,

you can specify your custom function in WEB-INFapplicationContext-semanticLayer.xml to convert varchar to float.

There is str2int function already defined in the file, within "sqlserverGenerator" bean:

<entry key="str2int">
                    <value>"cast(" + sqlArgs[0] + " as numeric(10,0))"</value>
</entry>

 

You can add your custom one like

<entry key="str2float">
                    <value>"cast(" + sqlArgs[0] + " as float)"</value>
</entry>

then restart the server and use str2float() function in Domain Calculated field

Best regards,
Andrew

[how to change sender email id (admin@company.com) from TAC notifications]

Hi,

it seems the only way to change Mail From address is to modify it directly in ETL repository database:

SELECT * FROM "configuration" where "key" = 'mail.notify.address'

Hope, this helps

Best regards,
Andrew

[How i can insert xml data into table component?]

Hi,

it seems the issue caused by empty datasource of the main report.

I was able to build a report in Jaspersoft Studio that returns required data, please find attached JRXML file.

I created XML data adapter using provided XML file, and use it as the main report datasource:

<queryString language="xPath">

<![CDATA[/]]>

</queryString>

 

The Table component has the following JSDatasource Expression:

<dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/addressbook/person/name")]]></dataSourceExpression>[/code]

Also, find attached printscreen of the report output.

Hope, this helps.

Best regards,
Andrew

[Export Crosstab To Excel To Ignore Pagination and Width]

Hi,

you may try using a property to ignore Page Width value for crosstabs:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.crosstab.ignore.width

Try to set it up to true at the report level and re-test the issue.

Best regards,
Andrew

[Jaspersoft Studio - Jasper Reports Windows 32 bit]

Hi,

JasperSoft Studio x86 version is available in Download section

http://community.jaspersoft.com/download

TIBCOJaspersoftStudioPro-6.2.0.final-windows-installer-x86.exe

6.2.0

Windows

32-bit

 

[Consult report without login]

Hi,

did you enable anonymous access to JasperReports Server as described in the article:

http://community.jaspersoft.com/wiki/allow-anonymous-access-reports

?

By default, anonymous access is disabled

[Create a data source to a mongo db cluster]

Do you have Query Router (mongos process) running on a separate port? You can try connecting to it.

[How to create Reports in Jasper which consume data from REST API in JSON format.]

Did you try adding parameters to the REST URL like

http:///?parameter1=value1&parameter2=value2

 

?

[Create a report with connections on both databases Postgresql 9.0.]

Hi,

try using expression like 

java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sugarcrm","postgres","postgres")

as subreport Connection Expression value 

Best regards,
Andrew

[How to use my Jasper reports within another apliicação?]

Hi,

iReport uses JasperReports Library to compile, fill and export reports. JasperReports Library is a Java Library that offers an interface to the JasperReports Library reporting engine. You can use the library in your application.

Please review the article below to see how it works:

http://community.jaspersoft.com/wiki/getting-started-jasperreports-library
http://community.jaspersoft.com/wiki/jasperreports-library-tutorial

Best regards,
Andrew

[Hide a column in jasper Report But should adjust with next column]

Hi Mohammed,

try using Table element and PrintWhenExpression for a column to achieve the requirements.

Best regards,
Andrew

[Decreasing hours from a date field]

Hi,

you can use a Java expression like below to decrease 2 hours form a date field 

new Date($F{orderdate}.getTime() + 2 * 3600*1000)

3600*1000 is 1 hour in milliseconds

[How to create Reports in Jasper which consume data from REST API in JSON format.]

Hi,

you can find details in the article

http://community.jaspersoft.com/wiki/how-use-json-remote-data-source-version-561

[Date Picker Input Control - Start Week on Sunday not Monday]

Hi,

as you modified optimized scripts, there is no need to re-optimize it again.