OraFAQ Forum: Reports & Discoverer » sales analysis by customer need to be ammended

Home » Developer & Programmer » Reports & Discoverer » sales analysis by customer need to be ammended

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

sales analysis by customer need to be ammended [message #543793]

Thu, 16 February 2012 19:25

charanyevadu
Messages: 17
Registered: February 2012

Junior Member

Hi, iam having sales analysis by customer report. Using that i need to amend and get the sales analysis by salesmen report.

As the salesmen were already been there inside this report so have to get that report.I dont want all the fields in that report

jst need the layout as below..

Salesmen David Thomas George
Items
Furniture 1000 4322 3000
Automotive 2000 1000 500

Total
3000 5322 3500

This are the fields that are required rest off all dont want.

Iam attaching the original report as well

Attachment: XXOMSACU.rdf
(Size: 568.00KB, Downloaded 1640 times)

Report message to a moderator

Re: sales analysis by customer need to be ammended [message #543811 is a reply to message #543793]

Fri, 17 February 2012 01:04

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

Senior Member
Account Moderator

Quote:

This are the fields that are required rest off all dont want.

a) delete fields you don't need (from data model, paper layout, or both)
or
b) create format triggers for these fields - make them return FALSE

Report message to a moderator

Re: sales analysis by customer need to be ammended [message #543815 is a reply to message #543811]

Fri, 17 February 2012 01:48

charanyevadu
Messages: 17
Registered: February 2012

Junior Member

i have deleted all the fields that are not necessary, but crucial part for me is to change the logic.

right now the output is a follow, check out the attachment how my report layout looks like after deleting the fields,

Sales Men : DAVID FOO

Customer  : john
Furniture :  500$
Automotive : 250$

customer : george
Furniture : 200$ 
Clear Film: 50$

Customer : Peter
Furniture : 100$

But i need like to ammend like this

Salesmen : David Foo

Furniture                800$
Automotive               250$
Clear Film                50$

Total                    1100$

Attachment: XXOMSACU.pdf
(Size: 46.08KB, Downloaded 1997 times)

[Updated on: Fri, 17 February 2012 01:51]

Report message to a moderator

Re: sales analysis by customer need to be ammended [message #543818 is a reply to message #543815]

Fri, 17 February 2012 01:59

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

Senior Member
Account Moderator

Well, perhaps it would be easier to create a new report (rather than adjust the existing one to new requirements).

Report message to a moderator

Re: sales analysis by customer need to be ammended [message #543819 is a reply to message #543818]

Fri, 17 February 2012 02:02

charanyevadu
Messages: 17
Registered: February 2012

Junior Member

As i was not much experienced into reports its very hard for me to create a new report.

[Updated on: Fri, 17 February 2012 02:41]

Report message to a moderator

Re: sales analysis by customer need to be ammended [message #543872 is a reply to message #543819]

Fri, 17 February 2012 05:49

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

Senior Member
Account Moderator

Believe me, it is even more difficult to make an existing report do something different (or display output differently).

Report message to a moderator

Previous Topic:	How to see the output of reports in Textpad
Next Topic:	Unable to Generate to File 'XML' in Character Mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 17:11:23 CST 2025