[{"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)

日期范围过滤

功能概述

如果数据库中存有日期类型或日期时间类型的字段,那我们就可以实现按照日期范围进行数据过滤。

如下图所示,用户可以通过参数面板指定查询日期,然后预览对应的数据。

image

接下来以内嵌数据集为例为您介绍实现日期范围过滤的操作步骤。

操作示例

1. 添加报表参数

打开报表设计器,按照下图中所示添加两个报表参数。

image

2. 添加内嵌数据集

选择WynDemoData添加内嵌数据集。将报表参数传入数据集内部的查询参数。并将查询参数名称修改为开始截止。如下图所示。

image2020-11-2_16-9-49.png


输入 SQL 查询语句: select * from 销售明细 where DateDiff (d, @开始, 订购日期) >= 0 and DateDiff (d, @截止, 订购日期) <= 0 ,并验证确定。

image2020-11-2_16-16-30.png

3. 设计表格内容

具体如下图所示。

image

4. 预览报表

比如我们想要查询2017年4月最后10天的订单情况。那么选定日期后,单击“预览报表”即可查询出对应日期范围的数据。预览确认是我们需要的效果后,保存报表即可。

image