I have stored procedure in MSSQL and am using Crystal Reports which linked to the stored procedure with below SQL.
select TRANSACTION_ID, BAGGAGE_ID, LapsedTime from trans_Details where ...............
DATA like below:
00001, 00001, 2 hours
00001, 00002, 2 hours
00002, 00003, 3 hours
I want below result to show in the report
Elapsed Time Num of Baggage Num of Transaction
2 Hours 2 1
3 Hours 1 1
Currently I have Num of Baggage and need to add Num of Transaction.
It seems to be distinct count of Transactin in the report. How can I do?