| Report Doubt [message #178249] |
Tue, 20 June 2006 05:30  |
yram
Messages: 75
Registered: February 2001
|
Member |
|
|
Hi
I have three items 'aaa','bbb','xxx' which are in three different location id these values are stored in database...
Item Qty location Id
aaa 11 101
aaa 22 202
aaa 33 303
bbb 44 101
bbb 55 202
bbb 66 303
xxx 77 101
xxx 88 202
xxx 99 303
the O/p to be attained is ,
in this output the year 2001,2002,2003 are input... which are not stored in the database... they are used to display in the report...
Pls help me to attain this output...
year 2001 2002 2003
item 101 202 303
aaa 11 22 33
bbb 44 55 66
xxx 77 88 99
Regards
Yram
|
|
|
|
| Re: Report Doubt [message #178803 is a reply to message #178249] |
Thu, 22 June 2006 14:56  |
urchin556
Messages: 42
Registered: March 2005
Location: India
|
Member |
|
|
|
how you will know which quantity belongs to which year?? There must be some column through which ur determining that.Its a simple matrix report if u figure out the year column
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
