Print Page | Close Window

Cross Tab Help

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13736
Printed Date: 26 Apr 2024 at 12:03am


Topic: Cross Tab Help
Posted By: ipgodahenage
Subject: Cross Tab Help
Date Posted: 12 Jul 2011 at 10:21pm
pls. if anyone have solution for this........
I made a databse table shown in below.......
item
Description
Qty
Supplier
Rate
Amount
1
aaaa
10
Supplier1
100
1000
2
bbb
20
Supplier1
200
4000
3
cccc
30
Supplier1
300
9000
1
aaaa
10
Supplier2
50
500
2
bbb
20
Supplier2
60
1200
3
cccc
30
Supplier2
70
2100
1
aaaa
10
Supplier3
100
1000
2
bbb
20
Supplier3
300
6000
3
cccc
30
Supplier3
400
12000

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 



i want to view report as follows in crystal report..... pls help me to do this..........

Item
Description
Qty
Supplier 1
Suppler 2
Supplier3
…….
Rate
Amount
Rate
Amount
Rate
Amount
Rate
Amount
1
aaaa
10
100
1000
50
500
100
1000


2
bbb
20
200
4000
60
1200
300
6000
 
3
cccc
30
300
9000
70
2100
400
12000
 
 
 
 
 
 
 
 
 
 
 
 



Print Page | Close Window