XLSX Export in Jasper Report

ReportServer (EN)
1
<?xml version="1.0" encoding="UTF-8"?> xlsx true

I have tried changing all possible values to make it xlsx but still report getting export is xls in Jasper Report.
Kindly help me to get exported in xlsx.

2

Hi shashank,

please take a look here:
https://forum.reportserver.net/viewtopic.php?id=689 , #7
XLSX support for Jasper will come with the next reportserver version

Cheers,
Eduardo

3

Thank you edulid.

Can you please tell me how to pass Date input parameter in dd-mm-yyyy format.
Currently it is yyyy-mm-dd format.

4

Hi shashank,

you need to pass the input parameter to what kind of report? jasper? dynamic list?
And why do you need this date format? How are you passing the values?

Cheers,
Eduardo

5

Hi edulid,
I am working on jasper report. I want date parameter in dd-mm-yyyy format bydefault it displays in yyyy-mm-dd format.
How can i change format of date.

6

Hi shashank,

you can format the date e.g. $P{time} by two ways:

  1. using jasper pattern, e.g.:
<textField pattern="MMMM d, yyyy">
	<reportElement x="170" y="7" width="100" height="30" uuid="0721bc74-f6b5-49e2-b3a2-eef4c2fa13ab"/>
	<textFieldExpression><![CDATA[[$P{time}]]]></textFieldExpression>
</textField>
  1. by using standard java formatters:
<textField>
	<reportElement x="170" y="7" width="100" height="30" uuid="0721bc74-f6b5-49e2-b3a2-eef4c2fa13ab"/>
	<textFieldExpression><![CDATA[[new java.text.SimpleDateFormat("dd.MM.yyyy hh:mm").format($P{time})]]]></textFieldExpression>
</textField>

You have to set the right format either in pattern=“MMMM d, yyyy” or in the textFieldExpression “dd.MM.yyyy hh:mm”.

Cheers,
Eduardo

7

Hi edulid,
Thank you,
But , i need to change date parameter(under parameter management) in report server into dd-mm-yyyy format not in jasper report date format

8

Hi edulid,
Please help me its urgent.
change date parameter in report server to dd-mm-yyyy format

9

Hi shashank,

try changing the file /etc/main/localization.cf:

<shortDatePattern></shortDatePattern>
<longDatePattern></longDatePattern>
<shortTimePattern></shortTimePattern>
<longTimePattern></longTimePattern>
<shortDateTimePattern></shortDateTimePattern>
<longDateTimePattern></longDateTimePattern>
<numberPattern></numberPattern>
<currencyPattern></currencyPattern>
<integerPattern></integerPattern>
<percentPattern></percentPattern>

Actually, the default shortDateFormat is: y-MM-dd.

Then you have to reload the configuration files: open the terminal CTRL+ALT+T and type “config reload”, or restart your reportserver instance.

Cheers,
Eduardo

10

Hi edulid,
Thank you,
it works properly