shashibadari
November 18th, 2008, 03:32 PM
Hi,
I am new to crystal reports, i need to display data in the cross-tab but i am not able to. i am reading the data from a temp table in sql server as the data needs lots of calculations.
Eg :
7/7 7/11 7/18 Total
Receipts 5 9 20 34
UnRele 3 2 10 15
#of Rec (2) (7) (10) (19)
I have only one table with 3 columns which will contain the values (eg: 5,3,9, etc) , Released/Unreleased, and Date.
My problem is the values 5,9,20 are already calculated and its the total of receipts for the particular date range, so those columns have to directly appear from the table which i am not able to do.
Can some one help me plz its little bit urgent
Thanks
Shashi
I am new to crystal reports, i need to display data in the cross-tab but i am not able to. i am reading the data from a temp table in sql server as the data needs lots of calculations.
Eg :
7/7 7/11 7/18 Total
Receipts 5 9 20 34
UnRele 3 2 10 15
#of Rec (2) (7) (10) (19)
I have only one table with 3 columns which will contain the values (eg: 5,3,9, etc) , Released/Unreleased, and Date.
My problem is the values 5,9,20 are already calculated and its the total of receipts for the particular date range, so those columns have to directly appear from the table which i am not able to do.
Can some one help me plz its little bit urgent
Thanks
Shashi