Problem with cross columns
Posted: Thu Sep 04, 2008 11:59 pm
Hi,
I am using Cross table to design my reports. Cross tables seems pretty much complex to me.
I am displaying sales values supplied by suppliers and members for different quarters. I am gettings values by querry from different tables and creating one temporary table, which acts as a datasource to my report.
The report looks like:
Supp Name................Qtr1........................................Qtr2.........................................Qtr3.........................................Qtr4
.................SuppSales....MemberSales...........SuppSales....MemberSales........SuppSales......MemberSales....... SuppSales....MemberSales
aa................100.................200.....................100...............300.........................300.............300.......................400............200
bb................200.................300.....................200...............200.........................100.............200.......................300............300
Now I need to show % variances for each quarter. So the report should look like (similar for Qtr3 and Qtr4):
Supp Name.........................Qtr1 ....................................................Qtr2...................................................Qtr3...........................................Qtr4
.................SuppSales....MemberSales...Variance......... SuppSales.....MemberSales...Variance......... SuppSales...MemberSales............SuppSales...MemberSales
aa.................100.................200...............10%................100...............300..............20%.................300.............300.......................400............200
bb.................200.................300...............10%................200................200..............0%..................100.............200.......................300............300
Now if I set display total to true, it shows me total of Supplier and member for each quarter. But I need to show % variance.
If you want I can mail you the .mrt file which will make things clear.
Please help.
Thanks.
-Ash
I am using Cross table to design my reports. Cross tables seems pretty much complex to me.
I am displaying sales values supplied by suppliers and members for different quarters. I am gettings values by querry from different tables and creating one temporary table, which acts as a datasource to my report.
The report looks like:
Supp Name................Qtr1........................................Qtr2.........................................Qtr3.........................................Qtr4
.................SuppSales....MemberSales...........SuppSales....MemberSales........SuppSales......MemberSales....... SuppSales....MemberSales
aa................100.................200.....................100...............300.........................300.............300.......................400............200
bb................200.................300.....................200...............200.........................100.............200.......................300............300
Now I need to show % variances for each quarter. So the report should look like (similar for Qtr3 and Qtr4):
Supp Name.........................Qtr1 ....................................................Qtr2...................................................Qtr3...........................................Qtr4
.................SuppSales....MemberSales...Variance......... SuppSales.....MemberSales...Variance......... SuppSales...MemberSales............SuppSales...MemberSales
aa.................100.................200...............10%................100...............300..............20%.................300.............300.......................400............200
bb.................200.................300...............10%................200................200..............0%..................100.............200.......................300............300
Now if I set display total to true, it shows me total of Supplier and member for each quarter. But I need to show % variance.
If you want I can mail you the .mrt file which will make things clear.
Please help.
Thanks.
-Ash