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