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.

---------->>>>>Get FREE PLC Programming Tips

New Here? Please read this important info!!!


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

PLC training tools sale

Reply
 
Thread Tools Display Modes
Old December 19th, 2016, 08:13 AM   #1
notausp
Member
Brazil

notausp is offline
 
Join Date: May 2016
Location: Americana
Posts: 12
Post Factorytalk SE and MSReportBuilder

Hi,
does anybody have a sample on how to create process/alarms/events/production reports using Factorytalk SE and MSReportBuilder?
  Reply With Quote
Old December 19th, 2016, 09:36 AM   #2
gclshortt
Member
Canada

gclshortt is offline
 
gclshortt's Avatar
 
Join Date: Dec 2014
Location: Cobourg
Posts: 1,723
http://www.plctalk.net/qanda/showthread.php?t=63354

http://www.itpro.co.uk/sites/itpro/f...ortbuilder.pdf

https://technet.microsoft.com/en-us/...=sql.110).aspx

I would treat this as two separate questions. The first thing to do is get Factorytalk up and running and logging your events into a SQL database. Then look to MSReportBuilder to read from the SQL database. The above are links to some resources.

Hope this helps you out.
Regards,
__________________
Garry
http://www.accautomation.ca
  Reply With Quote
Old December 19th, 2016, 10:39 AM   #3
notausp
Member
Brazil

notausp is offline
 
Join Date: May 2016
Location: Americana
Posts: 12
Quote:
Originally Posted by gclshortt View Post
http://www.plctalk.net/qanda/showthread.php?t=63354

http://www.itpro.co.uk/sites/itpro/f...ortbuilder.pdf

https://technet.microsoft.com/en-us/...=sql.110).aspx

I would treat this as two separate questions. The first thing to do is get Factorytalk up and running and logging your events into a SQL database. Then look to MSReportBuilder to read from the SQL database. The above are links to some resources.

Hope this helps you out.
Regards,
Thank you gclshortt!
Well, I have already done the FTView and SQL step. I'll read about MSReportBuilder and then I'll go back!
  Reply With Quote
Old February 16th, 2017, 08:32 AM   #4
notausp
Member
Brazil

notausp is offline
 
Join Date: May 2016
Location: Americana
Posts: 12
Hi! I made a successful link between SQL and FTView, my tables are good and I developed my ReportBuilder's report. In REpBuilder preview I can successfully populate my report.
The question is: how to embed my report in runtime FTView Client, without the need to open external application.

I thought it was easy, something like just put an activex, but until now can't find a solution.

In Citect its possible trough a template and Cicode passing report URL, with SSRS (Microsoft Reporting Services) properly configured.

any help would be greatly appreciated!

Last edited by notausp; February 16th, 2017 at 08:35 AM.
  Reply With Quote
Old February 17th, 2017, 06:38 AM   #5
notausp
Member
Brazil

notausp is offline
 
Join Date: May 2016
Location: Americana
Posts: 12
Success! It worked!
Where can I post a tutorial?
  Reply With Quote
Old February 19th, 2017, 05:42 PM   #6
ASF
Lifetime Supporting Member
Australia

ASF is offline
 
Join Date: Jun 2012
Location: Australia
Posts: 2,022
Posting it here on this thread is probably fine. In the future, someone with the same question will likely come across this thread, and having a tutorial at the end of it will help them no end
  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


All times are GMT -5. The time now is 04:29 AM.


.