| i want to prepare finacial year report [message #339134] |
Wed, 06 August 2008 20:27  |
radhavijay
Messages: 29
Registered: July 2008
|
Junior Member |
|
|
hi,
i want to prepare a financial year report in po module.
my report is in the below format
product/month july08 aug08 sep08.........jun09 total
abc
quantity 10 10 10 30
amount 5 5 5 15
xyz
quantity 20 20 20 60
amount 10 10 10 30
and so on
runtime parameters are date range
nw im retriving amount n quantity group by productname
but im not getting how to place these quantity n amount values in particular month columns.
suppose if i give parameters as 01-jul-08 and 01-sep-08
if quantity n amount values are between 01-jul-08 and 31-jul-08 then those must place in july08 column and if values are between 01-aug-08 and 31-aug-08 then values must be stored in aug08 column.
hw to do this
please help me.
thanks in advance
radhavijay
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
]