jasper dynamic sheet name

最新推荐文章于 2022-10-13 14:52:39 发布

liupu1106

最新推荐文章于 2022-10-13 14:52:39 发布

阅读量293

点赞数

本文链接：https://blog.csdn.net/lp1013139032/article/details/52063256

版权

1、get sheetName from code or web ui.

<parameter name="PARAMS_PROVIDER" class="com.citi.gfts.rptapp.jasper.writer.JRParamsProvider" isForPrompting="false"/>
<parameter name="P_FIN_PRES" class="java.lang.String">
	<defaultValueExpression><![CDATA[$P{PARAMS_PROVIDER}.getQueryParams().get("P_FIN_PRES")]]></defaultValueExpression>
</parameter>

2、add below part in jasper main report's pageHeader part.

<line>
	<reportElement x="0" y="0" width="1" height="1" uuid="141e6753-0b2c-4b74-be35-5826e4df4eb2">
		<propertyExpression name="net.sf.jasperreports.export.xls.sheet.name"><![CDATA[$P{P_FIN_PRES}]]></propertyExpression>
	</reportElement>
</line>