I am developing a ASP.NET web Application using NAV webservices. I need to show Item wise sale for every month. for that i retrieve data from ILE with Entry Type=Sale filter. Now I want to show data in following manner -
Item No.| JAN | FEB | MAR | Apr | May | JUN |JUL | AUG
IT-0001 | 250 | 500 | 700 | 900 |
IT-0002 | 500 | 700 | 900 |…
How do i do this.
Plz give any suggestion or solution or help.