OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » matrix report (9i/6i/xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

matrix report [message #422414]

Wed, 16 September 2009 04:34

conversing
Messages: 15
Registered: April 2006
Location: pakistan

Junior Member

hi gurus i want to generate report in the following format. can any body help me??

Attachment: report.csv
(Size: 0.17KB, Downloaded 1321 times)

Report message to a moderator

Re: matrix report [message #422418 is a reply to message #422414]

Wed, 16 September 2009 04:45

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Do you know how to create a matrix report (of any kind, not the one you've presented as a CSV file)?

Basically, create a query which fetches data you are interested in. Then copy it into Reports Developer and create groups which will represent "rows", "columns" and "cells". Let Wizard create a default layout (as well as summary fields). Finally, rearrange fields in Layout Editor.

Report message to a moderator

Re: matrix report [message #422420 is a reply to message #422418]

Wed, 16 September 2009 04:56

conversing
Messages: 15
Registered: April 2006
Location: pakistan

Junior Member

yes i can create simple matrix reports. i am able to create the report i mentioned upto the column of total (which are comming from sales table having pid as product id) but i am missing the secret of writing exact opening balances against each product(which are coming from opening_balance table having pid as product id)and at the end subtracting total sale from opening balance. hope you got my point

Attachment: report.csv
(Size: 0.17KB, Downloaded 1322 times)

Report message to a moderator

Previous Topic:	Crosstab reports in Discoverer
Next Topic:	Matrix Report - REP-1813:Object <object name> too large to fit in matrix cell

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 04:26:43 CST 2024