Home > Archive > Visual Basic Crystal Reports > March 2006 > Cross tab columns more than 2 fields
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cross tab columns more than 2 fields
|
|
| afang 2006-03-21, 10:09 pm |
| Hi all,
I have a problem with cross tab. I have 3 field such as region, gender,
and status.
I want to make cross tab like this
Female Male Single Married
America 10 5 12 3
Indonesia 6 9 10 5
Female and male are from gender. Single and married are from status.
So, does anybody know how to make that cross tab in crystal report.
Thank you for your help
| |
| Luqman 2006-03-24, 7:11 pm |
| Create One Temp Table, and copy all the records of Gender and Status to that
Table, now use that Table in Crystal Report.
You can also create a stored procedure for this, and use in your Crystal
Report.
Best Regards,
Luqman
"afang" <khokimfang@gmail.com> wrote in message
news:1142996414.809843.127960@u72g2000cwu.googlegroups.com...
> Hi all,
>
> I have a problem with cross tab. I have 3 field such as region, gender,
> and status.
> I want to make cross tab like this
>
> Female Male Single Married
> America 10 5 12 3
> Indonesia 6 9 10 5
>
> Female and male are from gender. Single and married are from status.
>
> So, does anybody know how to make that cross tab in crystal report.
>
> Thank you for your help
>
|
|
|
|
|