on 08-01-2016 9:48 AM
Hi Experts,
One of our clients is running SAP Business One, Version for SAP HANA. They have an Annual Production Report which shows the amount of Item Gruops produced (Kgs) per month in a certain year. This is a simple query output; it shows Item Groups received for the month of January=1
However, I would like some guidance on how to achieve this below. Group Name and Summmed Quantities are tranposed to Columns
Kind Regards,
Pascale.
Solved
Decided to create crosstabs using crystal reports. It produced the intended report
Learn more about crosstabs here:
Kind Regards,
Pascale.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
109 | |
15 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.