您的位置: 首页  >  技术问答  >  Jasper Reports：根据字段值动态显示图像

Jasper Reports：根据字段值动态显示图像

分类: 技术问答 • 2022-07-26 09:52:54
问题描述：

我正在使用Jasper Reports和iReport来生成我的应用的报告。我需要根据对数据库的查询在报告中显示图像。图像是计划，其他字段代表测量等。

I'm using Jasper Reports and iReport to generate the reports of my app. I need to show images in my report depending on a query on my database. The images are plans and have other fields inside representing measurements, etc.

I.E。有两个图像：IMAGE1和IMAGE2链接到Field_ONE和Field_TWO。

I.E. With two images: IMAGE1 and IMAGE2 linked to Field_ONE and Field_TWO.


  • 如果Field_ONE是！= null，那么我想在文档中显示IMAGE1和图像内的字段;

  • If Field_ONE is != null then i whould like to show IMAGE1 and the fields inside the image in the document;

如果Field_TWO是！= null且Field_ONE等于null，那么我想在之前显示IMAGE1

If Field_TWO is != null and Field_ONE is equal to null then i want to show IMAGE2 in the place where previously showed IMAGE1

如果Field_TWO是！= null而Field_ONE！= null则我想并排显示IMAGE1和IMAGE2。

If Field_TWO is != null and Field_ONE != null then i want to show IMAGE1 and IMAGE2 side by side.

请注意，我可以有5或6张图片，因此如果不使用标记而在它们之间留下空格，则很难涵盖所有可能性。

Note that i could have 5 or 6 images, so it would be really difficult to cover all the possibilities without leaving blank spaces between them only using tag.

简而言之：我需要类似Android中的布局，我可以根据字段动态添加计划，并按照添加计划的顺序生成图像及其相关字段。

In short: i need something like the layout in Android where i can add the plans dynamically depending on the fields and generate the images and their associated fields in the order i added the plans.

我希望你能提供帮助，谢谢！

I hope you can help, thank you!

注意：我可以有多个相同类型的图像，具体取决于报告的结果，所以几乎不可能用图层覆盖它

Note: I could have more than one image of the same type depending on the result of the report, so it's almost impossible cover it with layers

答

图层（静态）解决方案


  1. 将问题划分为案例。例如，案例1显示图像1，案例2显示图像2和3，案例3显示图像4等...

  2. 对于i到n（对于n个案例）


    • 为案例i创建所有元素。

    • 添加一个新图层，即图层i。如果隐藏了图层窗口，请转到窗口>图层。

    • 选择添加的元素，右键单击发送到图层。选择图层i。

    • 右键单击图层窗口中的图层，然后更新表达时打印。例如， $ F {Field_ONE}！= null

    • 重复。仅供参考，您可以单击图层上的眼睛（在图层窗口中）隐藏适用的元素以隐藏杂乱。

  1. Divide the problem into cases. For example, case 1 show image 1, case 2 show images 2 and 3, case 3 show image 4 etc...
  2. For i to n (for n cases)
    • Create all the elements for case i.
    • Add a new layer, Layer i. Go to Window > Layers if the Layers window is hidden.
    • Select the elements added, right click and Send to layer. Choose layer i.
    • Right click on the layer in the Layers window and update the Print When Expression. For example, $F{Field_ONE} != null
    • Repeat. FYI, you can click on the eye on the layer (in the Layers window) to hide the applicable elements to hide the clutter.

子报告（动态） ）解决方案


  1. 创建一个报告，让我们称之为子报告。


    • 将页面的宽度和高度设置为给定记录的图像部分的高度和宽度。

    • 将所有页边距设置为0

    • 将报告列更改为您想要在一行中包含的图像数。

    • 将打印订单更改为水平

  1. Create a report, lets call it subreport.
    • Set the width and height of the page to be the height and width of your image section for a given record.
    • Set the all of the page margins to 0
    • Change the column of the report to the number of images you'd like to have in a single row.
    • Change the print order to 'Horizontal'

  • 将原始报告中的字段链接到子报告中＃2中创建的参数。

在我测试之前，我不想发布此解决方案。如果有不清楚的地方，我可以发布我的样本，它有很多行。您需要子报表的原因是您的主报表有1列并垂直填充，但您需要将图像水平填充多列。对于非null的每个字段，子报表查询将以语句顺序返回记录。然后该记录将填入各列。

I didn't want to post this solution until I tested it. I can post my sample, which has many lines, if there is something unclear. The reason you'll need a subreport is because your main report has 1 column and fills vertically but you need the images to fill horizontally across multiple columns. For each field that is not null, the subreport query will return a record in the statement order. The record will then be filled across the columns.

相关推荐