Home » Developer & Programmer » Reports & Discoverer » reports
reports [message #306425] Fri, 14 March 2008 02:41 Go to next message
Messages: 8
Registered: March 2008
Junior Member
how to generate a matrix report manually
specify each and every step
Re: reports [message #306441 is a reply to message #306425] Fri, 14 March 2008 04:04 Go to previous messageGo to next message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What's wrong with matrix report generated by Wizard?

If you are interested how it is done, create one with Wizard's help and then "debug" it - see what frames are created, which objects are there etc. and you'll probably find out how to do it manually.

I *always* use Wizard. Report is not a "beauty", but it is much easier to move fields when everything is prepared than doing the whole job from scratch. But hey, you may play around if you have enough time!
Re: reports [message #307958 is a reply to message #306441] Thu, 20 March 2008 09:40 Go to previous message
Messages: 43
Registered: January 2008
follow this steps:

1) first take the query like
select empno,deptno,to_char(hiredate,'yyyy') year from emp;
2) From this data in data-model select deptno as row field
3) year column as column field.
4) Take the cortision product for this fields.
5) Now go for layout-model.
6) IN this take the mail frame, next take the repeating frame
for deptno row field,here go to property pallet make the
source as deptnogroup & vertical property expand ,disply as
down. Here take one field for disply deptno's.
7) as same as the above make take the another repeating frame
make the source as yeargroup & horigental expand, disply an
across. Here take one field for disply year's.

Cool Here is this step is very careful,
press ctrl button in key-board & now select the deptnogroup
repeating frame as well as the yeargroup repeating frame
now the main menu item I think in view menu item or in insert
menu item U can find matrix layout then select that option.
9) take one repeating frame in between this two repeating
frame make the source as empnogroup & horizentally
expand & disply down/across,Here is small indication that when
you are selected this
repeating frame this repeating frame not moves from this
two repeating frames be sure this step. otherwise it is not
correct out put for U.
IF you are perfect all the above aspects then take the one
field to disply empno

ok this is the solution as per my knowledge
U got the answer as per matrix requirement inform me
if it is wrong if any changes in this inform me
ok byeee.
Previous Topic: How to handle a string of 10,000 chars in oracle reports
Next Topic: Reports 6i
Goto Forum:

Current Time: Tue Oct 25 00:12:54 CDT 2016

Total time taken to generate the page: 0.16953 seconds