OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » change in layout

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

change in layout [message #545150]

Mon, 27 February 2012 09:36

charanyevadu
Messages: 17
Registered: February 2012

Junior Member

I am having a report its layout is as below

Customer : F_1

         Sales men :          F_2
                      
  F_3(CF_STK_TYPE_DESC)       F_4

OUTPUT:


Customer :  David


         Sales men :     Thomas

Furniture                100
Automotives               50
Textiles                  20
Mobiles                   10

         Sales men :    Daniel

Furniture                 30
Textiles                  10
Ship                      20

Customer : George


         Sales men :      Thomas

Furniture                 20
Mobiles                   50


         Sales men :    Daniel

Furniture                 10
Mobiles                   20

But i need the output as below


      Salesmen :      Thomas        Daniel

Furniture                120           40
Automotives               50           
Textiles                  20           10
Mobiles                   60           20
Ship                                   20

So i need to change the fields in such a way to compare for all the customers based on items and to add them.

Can anyone help me clearly to write the formula for the field in order to do so.

[Updated on: Mon, 27 February 2012 09:39]

Report message to a moderator

Re: change in layout [message #545154 is a reply to message #545150]

Mon, 27 February 2012 10:54

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

Senior Member
Account Moderator

That would be a matrix report. Create a query that selects values you need; use a wizard which will guide you through a process of creating such a layout.

Report message to a moderator

Re: change in layout [message #545186 is a reply to message #545154]

Mon, 27 February 2012 18:51

charanyevadu
Messages: 17
Registered: February 2012

Junior Member

Its not abt the layout i was suppose to sum the same items for each salesman which belongs to all the customers

Report message to a moderator

Re: change in layout [message #545223 is a reply to message #545186]

Tue, 28 February 2012 00:23

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

Senior Member
Account Moderator

Well, "output" and "I need the output" seem differently to me (so I'd say that it *might* be a different layout).

Report message to a moderator

Re: change in layout [message #545225 is a reply to message #545223]

Tue, 28 February 2012 00:36

charanyevadu
Messages: 17
Registered: February 2012

Junior Member

Why can't we add a field like summary column and write a logic in that like if the same item for a same sales person add it.(i won't think so we can write in summary column but like summary column can we use some other or write a FORMULA columnm.

Report message to a moderator

Re: change in layout [message #545227 is a reply to message #545225]

Tue, 28 February 2012 00:50

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

Senior Member
Account Moderator

Did you try?

Report message to a moderator

Re: change in layout [message #545240 is a reply to message #545227]

Tue, 28 February 2012 01:46

charanyevadu
Messages: 17
Registered: February 2012

Junior Member

i don't know how to write the formula.if can able to write the formula my job will be done almost..

Report message to a moderator

Re: change in layout [message #545245 is a reply to message #545240]

Tue, 28 February 2012 02:03

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

Senior Member
Account Moderator

If you chose the "formula column" approach, then forget about Reports Builder for a moment.

Open SQL*Plus (or any other tool you use) and write a query (or PL/SQL program unit) which will calculate a value you are interested in. Once you manage to do that, copy/paste its code into Report Builder's Formula column.

Report message to a moderator