[How to use Attributes for dynamic data source ?]

Hi,

in Manage > Server Settings > Server Attributes menu you should add atrbiutes using their name/key, that is just

userName
password

Syntax like {attribute('host','Server')}  should be used in Da tasource definition only:

jdbc:postgresql://{attribute('host','Server')}:{attribute('port','Server')}/{attribute('db','Server')}

Best regards,
Andriy

[Adding new Token based user using Http request through browser]

Hi,

as stated in Authentication Cookbook, URL should be specfied as

http://localhost:8080/jasperserver?pp=u%3DSven%7Cr%3DManager%7Co%3DEMEA,Sales%7Cpa1%3DSweden

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-authentication-cookbook/v720/token-based-authentication

Best regards,
Andrew

[Empty document but MySQL Workbench is returning the rows]

Hi,

try to use $P{product_id} instead of $P!{product_id} in the report query

Best regards,
Andrew

[How can I use JasperReports with a PHP system?]

Hi,

you can use PHP REST client as a base for your project:

https://github.com/Jaspersoft/jrs-rest-php-client

Best regards,
Andrew

[No Layouts in jasper report]

Hi,

Table element supports hiding columns and the rest of columns positions are  automatically adjusted.

Hope, it helps.

Best regards,
Andrew

[When I am trying to create a adhoc view in Jasper server it is throwing an error named "An error occurred while performing the previous request".Please assist]

Hi Santosh,

please provide more details of the issue, which steps lead to the error.

Also, please check if jasperserver.log has errors

Best regards,
Andrew

[How to install jasper reporting server... ?]

Hi,

please check if a solution provided in article below heps you:

https://community.jaspersoft.com/wiki/windows-643-and-71-bundled-installers-crashes-upon-running-initdbexe-due-missing-msvcr100dll

Best regards,
Andrew

[Unable to execute any report]

Hi,

most probably the error caused the report SQLs.

JasperReports Server validates report queries to protect against SQL injection:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v71/protecting-against-sql-injection

SQL must meet requirements described in the doc.

To test is the query triggers the errror, you can temporary disable SQL validation and try to run the report.

Hope, it helps.

Best regards,
Andrew

[How to use a java array as an source for JasperReports]

Hi,

please check if a solution described in article

https://community.jaspersoft.com/wiki/how-pass-java-list-or-list-chart-datasource-jrxml-based-reports

could help you.

Best regards,
Andrew

[How to set all values for single select parameter?]

So, 'Select All' is just a value of the single select inpuit control, right?

Did you try to specify the parameter's Default Value Expression property as "Select All"?

Best regards,
Andrew

[How to set SQL query to the dataset dynamically?]

Hi,

first of all, I'd like to mention all the SQL queries must return identical set of fields, in your scenario.

In order to achieve the requirements, you could use $P!{} syntax : 

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v71/using-parameters-queries-0

The idea is to create an additional hidden parameter which uses selected by user option from drop-down list to specify according query, like

IF($P{Parameter1}.equals("Q1"),"select orderid as id from orders",IF($P{Parameter1}.equals("Q2"),"select shipvia as id from orders","select 1 as id"))

Then, the report dataset query should be like

$P!{p_query}

Find attached sample report that demonstrates the idea.

Hope, this helps.

Best regards,
Andrew

[How to set all values for single select parameter?]

Hi,

unfortunately, it's not clear what you want to achieve.

Per the question subject, the parameter in question is Single Select. But you are looking for a way to select all values?

Please explain it more detailed.

Best regards,
Andrew

[How avoid columnHeader repeat?]

Hi,

what you could try is to use net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name} property:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name}

https://community.jaspersoft.com/wiki/how-can-i-suppress-page-headers-and-footers-when-exporting-xls

Best regards,
Andrew

[How to customize the Error message when we select more tha 2100 parameter values in jasper server.]

Hi,

the link I posted just explains that the error message comes from MS SQL Databasse and is out of JasperReports control.

Best regards,
Andrew

[How to customize the Error message when we select more tha 2100 parameter values in jasper server.]

Hi,

it seems this error message comes from underlying database:

https://www.cuba-platform.com/discuss/t/sqlserverexception-the-server-supports-a-maximum-of-2100-parameters/1991

and is not managed by JasperReports Server

Best regards,
Andrew

[Need to Display values in each pie in HTML5 Pie Chart]

Hi,

try to set plotOptions.pie.dataLabels.distance property to a negative value with 'Use expression' option checked, please check attached printscreen:

https://api.highcharts.com/highcharts/plotOptions.pie.dataLabels.distance

Best regards,
Andrew

[Jasper 7.1.0 Auto Login - Passing Hidden Username & Password]

Hi,

you may find useful a solution to encrypt both username and password in the URL as described in the article:

https://community.jaspersoft.com/wiki/how-encrypt-username-url

Best regards,
Andrew

[Page Breaks in Ad Hoc Views / Reports]

Hi,

in case of Ad Hoc report, you can achieve the requirement by setting group property 'Start New Page' to true in Jaspersoft Studio, please find attached printscreen.

[How to pass parameter value from main report to a TABLE]

Hi

you have to specify parameters mapping in Properties > Dataset > Parameters menu, please find attached printscreen.

Best regards,
Andrew

[Tables – merged cells and vertical alignment]

Hi,

you may find useful a solution described in article

https://community.jaspersoft.com/wiki/how-merge-table-rows-repeated-values

except rotating the first text field labels

Best regards,
Andrew

[HTML5 charts-Customizing tooltip formatting]

Hi,

what you could try is to use series Bucket Properties to specify required tooltip.valueDecimals value for each series.

A similar solution to define series colors are described in the article:

https://community.jaspersoft.com/wiki/dynamically-updating-bar-colors-html5-bar-charts

Hope, this helps

Best regards,
Andrew

[Localized date]

try to use the expression below to explicitly specify required locale:

new SimpleDateFormat("d MMMM", Locale.FRANCE).format( $P{start_date} )

Best regards,
Andrew

[Jaspersoft Server can't Run report with Webservice DS]

Check WEB-INFlogsjasperserver.log file and share error details

Best regards,
Andrew

[Hyperlink for HTML 5 component]

Hi,

please check TIBCO Jaspersoft Studio guide

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/creating-hyperlinks-html5-charts

as well as a community article

https://community.jaspersoft.com/wiki/how-do-i-set-chart-hyperlinks-html5-charts

Best regards,
Andrew

[how to export diff reports to diff tabs in single excel sheet??/]

Hi,

what you could try is to create so-called Book report from that 5 different reports to generate a single file output.

You may need to play with Excel Export properties to have each of the report in different tab

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.one.page.per.sheet

Best regards,
Andrew