Discussion Locked

oracle query to pull out 12 months usage of exisiting reports

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi,
I am trying to create a report which displays past 12 months usage count of all existing report. i am grouping the report type( id) and i want all 12 months across the report in a single line for each grouped report with count of usage in each month. presently i could write one but since i grouped by month under the reprot type group this display differnt rows for each month for same report. where in i need in single line.
for eg. the format i am looking for is like this
usg in
Report type Jan Feb Mar.........Oct Nov Dec
----------------------------------------------
A1 5 2
A2 4

I am writing this in oracle pass trhu query for acesss front end design report.

Can anybody please help...

but the format i am getting now is
Report type Jan Feb Mar....
------------------------------------
A1 5
A1 2
A2 4

1 reply

This discussion is closed to new replies.