cross tab datawindow

Could any help me out in creating this type of report using crosstab 
datawindow style. (dynamic 
Cross tab)
The data source is stored procedure 
The following data is retrieved from the stored procedure:
1. Mat proceeds
2. Type  -
3. Subtotal (mat proceeds)
4. Interest
5. Subtotal (interest)
6. grand total (3+4)
7. Newissue
8. subtotal (new issue)
9. cash
10. balance
My requirement is like this: (in table format):
Currency:               Gbp             Usd     Euro    yen
Matruing proceeds 
Type(2)                 10.22(1)        0.00    0.00 
Type(2)                 0.00(1)         18.00 
Sub total(3)            10.22           18.00 
Interest 
Type(2)                 4.00(4) 
Type(2)                 70.00(4) 
Sub total (4)           74.00 
Grandtotal(6)           84.22 
 
Newissuance 
Type(2)                 0.00    45.15 
Type(2)                 0.00    0.00 
Sub total (8)           0.00    45.15 
Cash (9)                88.22   56.13 
Balance (10)            55.00   45.12 

0
kavitha
12/31/2002 4:01:37 AM
📁 sybase.powerbuilder.datawindow
📃 28057 articles.
⭐ 5 followers.

💬 0 Replies
👁️‍🗨️ 791 Views


Reply: