I'm having problems with creating a custom report. I have the query and it produces data
SELECT
a.RUN_DATE,
b.PROC_NAME,
a.SM1_COUNT
FROM OPS_SUMMARY_LOG a
LEFT JOIN OPS_DIM_PROCESS b
ON a.PROC_ID = b.PROC_ID
WHERE a.PROC_ID = 1 AND RUN_DATE > (SysDate - 30)
ORDER BY a.RUN_DATE, b.PROC_NAME
| 17-DEC-13 | TSYS DATA | 463 |
| 18-DEC-13 | TSYS DATA | 160 |
| 19-DEC-13 | TSYS DATA | 229 |
| 20-DEC-13 | TSYS DATA | 159 |
| 24-DEC-13 | TSYS DATA | 485 |
| 26-DEC-13 | TSYS DATA | 327 |
| 27-DEC-13 | TSYS DATA | 62 |
| 31-DEC-13 | TSYS DATA | 294 |
| 02-JAN-14 | TSYS DATA | 252 |
| 03-JAN-14 | TSYS DATA | 61 |
| 07-JAN-14 | TSYS DATA | 401 |
| 08-JAN-14 | TSYS DATA | 116 |
| 09-JAN-14 | TSYS DATA | 190 |
| 10-JAN-14 | TSYS DATA | 163 |
I create the chart report but it never plots the data.
Please help.