Hi guys,
I use WinCC 6.0
I have database in which i put informations about shifts. I have a window in which operator can see those informations and filter them based on time. Those are batch informations. I would like to make Report which can be printed with that informations. All I get is an empty table as result. This is my SQL statement in Data Connection Window in Dynamic Table Control in Report Designer:
SELECT BatchNr, WeightTime, CompOneWheight...
FROM Report
WHERE (WeightTime BETWEEN '$RW_DAY1$/$RW_MONTH1$/$RW_YEAR1$ 06:00:00' AND '$RW_DAY2$/$RW_MONTH2$/$RW_YEAR2$ 14:00:00')
ORDER BY WeightTime ASC
Those RW_DAY1, RW_DAY2 and other are tags that are configured in window. I have tested and printed only this tags and I get them well in Report.
Regional settings in win is dd/MM/yyyy
What do I do wrong, please help.
I use WinCC 6.0
I have database in which i put informations about shifts. I have a window in which operator can see those informations and filter them based on time. Those are batch informations. I would like to make Report which can be printed with that informations. All I get is an empty table as result. This is my SQL statement in Data Connection Window in Dynamic Table Control in Report Designer:
SELECT BatchNr, WeightTime, CompOneWheight...
FROM Report
WHERE (WeightTime BETWEEN '$RW_DAY1$/$RW_MONTH1$/$RW_YEAR1$ 06:00:00' AND '$RW_DAY2$/$RW_MONTH2$/$RW_YEAR2$ 14:00:00')
ORDER BY WeightTime ASC
Those RW_DAY1, RW_DAY2 and other are tags that are configured in window. I have tested and printed only this tags and I get them well in Report.
Regional settings in win is dd/MM/yyyy
What do I do wrong, please help.