Cross Tab Report

[Coglearner]

I need to have the following functionality in the Impromptu report.

for example,take the following 3 columns

1.Product Type,
2.Order Date,
3.Sum(Sales Amount)

I have to pass 4 prompt values for the Order Date

Date Range 1
--------------
St_Dt1,
End_Dt1,

Date Range 2
--------------
St_Dt2,
End_Dt2.

Now the report should display seperate SalesAmount for the DataRange1 and DateRange2.


The out put of the report should look like..


Product_Type SalesAmount1 Sales Amount2
(For Date Range1) (Date Range 2)
------------- ------------- -----------------

Pr Typ1 2000 10000
pr Typ2 1000 10000

............
.........