Hello, I’m new in Scriptcase and using the latest trail version. Before buy the license, I want to clarify this tools can help me to build report or not.
I search many tutoral video from youtube, and try to build a report. If single table, I can build it. But multi table, I can’t build and run it normally.
I have 2 tables, one is ordermain, other is orderpay.
The structure of these tables are follow:
Ordermain :
ShopId | Orderid | guestcount | open time | closetime | ordertotal
10 | 1001 | 2 | 2016-12-10 19:30:00 | 2016-12-10 20:05:00 | 1200.00
10 | 1002 | 1 | 2016-12-10 19:28:20 | 2016-12-10 20:13:43 | 660.00
20 | 5667 | 1 | 2016-12-10 16:35:00 | 2016-12-10 16:45:34 | 45.00
20 | 5668 | 3 | 2016-12-10 19:11:13 | 2016-12-10 19:34:58 | 235.00
Orderpay :
ShopID | ID | OrderID | payid | payment name | total | payment type | is tender(0 not,1 yes)
10 | 1 | 1001 | 25 | Service Charge | 120.00 | 0 | 0
10 | 2 | 1001 | 150 | 10% Disc | -120.00 | 5 | 0
10 | 3 | 1001 | 1 | Cash | 600 | 1 | 1
10 | 4 | 1001 | 2 | Visa | 600 | 1 | 1
10 | 5 | 1002 | 25 | Service Charge | 60.00 | 0 | 0
10 | 6 | 1002 | 1 | Cash | 1000.00 | 1 | 1
10 | 7 | 1002 | 1 | Change | 340.00 | 0 | 0
20 | 7991 | 5667 | 1 | Cash | 45.00 | 1 | 1
20 | 7992 | 5668 | 1 | Cash | 250.00 | 1 | 1
20 | 7993 | 5668 | 1 | Change | 15.00 | 0 | 0
And my SQL statement is
select om.shopid, om.orderid, om.guestcount, om.closetime, om.ordertotal, op.paymentname, timediff(om.closetime,om.starttime)
from Ordermain om left join Orderpay op
on om.shopid = op.shopid and om.orderid = op.orderid
I want to build a report like this:
ShopID : 10
OrderID | Guestcount | closetime | ordertotal | Payment name | time different (closetime - opentime)
1001 | 2 | 2016-12-10 20:05:00 | 1200.00 | Visa (show anyone) | 00:35:00
1002 | 1 | 2016-12-10 20:13:43 | 660.00 | Cash | 00:45:23
ShopID : 20
OrderID | Guestcount | closetime | ordertotal | Payment name | time different (closetime - opentime)
5667 | 1 | 2016-12-10 16:45:34 | 45.00 | Cash | 00:10: 34
5668 | 3 | 2016-12-10 19:34:58 | 235.00 | Cash | 00:23:45
I would like to know, the Scriptcase can help me to build a report which my request.
Can some one help me or teach me how to build this report?
Thank you so much!