«Свертывание» групп в Jaspersoft iReport
Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded
SELECT
FAC.FILL_MONTH AS FILL_MO,
FAC.PHAR_CODE AS PHAR_CODE,
FAC.FAC_ID AS FAC_ID,
FAC.PACKTYPE_CODE AS PACKTYPE,
SUM(FAC.TOT_RXCOUNT_NUM) AS RX_COUNT,
SUM(FAC.TOT_REVENUE_AMT) AS REVENUE,
SUM(FAC.TOT_COGS_AMT) AS COGS,
SUM(FAC.TOT_MARGIN_AMT) AS MARGIN
FROM
MySchema.Table FAC
WHERE
FAC.FILL_MONTH BETWEEN $P{startdate} AND $P{enddate}
AND $X{IN, FAC.PHAR_CODE, pharmacy}
AND $X{IN, FAC.FAC_ID, facility}
AND $X{IN, FAC.PACKTYPE_CODE, packtype}
GROUP BY
FAC.PHAR_CODE,
FAC.FAC_ID,
FAC.PACKTYPE_CODE,
FAC.FILL_MONTH
ORDER BY
PHAR_CODE ASC,
FAC_ID ASC,
PACKTYPE ASC,
FILL_MO ASC
Ответы на вопрос(2)
Решение Вопроса
Error: User Rate Limit ExceededPACKTYPEError: User Rate Limit ExceededPACKTYPE.
Error: User Rate Limit Exceeded$P{PACKTYPE_SELECT_SQL}Error: User Rate Limit Exceeded$P{packtype}Error: User Rate Limit Exceeded$P{packtype}Error: User Rate Limit Exceeded$P{PACKTYPE_SELECT_SQL}Error: User Rate Limit Exceeded
$P{packtype}==null ? " 'All Package Types' " : " FAC.PACKTYPE_CODE "
Error: User Rate Limit Exceeded
SELECT
FAC.FILL_MONTH AS FILL_MO,
FAC.PHAR_CODE AS PHAR_CODE,
FAC.FAC_ID AS FAC_ID,
$P!{PACKTYPE_SELECT_SQL} AS PACKTYPE,
...
WHERE
FAC.FILL_MONTH BETWEEN $P{startdate} AND $P{enddate}
AND $X{IN, FAC.PHAR_CODE, pharmacy}
AND $X{IN, FAC.FAC_ID, facility}
AND $X{IN, FAC.PACKTYPE_CODE, packtype}
Error: User Rate Limit Exceeded$P{packtype}Error: User Rate Limit Exceeded$P{packtype}Error: User Rate Limit Exceeded
Error: User Rate Limit ExceededPACKTYPEError: User Rate Limit Exceeded
Error: User Rate Limit Exceeded