Вопрос по jasper-reports, sql – «Свертывание» групп в Jaspersoft iReport

0

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
Error: User Rate Limit Exceeded mdahlman
Error: User Rate Limit Exceeded Lisa

Ваш Ответ

2   ответа
2

Error: User Rate Limit Exceeded

WHERE   ($P{PGM_NAME} IS NULL OR job.pgm_name = $P{PGM_NAME})
AND     ($P{USER_NAME} IS NULL OR details.username = $P{USER_NAME})

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded Lisa
Error: User Rate Limit Exceeded Lisa
3

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

Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded Lisa
Error: User Rate Limit Exceeded Lisa
Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded Lisa

Похожие вопросы