本文介绍了如何在jaspersoft studio中的jasper报表中的细节视图中以彼此相邻的方式显示图像而页面不增加?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
目前,同一图像在详细信息部分中彼此下方显示,并且页面乘以有多少图像.()
At the moment the same images is displaying under each other in the detail section and the pages multiply by how many images there is.()
这是我尝试过的代码(我在jaspersoft studio中做了):
This is the code I tried(I did in jaspersoft studio):
<detail>
<band height="111">
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.spreadsheet.SpreadsheetLayout"/>
<image hAlign="Left">
<reportElement x="0" y="0" width="390" height="111" uuid="8bf21ae9-eec4-4c39-b4c1-4c174ec59aab">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<imageExpression><![CDATA[$F{photo_blob}]]></imageExpression>
</image>
</band>
</detail>
这是sql脚本:
<queryString>
<![CDATA[select distinct job_card.job_card_name,
job_card.job_number,
job_card.job_type,
job_card.job_card_name,
client_account.account_name,
job_card.punchlist_comments,
"user".name,
job_card.customer_name,
job_card.created_at,
job_card.customer_signature_blob,
job_card.technician_signature_blob,
photograph.photo_blob
from $P!{schemaName}.job_card
left join $P!{schemaName}.photograph on $P!{schemaName}.job_card."_id_" = $P!{schemaName}.photograph.job_cards_fk
left join $P!{schemaName}."user" on $P!{schemaName}."user"."_id_" = $P!{schemaName}.job_card.technicians_fk
left join $P!{schemaName}.asset on $P!{schemaName}.asset."_id_" = $P!{schemaName}.job_card.assets_fk
left join $P!{schemaName}.client_account on $P!{schemaName}.client_account."_id_" = $P!{schemaName}.asset.clientaccounts_fk
where job_card._id_ = $P{job_cardUUID}::uuid
;]]>
</queryString>
<field name="job_card_name" class="java.lang.String"/>
<field name="job_number" class="java.lang.String"/>
<field name="job_type" class="java.lang.String"/>
<field name="account_name" class="java.lang.String"/>
<field name="punchlist_comments" class="java.lang.String"/>
<field name="name" class="java.lang.String"/>
<field name="customer_name" class="java.lang.String"/>
<field name="created_at" class="java.lang.String"/>
<field name="customer_signature_blob" class="java.awt.Image"/>
<field name="technician_signature_blob" class="java.awt.Image"/>
<field name="photo_blob" class="java.awt.Image"/>
推荐答案
对不起,同样的问题,同样的答案.
Sorry, same question, same answer.
这篇关于如何在jaspersoft studio中的jasper报表中的细节视图中以彼此相邻的方式显示图像而页面不增加?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!