Home » Developer & Programmer » Reports & Discoverer » sales analysis by customer need to be ammended
sales analysis by customer need to be ammended [message #543793] Thu, 16 February 2012 19:25 Go to next message
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 1276 times)
Re: sales analysis by customer need to be ammended [message #543811 is a reply to message #543793] Fri, 17 February 2012 01:04 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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
Re: sales analysis by customer need to be ammended [message #543815 is a reply to message #543811] Fri, 17 February 2012 01:48 Go to previous messageGo to next message
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 1696 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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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).
Re: sales analysis by customer need to be ammended [message #543819 is a reply to message #543818] Fri, 17 February 2012 02:02 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 21806
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).
Previous Topic: How to see the output of reports in Textpad
Next Topic: Unable to Generate to File 'XML' in Character Mode
Goto Forum:
  


Current Time: Thu Mar 28 05:50:04 CDT 2024