[Increasing the input control label characters more than 100]

Hi Hozawa , 

Thanks for the answer. Actually I am looking for some solution even if it is inneed of editing some CSS file. Since I am new to the server setting , I am struggling to find out the right CSS file for this.

Can you please tell me which CSS file ?? 

 

[Increasing the input control label characters more than 100]

Dear All,

I want to have an input control name more than 100 characters like below

"Select the right option( Based on your selection the following parameters will display the values from database XXX ) : "

Is there any option to increase the no of characters ?  Please sugges

[Sorting issue when special charcter is there in the text value]

Thanks for the valueable inputs. 

I have tried these and finally ended up accepting the default behavior of Jaspersoft sorting.

1)Changing the encoding in server level - but didnt work

2)Moving the sort order to query - it works but my report requirement (Crystal report vs Jasper comparison )

In addition , It is a comparison between Crystal and Jasper reports. These two never gets same sort order even if the sorting is moved to query. 

 

[Sorting issue when special charcter is there in the text value]

I am facing an issue with sorting the data when special character is there in the text value

My data looks like the below ,
Column name : Data
1.Value Sort 1
2.ValueSort1
3.Value!Sort1
4.Value#Sort1
5.Value_Sort1

I have sorting field "Data" set to Ascending

It sorts like the below,

1.Value_Sort1
2.Value!Sort1
3.Value#Sort1
4.ValueSort1
5.Value Sort 1

The encoding is UTF-8. 

Expected output:

1.Value Sort 1
2.Value!Sort1
3.Value#Sort1
4.Value_Sort1
5.ValueSort1

Any idea why it is happening like this?
 

[Jasper server TIME ZONE Conversion issue]

Dear All,

I have an issue with the time zone conversion in one of my report.

Database Timezone : UTC

Jasperserver Timezone - UTC

Data source setting : Use database setting - in this case , it is UTC.

I have start date and end date in query which are passed as parameter. even the start time and the end time.

I have  Comapre_date from date base which has to be comapred with the start date/time and end date/time after converting it into CET.

I use this conversion  (FROM_TZ(CAST(Compare_dt AS TIMESTAMP), 'UTC') AT TIME ZONE 'CET' BETWEEN start_dt AND .end_dt)

but the conversion is not happening . It remains the same from database. Is there any issue with this conversion and the jasper time zone??

If I login using "CET" in jasper server , the conversion happening. Anyone has any suggestions why it is happening like this?

 

Regards,

Bala