Home » Developer & Programmer » Reports & Discoverer » change in layout
change in layout [message #545150] Mon, 27 February 2012 09:36 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21561
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.
Re: change in layout [message #545186 is a reply to message #545154] Mon, 27 February 2012 18:51 Go to previous messageGo to next message
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
Re: change in layout [message #545223 is a reply to message #545186] Tue, 28 February 2012 00:23 Go to previous messageGo to next message
Littlefoot
Messages: 21561
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).
Re: change in layout [message #545225 is a reply to message #545223] Tue, 28 February 2012 00:36 Go to previous messageGo to next message
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.
Re: change in layout [message #545227 is a reply to message #545225] Tue, 28 February 2012 00:50 Go to previous messageGo to next message
Littlefoot
Messages: 21561
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try?
Re: change in layout [message #545240 is a reply to message #545227] Tue, 28 February 2012 01:46 Go to previous messageGo to next message
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..
Re: change in layout [message #545245 is a reply to message #545240] Tue, 28 February 2012 02:03 Go to previous messageGo to next message
Littlefoot
Messages: 21561
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.
Re: change in layout [message #550072 is a reply to message #545245] Thu, 05 April 2012 14:35 Go to previous messageGo to next message
Sticker Printing
Messages: 7
Registered: March 2012
Location: USA
Junior Member
Is there is any simple way to write formula?
Re: change in layout [message #550074 is a reply to message #550072] Thu, 05 April 2012 14:37 Go to previous message
Littlefoot
Messages: 21561
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, with a pencil.
Previous Topic: Reference fields in detail group at report level
Next Topic: generate PDF 11g
Goto Forum:
  


Current Time: Wed May 27 18:39:42 CDT 2020