You are not logged in.
Pages: 1
<?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
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
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
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
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
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
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
Hi edulid,
Please help me its urgent.
change date parameter in report server to dd-mm-yyyy format
Offline
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
Hi edulid,
Thank you,
it works properly
Offline
Pages: 1