来自多个日期范围的iReport输入 [英] iReport Input from Multiple Date Ranges
问题描述
我正在使用iReport并希望能够接受4个日期输入(2个日期范围) dateRange1
和 dateRange2
。
I am using iReport and want to be able to take 4 date inputs (2 date ranges) dateRange1
and dateRange2
.
每个都将消除在尊重范围内给出的物品数量和成本。
Each will disaplay the amount of items and cost given within the respected ranges.
到目前为止我让第一个 dateRange1
正在运作,但我无法确定第二个日期范围。
So far I have the first dateRange1
is working but I am having trouble figuring out to implament the second date range.
这是我的代码和一些截图。
Here is the code I have along with some screenshots.
SELECT
COMPANY."NAME" AS COMPANY_NAME,
CUSTOMER."NAME" AS CUSTOMER_NAME,
SO."NUM" AS SO_NUM,
SOITEM."STATUSID" AS SOITEM_STATUSID,
PRODUCT."ID" AS PRODUCT_ID,
PART."NUM" AS PART_NUM,
SOITEM."QTYFULFILLED" AS SOITEM_QTYFULFILLED,
SO."COST" AS SO_COST,
PART."ID" AS PART_ID,
SO."DATECOMPLETED" AS SO_DATECOMPLETED,
CUSTOMER."ID" AS CUSTOMER_ID,
SOSTATUS."ID" AS SOSTATUS_ID
FROM
"CUSTOMER" CUSTOMER INNER JOIN "SO" SO ON CUSTOMER."ID" = SO."CUSTOMERID"
INNER JOIN "SOITEM" SOITEM ON SO."ID" = SOITEM."SOID"
INNER JOIN "SOSTATUS" SOSTATUS ON SO."STATUSID" = SOSTATUS."ID"
INNER JOIN "PRODUCT" PRODUCT ON SOITEM."PRODUCTID" = PRODUCT."ID"
INNER JOIN "PART" PART ON PRODUCT."ID" = PART."DEFAULTPRODUCTID"
AND PART."ID" = PRODUCT."PARTID",
"COMPANY" COMPANY
WHERE
UPPER(CUSTOMER."NAME") = $P{customerID}
AND SO."DATECOMPLETED" BETWEEN $P{From} AND $P{To}
之间设计视图的屏幕截图。
This wis a screenshot of the design view.
推荐答案
在Fishbowl中,您可以设置任何参数以包含单独的标题。这允许您多次使用相同类型的参数。
在日期范围的情况下,它用作$ P {dateRange1DateCreated} $ P {dateRange2DateCreated},然后第二个集合将是$ P {dateRange1DateModified} $ P {dateRange2DateModified}。
Within Fishbowl you can set any of the parameters to include a separate title. This allows you to use the same type of parameter multiple times. In the case of date ranges it's used as $P{dateRange1DateCreated} $P{dateRange2DateCreated} and then the second set would be $P{dateRange1DateModified} $P{dateRange2DateModified}.
这篇关于来自多个日期范围的iReport输入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!