Total

[jayanthi]

Hello,

I have cross tab which has column Total, but it displays total of crosstab1_sum1 and crosstab1_sum2.
1. I need to display the sum of crosstab1_sum1 and crosstab1_sum2 in CrossTab1_ColTotal1
2. Also i need to show sum of CrossTab1_ColTotal1 at the end of cross tab report.

Please give me an idea

Regards
Jay

[Andrew]

Hello,

Could you provide us with more information how do you create the crosstab. What are fields and how many of them do you use?

Thank you.

[jayanthi]

Thanx for your reply.

I have a table tbl_days with columns days(int), TripType(string), TimeIn(int), TimeOut(Int)

1. Cross tab layout is: days under Rows, TripType under Columns, Count of TimeIn,TimeOut under Summary.

2. Cross tab style is TripType in column wise, days in row wise, Count of TimeIn as In, Count of TimeOut as Out GROUP BY days,TripType

3. Have Cross-Column Total (CrossTab1_ColTotal1) which displays Total of In,Out separately but i need to display Total of In and Out as single value.

eg:

Total
------
3|2
2|0
1|1
has to be displayed as like

Total
------
5
2
2

4. also at the i need the sum of total as 9

Regards
Jay

[Andrew]

Hello,

Can you explain: do you want to output the TimeIn and TimeOut rows as separate values or to output as one value?

Thank you.

[jayanthi]

Hai,

I need TimeIn,TimeOut ouput as separate values, but the total as single value.

Eg:

Note: '--------' used for space

Trip Type-------------General----------Night-------Total
------------------------In--------Out------In-----Out
-----------------------------------------------------------------------------------------
1-----------------------1---------0--------1-------1--------2|1
2-----------------------1---------1--------0-------0--------1|1
3-----------------------1---------1--------1-------1--------2|2
4-----------------------0---------0--------1-------1--------1|1
....
30----------------------0---------1--------1-------1--------1|2

In above Total is Sum of In| Sum of Out, but i need to print as Sum of In+Sum of Out, also i need final total at the end like below

Trip Type-------------General----------Night-------Total
------------------------In--------Out------In-----Out
-----------------------------------------------------------------------------------------
1-----------------------1---------0--------1-------1--------3
2-----------------------1---------1--------0-------0--------2
3-----------------------1---------1--------1-------1--------4
4-----------------------0---------0--------1-------1--------2
....
30----------------------0---------1--------1-------1--------3

-----------------------------------------------Total---------14

Jay

[Andrew]

Hello,

Unfortunately, it is impossible to this using the cross-tab but you may get the table like this
Trip Type-------------General----------Night-------Total
------------------------In--------Out------In-----Out
1-----------------------1---------0--------1-------1--------2|1
2-----------------------1---------1--------0-------0--------1|1
3-----------------------1---------1--------1-------1--------2|2
4-----------------------0---------0--------1-------1--------1|1
....
30----------------------0---------1--------1-------1--------1|2
Please, select the horizontal order of Summary fields output (there is a button in the cross-tab designer).

Thank you.