[Error in ORDER BY CASE WHEN Clause]

Have you tried enclosing your case inside a parentheses?

[Is there a way to make text bold in Jasper studio in these conditions?]

Have you tried creating a new style? Click on the style field in the report outline and create a new style, then once you have created that, right click on that new style and create and conditional style. In there you can put in an expression to make the field bold. then in your report text field in the properties window you can select the style you created.

[Font changes are ignored when generating a pdf from a .jasper file]

Have you tried making a style.

In your outline under styles right click and ad new style. In the properties of that syle change it to the font you would like. Then go to the text field on your report which you want to have that font and in the style tab select the style you created.

[Variable expression (date field)]

You could try adding this into a text field -

new SimpleDateFormat("dd-MM-yyyy HH:mm").format($V{Your Variable})

[How do you break a headline to the next page?]

You should be able to select what you want in the group header section.

You said you have got a group called headlines. You can create the group header (if you have not already) and in that band properties you can choose to start new page, reprint header on each page.

 

[How to resolve repetitive group header]

It looks like you have placed your static text in the group band of your report. You can add a column  header or page header and place your static text (Director, Favor, Percentage) in one of those bands.

 

[how to convert string date format to date format]

You can try using new date -

new Date(new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss").parse(dateField))

[How to transform DB date format for parameter class java.util.date]

Have you tried converting your date format in your SQL query?

I use the below in Oracle -

cast(iuv.time_out as date) betwen to_date($P{START DATE}, 'YYYYMMDD') and to_date($P{END DATE}, 'YYYYMMDD')

[problems with textfield]

Morning,

You can try ticking the remove line when blank box in SF{COUNTRY}.

[Summing the Wrong Column in Ireport]

Morning, without seeing your entire report all I can say is check the order of your variables, as ireport will calculate them in that order. Hope this helps.

[Change null in pivot from 0 to blank?]

Hi there,

Sorry I am unable to see your attachment. Can you try using a print when expression, for example print when $V{ANIMALS_MEASURE}>=1.

[[iReport substring] How to get last 2 digit of the year?]

Morning,

2 ways you can try. 1 is to change the formatting of the date in the textfield as per attached picture. 2 is try the following - $F{signDate}.substring($F{signDate}.length() - 2)

[How to format date for correct view in Excel]

Hi there,

Have you tried formatting your Oracle date 

select to_char(date_column,'dd.mm.yyyy') from table;

[How to convert String to Double in JasperStudio Reports?]

Hi there,

You can try the following - java.lang.Double.valueOf($F{YourString})

[How to set a time zone for a date parameter]

Hi there,

I had a similar situation where I needed the report to return the previous month. What I did was create a date parameter and then a second parameter which i have - DateUtils.addMonths($P{Date},-1) as the expression.

Hope this can help you out.

[repeating values in columns]

Hi there, 

When I have columns and rows in a crosstab I don't want visible I change the width or height of that row column to hide it from the resulted crosstab.'This might help you in your scenario.

[Error evaluating expression for source text]

Morning, have you tried using the report count variable and then selecting average as the calculation?

[Background image not appearing over Conditional styling]

If you right click the cell on your report you have an option of order where you can bring to front etc.

Have you tried this?

[Jasper Reports - ireport - timestamp to date]

Hi there,

In your text field Properties/Text Field you can select the Pattern, this will allow you to choose which date format you would like the text field to reutrn.

[Measure for selecting only certain non-numeric values (Jaspersoft Server 7.2)]

Hi there,

Sounds like you need to create a variable, below is the link to the Wiki -

https://community.jaspersoft.com/wiki/variables

When you crate the variable you can have the option in the Calculation field to have count or sum etc.

So for example you can create a variable with the Expression -

Boolean.valueOf($F{your field goes here}.contains ("closed") ? 1 : 0

This will give your field a value of 1 if it contains closed. Its hard to give an indepth example with what information you have given but hopefully this can point you in the right direction.

[get server current date]

In the Palette there is a compostie element called current date.

You can add this to your report as a text field and it will populate with the current date - new java.util.Date().

[Jasper Report Results and Query Results are not matching]

As gustavofarias stated above if you have a variable with a calculation you must ensure this is at the botom of your variable list as variables will be calulated in the order they are placed.

[Remove unwanted text from a string in Jaspersoft Server]

Try substring,

$F{yourfieldgoeshere}.substring($F{yourfieldgoeshere}.length() - 6)

Regards

Luke

[Multiple IF's in expression editor]

Try the below,

What it does is when the st_ctry_name is not Switserland and the seller is RET1 then return TEST MESSAGE else " " blank.

(!(Boolean.valueOf($F{st_ctry_name}.equals ("Switserland")) && Boolean.valueOf($F{seller}.equals ("RET1")))) ? "TEST MESSAGE" : " " 

Regards

Luke

[I lost my last report design when I open it again]

Double check you are opening the file saved in the MyReports folder C:UsersxxxJaspersoftWorkspaceMyReports.

You can always look at the details of the file and check the timestamp to ensure it is the latest one.