| Output Discoverer report vertically rather than in a table?? [message #250942] |
Wed, 11 July 2007 23:08  |
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
etc
Have tried with crosstabs but it still comes out with a single instance table rather than an iterating list.
Can it be done?
Cheers
V
|
|
|
|
| Re: Output Discoverer report vertically rather than in a table?? [message #251334 is a reply to message #250942] |
Fri, 13 July 2007 00:47  |
skooman
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
