page1 ReportPage1 PageHeader1 TextItem1 PageHeader1 Tržba ReportPage1 DataBand1 TextItem6 DataBand1 $D{bills.numSer} TextItem7 DataBand1 $S{currencyFormat($D{bills.totalPrice} / 100,"cs_CZ.utf8")} TextItem10 DataBand1 $S{dateTimeFormat($D{bills.payDateTime},"dd. MM. yyyy hh:mm:ss")} TextItem2 DataBand1 $D{bills.updatedBy} TextItem8 DataBand1 $S{dateTimeFormat($D{bills.eetSendDateTime},"dd. MM. yyyy hh:mm:ss")} ReportPage1 bills DataHeaderBand1 TextItem3 DataHeaderBand1 číslo účtenky TextItem4 DataHeaderBand1 zaplaceno TextItem9 DataHeaderBand1 uživatel TextItem11 DataHeaderBand1 datum zaplacení TextItem5 DataHeaderBand1 Datum odeslání eet ReportPage1 DataBand1 ReportFooter8 TextItem12 ReportFooter8 Počet účtenek: $S{COUNT(DataBand1)} TextItem13 ReportFooter8 Celkem: $S{currencyFormat(SUM($D{bills.totalPrice},DataBand1) / 100,"cs_CZ.utf8")} TextItem14 ReportFooter8 Data od: $S{dateTimeFormat(MIN($D{bills.data_from},"DataBand1"),"dd. MM. yyyy hh:mm:ss")} TextItem15 ReportFooter8 Data do: $S{dateTimeFormat(MIN($D{bills.data_to},"DataBand1"),"dd. MM. yyyy hh:mm:ss")} ReportPage1 datasources prodejna QSQLITE $V{dbPath} bills --vcerejsi trzby SELECT numSer, payDateTime, totalPrice, eetSendDateTime, updatedBy, datetime('now','start of day','-1 day','+6 hour') AS data_from, datetime('now','start of day','+6 hour') AS data_to FROM Voucher WHERE payDateTime BETWEEN datetime('now','start of day','-1 day','+6 hour') AND datetime('now','start of day','+6 hour') order by payDateTime; prodejna dbPath C:/Users/prodejna/Documents/prodejna/kiosek.db