Cross Tab / Pivot Solution Needed

Hai Friends,

I am developing a application where, i looking for a solution.

My scenario is, i have 3 tables which hold the following values

1) Master Type table - TypeID, TypeName - where TypeID is Primary key column
eg.
1,Sales Bill
2.Receipt Bill

2) Type Details Table - TypeDetID, TypeID, TypeDetail (multiple for each Type in Master) - where TypeDetID is Primary and TypeId is Foreign Keys
Eg.
1,1,Sales Tax
2,1,Discount
3,1,Total Value

3) Transaction Details table which holds the transaction details along with the TypeDetID and Value for TypeDetail (numeric value)

the scenario is in the transaction details there will be 5 rows if Type details has 5 details defined.

At runtime the user has to select which details column the user wants to see as a report. Here the user selects the Sales Tax & Total value fields alone.

eg.
row1: trans detail with Sales Tax value, Total Value
row2: trans details with Sales Tax value, Total Value
row3: trans details with Sales Tax value, Total Value


Any help will be highly appreciated...