PCFormat Forum Archive

Loving ClearSCADA. Much easier than Citect. I'm on the forums here in my personal capacity already, so I'll still be here. This is just for business.

Thanks again for the help.

Thanks for all the help. We have managed to get the correct syntax for our SQL. We thought we'd share our solution as reference for anybody else. We are using Crystal Reports 2011 with a ClearSCADA ODBC Database. SELECT TOP(5) Name, RecordTime FROM CDBPoint JOIN CDBHistoric ON (CDBPoint.Id = CDBHist...

Hi Thanks for the reply. Google unfortunately failed us because everything it suggested hasn't worked. Seems our SQL is displeased with your try aswell. It gives us the error: SQL Command As Typed: SELECT TOP(5) Name, RecordTime FROM CDBPoint JOIN CDBHistoric ON (CDBPoint.Id = CDBHistoric.Id) WHERE ...

Good day Could anyone please help us if possible. We are struggling with one section of our SQL in Crystal Reports 2011. We are adding in commands into Crystal Reports to populate our custom report with commands such as: SELECT TOP(5) Name, RecordTime FROM CDBPoint JOIN CDBHistoric ON (CDBPoint.Id =...