[{"id":"4706db46-0811-4652-8f59-1e0a1da84758","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"ae60ae59-34f5-4f32-a8eb-243ed1457543","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"d5c67fd0-1145-482c-9113-97b492c44c18","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"2457f0e0-9e71-4860-a87d-065e0fb84f84","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"8f1271bb-2cd9-4f39-9897-c15b239ee7ab","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"a609a8fa-ab91-4c1d-a1c3-d209d0463303","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"133f4ca6-d951-4d65-a618-3dc6301266f7","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"5e40f6dc-caec-49d7-a1d0-be65f06815ba","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"2ce7b6b0-78aa-4e4b-bf8a-e4ba2f988298","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"677e13a7-6f3e-449f-986c-2c3a26f8d54f","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"b4a9eb15-94e5-48df-b218-a24138f0cf9c","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"bcb0874d-299b-448e-9552-9e9b25ef80dd","tags":[{"name":"更新","color":"orange","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"ba7e818e-4f6b-4211-b1ac-58e3bafcf439"}]},{"id":"3d4848c3-910f-4ffa-9153-60bb507334a9","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"2426c71d-8332-4cbd-a436-1ec4f8666464","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]}]
        
(Showing Draft Content)

模糊查询

功能概述

模糊查询是一种很方便的查询方式,用来查询符合某种指定格式的数据。比如想要查询销售大区中包含“ 西 ”字的数据,就可以使用模糊查询。

image2020-6-10_11-39-25.png

本节以内嵌数据集实现模糊查询为例,为您介绍如何在报表中实现模糊查询。

操作示例

1. 添加报表参数

打开报表设计器右侧的数据绑定面板,然后单击报表参数区域的添加,如下图。

image2020-6-10_11-30-29.png


然后如下图所示,编辑报表参数。

image2020-6-10_11-32-29.png

2. 创建内嵌数据集

(1)选择数据源WynDemoData 创建内嵌数据集。 将之前定义的报表参数传递给数据集内的查询参数。

单击数据筛选下查询参数右侧的列表按钮。然后单击添加项目添加一个查询参数,单击该参数右侧的小方块图标,选择表达式,如下图。

8-21-2019 11-24-57 AM.png

在弹出的查询参数编辑对话框中,双击报表参数下“ 销售大区 ”。右侧表达式则变成: {@销售大区} ,如下图。设置完成后,单击保存按钮。

image2020-11-2_16-33-45.png

(2)返回到数据集定义对话框,在查询语句栏目中输入SQL语句: select * from 销售明细 where 销售大区 like '%'+ @查询参数1 + '%' ,然后单击验证。验证成功后查询字段中将出现查询到的字段项目数量,最后单击确定保存数据集的定义。

image2019-8-21_11-38-28.png

3. 定义报表内容

image2020-11-2_16-35-19.png

4. 预览报表

输入“ 西 ”字,然后预览报表,即过滤出与西相关的数据。

image2020-6-10_11-39-25.png

type=info

提示

有关如何在组件上添加模糊查询,请您参见组件数据过滤