General discussion

Locked

Crystal Report (Cross-tabs)

By Prem.Rajani ·
Hey guyz how can percentage of 2 columns be calculated in a cross tab? Any ideas or suggestions. Im using 8.5 so any features like that in version 9. if yed do let me know so i can purchase it. otherwise let me know the solution for it.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by D_Gilmour_1978 In reply to Crystal Report (Cross-tab ...

Do you want to display more than one column of data in your cross-tab? if so

Then this trick may help

Create a union query

instead of
select customer,region,salesvalue,margin from sales

use select customer,region, 'Sales' as Type, salesvalue as measure
from sales
union
use select customer,region, 'Margin' as Type, margin as measure

when you do you cross tab you can get 2 columns for each region if you were to put region as the first column group and then type as the second

It is rather messy but it is the best I have found so far

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums