Home » Developer & Programmer » Reports & Discoverer » Output Discoverer report vertically rather than in a table??
Output Discoverer report vertically rather than in a table?? [message #250942] Wed, 11 July 2007 23:08 Go to next message
Vasco Pyjama
Messages: 1
Registered: July 2007
Location: Brisbane, AUSTRALIA
Junior Member
Hi Folks,

just starting with Discoverer Plus to develop some standard reports for my staff. Of course someone wants something other than a cleverly formatted spreadsheet output.

A standard report displays the output as a table-
headings A | B | C | D | E
row 1 .. a1| b1| c1| d1| e1
row 2 .. a2| b2| c2| d2| e2
row 3 .. a3| .. etc

Is it possible to generate a report that can display the output like below?? -

A a1
B b1
C c1
D d1
E e1
A a2
B b2
C c2
D d2
E e2
A a3

Have tried with crosstabs but it still comes out with a single instance table rather than an iterating list.

Can it be done?


Re: Output Discoverer report vertically rather than in a table?? [message #251334 is a reply to message #250942] Fri, 13 July 2007 00:47 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
If there is no other data to be shown on the report, then no, Discoverer can't do this. If you have some "measure/analytical/etc" data (numbers), than you can select those as datapoints in a matrix layout and have the other data at the left. But still the sorting will probably be hard, since there actually is no sorting except the sequence of the columns...

Best would be to create a view and have SQL do the work. Search for pivot on this site, to see how to do that.
Previous Topic: IMP ORACLE10G FILE (Materialized view problem)
Next Topic: Dynamic selection of columns for a report
Goto Forum:

Current Time: Tue Jun 27 04:08:59 CDT 2017

Total time taken to generate the page: 0.10358 seconds