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 March 16th, 2018, 05:52 AM   #1
Roksan
Member
United Kingdom

Roksan is offline
 
Join Date: Jun 2011
Location: West Midlands
Posts: 5
Report Builder 3.0 with SQL Express/FTView SE

I have a requirement to produce date-range selectable reports from a panel mounted PC running FactoryTalk View SE. So far I have FactoryTalk logging a mixture of string data and float values to an SQL Server Express database. My first problem arises when I try to use Microsoft Report Builder 3.0 to display the data in date order in a table. MY SQL knowledge is very limited. I can build a dataset that includes 'FloatTable.Val' and 'StringTable.Val', but don't know how to get all float and all string values for a given date and time onto a single row in a report. I guess my query needs to include the 'TagIndex' field somehow from the database to select particular float and string values. Once I (hopefully) get this working, the next task will be to be able to select a date range for the data to be specified at the HMI, and to trigger report generation from the HMI. I assume report viewing could be achieved by opening a web browser on the HMI and specifying the report server URL?
I also don't have any high level language programming skills. I've attached the query I've cobbled together so far in Report Builder, and the resulting output of that query.

Any help, advice or code examples would be greatly appreciated.
Attached Images
File Type: jpg Query.jpg (8.7 KB, 19 views)
File Type: jpg Query Results.JPG (97.4 KB, 21 views)
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


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
FTView Studio SE Project Help with VBA, SQL & on Change Events sscott0203 LIVE PLC Questions And Answers 7 September 23rd, 2022 01:37 AM
FTView SE as a GUI to edit/maintain custom SQL tables mgallgood LIVE PLC Questions And Answers 12 February 8th, 2017 04:32 PM
WinCC - Report Designer - SQL problem Lesa LIVE PLC Questions And Answers 0 April 4th, 2011 04:03 AM
RSView SE 4.00 and SQL SERVER 2000 snyve LIVE PLC Questions And Answers 1 October 16th, 2007 12:05 PM
RSView SE to SQL DB Hardwerk LIVE PLC Questions And Answers 11 November 17th, 2005 05:48 PM


All times are GMT -4. The time now is 02:25 PM.


.