![]() ![]() ![]() ![]() ![]() ![]() |
||
![]() |
||
![]() ![]() ![]() ![]() This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc. |
||
![]() |
![]() |
#1 |
Member
|
![]()
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. |
![]() |
![]() |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with WinCC OPC Updates | RollingPin | LIVE PLC Questions And Answers | 1 | June 23rd, 2017 05:07 AM |
Wincc Migration problem | nehe bhimaji | LIVE PLC Questions And Answers | 6 | January 7th, 2016 07:08 AM |
WinCC Flexible RT 2008 connection problem | MartinW | LIVE PLC Questions And Answers | 5 | March 28th, 2011 01:42 PM |
WinCC Flex 2007 to MP377 transfer problem | Chadk1971 | LIVE PLC Questions And Answers | 7 | June 19th, 2010 10:33 AM |
Wincc Flexible Change Value Problem! | wordless | LIVE PLC Questions And Answers | 3 | October 31st, 2009 02:13 PM |