[Images not loading into JasperServer reports]

What user are you trying to execute the report as? Only superuser can see absolute path to resources, like /organizations/org_name/path/to/resource/

To make report available for the user from the organization, you need to specify relative path to the resource. If the absolute path is repo:/organizations/org_name/path/to/resource/ then relative path would be repo:/path/to/resource/

[Pattern Expression]

There are a bunch of approaches, which depend on your java knowledge. For example, expressions:

A)

String.format("%.2f", new BigDecimal(Double.parseDouble($F{sample})))[/code]

B)

new DecimalFormat("0.00").format(new Double($F{sample}))[/code]

where $F{sample} is a field from dataset, that contains numbers. I used sample query: 

select '25.45060506506456' as sample[/code]

Also, attaching report.

[Formatting date with additional String text]

Hozawa's answer is correct, but to be more specfic to your requirements you need below expression: 

"Report created " + new SimpleDateFormat("MM/dd/yyyy hh:mm:ss a z").format(new java.util.Date())[/code]

Here's you find more information about date format patterns: https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

[Negative numbers in Bar Chart]

what is the problem? if field used as a measure in your dataset contains negative values, they will be displayed in a chart. Can you describe your usecase in more details?

[JasperStudio variable for crystal report]

Not being familar with crystal reports, this is not much helpful. Can you specify what are you trying to acheive?

 

As I understand you are trying to build date out of three integers. Is that correct?

[How to combine the two line table header into one row in excel?]

Hi, can you post here some screenshots or sample xls export of your current and expected behavior?

Regards,
Pavlo

[How to display detail band based on condition in jasper report]

You can define printWhenExpression for detail band. For example,

<detail>    <band height="30" splitType="Stretch">    <printWhenExpression><![CDATA[<place your condition here>]]></printWhenExpression>     ...     ...     ...    </band></detail>[/code]

[Need help with formatting date fields in an expression]

Hi,

I had to play around a bit, but was able to achieve your desired result. I have created parameter:

    <parameter name="cal" class="java.util.Calendar" isForPrompting="false">        <defaultValueExpression><![CDATA[Calendar.getInstance()]]></defaultValueExpression>    </parameter>[/code]

and variable:

<variable name="newDate" class="java.util.Date"><variableExpression>    <![CDATA[        (        $P{cal}.set($F{birthdate}.getYear()+1900, $F{birthdate}.getMonth(), $F{birthdate}.getDate()) ||        $P{cal}.add(Calendar.DATE, 6)        )        ? null : $P{cal}.getTime()     ]]></variableExpression></variable>[/code]

Result looks like that: http://prntscr.com/m8xtdz

I'll attach sample report with sample data. You should be able to run it without any issues. Let me know if this fits your requirements :)

[HTML5 Chart - Problem displaying data]

If i understood you correctly, this is something you want to acheive: http://prntscr.com/lllkox

If so, I have attached sample report to my original answer. I hope this helps.

[Problem with rendering the Dashboard]

You are using report rendering function for rendering dashboards - That's the problem. You should be using v.dashboard. For example:

visualize({    auth: {        name: "jasperadmin",        password: "jasperadmin",    }}, function (v) {    var dashboard = v.dashboard({        resource: "/public/Workshop/Profit_Dashboard",        container: "#container"    });});[/code]

 

[Uploading Report Error | Please contact your system administrator. (6632)]

As you might notice in logs, your issue is thrown by SQL Validator. By default it does not allow some SQL queries for security purpose. You can edit security configuration options to allow specific SQL or disable the validation completely:

1 - The following regex fix should work for most cases.

In this file: webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties/validation.properties  

Validator.ValidSQL=^s*(?i)(withs+.*)?(select|call|exec(ute)?)s+[^;]+$[/code]

2 - Alternatively turn it off here: webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties  

security.validation.sql.on=false[/code]

 

[Automatic movement element jaspersoft studio]

As far as I understand, export to DOC creates tables in table. So from Word perspective if you remove the first page table, you just remove the content of outer table. That is why it doesn't automatically occupy free space, as in fact the space isn't free - it is reserved by first row of outer table. So, if you want to delete the first page table, you also might want to delete the row in outer table. I tried to screencast it. Hope this helps: https://www.screencast.com/t/oQxkgriDDgsV

[HTML5 Chart - Problem displaying data]

As I understand the problem is you see two charts, while you should be seeing only one. In this case the problem is that you put the chart in detail band. Everything present in detail band is printed as many times as there are rows in dataset. If you had 100 rows in dataset, you'd end up with 1000 charts :)

Another issue you might experience would be Caused by: net.sf.jasperreports.engine.JRRuntimeException: Error incrementing bidimensional dataset.

What I would suggest - place Chart into Summary band.

[Jaspersoft Reporting on AWS Postgres schema not showing when creating domain]

are you able to connect to this db using any sql client just to test if db is working? I mean, looks like schemas are missing at all.

Use this article as guide for working with db: https://aws.amazon.com/getting-started/tutorials/create-connect-postgresql-db

 

[Resource cannot be located by jasper library.]

Can you upload jrxml file of your report?

[Ad-hoc on domain. Change displayed date format]

You can set this in Adhoc Editor itself by right clicking on Date field, like this: http://prntscr.com/li80om

Also, you can do same thing on Domain level by editing field Data format in Display tab: http://prntscr.com/li81ge

[How to hid the Domain Search button when embedded the Ad Hoc report writer?]

What you can do here - is to edit theme applied on server. Look at the result: http://prntscr.com/li7o2r

Basically, edit or add overrides_custom.css file to theme with something like that:

span#topicMutton.button.mutton {    display: none;}[/code]

And upload it to theme. Here's the screencast to demonstrates how it works: https://www.screencast.com/t/BeMr6s4XnAPN

[Jaspersoft Reporting on AWS Postgres schema not showing when creating domain]

Usually, when you open Domain Designer, it should pop-up what schema to use, like this: https://prnt.sc/li78o3

In your case, can you please in Domain Designer on Tables view, click on Data Source selected: http://prntscr.com/li79bj

It should open pop-up Manage Data Source. Click on Select Schemas..: http://prntscr.com/li79sj . "Select DB Schemas" pop-up should appear.

 

[Evaluation Time in Group Headers?]

GROUP means that an expression should be evaluated after each group break.

NOW specifying that an expression should be evaluated at the exact moment in the filling process when it is encountered.

 

This is covered in the JasperReports API documentation:

http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/type/EvaluationTimeEnum.html