#1 2017-03-28 10:03:06

shashank
Member
Registered: 2017-03-28

XLSX Export in Jasper Report

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <xls>
      <format>xlsx</format>
      <stream>true</stream>
   </xls>
</configuration>

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.

Offline

#2 2017-03-28 10:32:23

eduardo
Administrator
Registered: 2016-11-01
Website

Re: XLSX Export in Jasper Report

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

Offline

#3 2017-03-29 05:15:05

shashank
Member
Registered: 2017-03-28

Re: XLSX Export in Jasper Report

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.

Offline

#4 2017-03-29 07:19:08

eduardo
Administrator
Registered: 2016-11-01
Website

Re: XLSX Export in Jasper Report

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

Offline

#5 2017-03-29 09:59:31

shashank
Member
Registered: 2017-03-28

Re: XLSX Export in Jasper Report

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.

Offline

#6 2017-03-29 10:46:01

eduardo
Administrator
Registered: 2016-11-01
Website

Re: XLSX Export in Jasper Report

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>

2. 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

Offline

#7 2017-03-30 05:13:10

shashank
Member
Registered: 2017-03-28

Re: XLSX Export in Jasper Report

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

Offline

#8 2017-04-04 05:32:36

shashank
Member
Registered: 2017-03-28

Re: XLSX Export in Jasper Report

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

Offline

#9 2017-04-10 12:19:21

eduardo
Administrator
Registered: 2016-11-01
Website

Re: XLSX Export in Jasper Report

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

Offline

#10 2017-04-13 08:39:28

shashank
Member
Registered: 2017-03-28

Re: XLSX Export in Jasper Report

Hi edulid,
Thank you,
it works properly

Offline

Board footer

Powered by FluxBB