Web Development

Ask something
Discussion Locked

Crystal Report (Cross-tabs)

0 helpful
1 reply

by prem.rajani

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

1 reply

by d_gilmour_1978

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

This discussion is closed to new replies.