You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

Reply
 
Thread Tools Display Modes
Old April 4th, 2011, 04:03 AM   #1
Lesa
Member
Serbia

Lesa is offline
 
Lesa's Avatar
 
Join Date: Sep 2006
Location: Novi Sad
Posts: 71
Earth WinCC - Report Designer - SQL problem

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.
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Topics
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


All times are GMT -4. The time now is 05:14 AM.


.