# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=19 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 20 --- ## [Chart subplots](https://forum.inductiveautomation.com/t/chart-subplots/115)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 6\ **Last updated:** [February 16, 2010, 10:55pm UTC](https://forum.inductiveautomation.com/t/chart-subplots/115 "2010-02-16T22:55:11Z")
Hi All: How do I turn on subplots on a graph. I have multiple datasets (series) one of which is an on/off value I would like plotted below the x axis as a subplot (I think that is what you call them). TIA D. Lewis --- ## [Purging old Alarms](https://forum.inductiveautomation.com/t/purging-old-alarms/1539)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 1\ **Last updated:** [February 12, 2010, 9:39pm UTC](https://forum.inductiveautomation.com/t/purging-old-alarms/1539 "2010-02-12T21:39:59Z")
We have been testing things out by triggering the alarms in the PLC program and generating some reports based on these alarms by querying the alarmlog table. When we get done testing and are ready to go live with the sy… --- ## [Cumulative data for chart](https://forum.inductiveautomation.com/t/cumulative-data-for-chart/1524)
**Author:** [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\ **Replies:** 2\ **Last updated:** [February 11, 2010, 9:41am UTC](https://forum.inductiveautomation.com/t/cumulative-data-for-chart/1524 "2010-02-11T09:41:18Z")
Hi I am having trouble generating a dataset for a cumulative chart I want to plot. I basically want to plot a chart which will display a running target versus actual target with cumulative data as the shift progresses… --- ## [Forcing a refresh of the dataset](https://forum.inductiveautomation.com/t/forcing-a-refresh-of-the-dataset/1512)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 4\ **Last updated:** [February 10, 2010, 7:32pm UTC](https://forum.inductiveautomation.com/t/forcing-a-refresh-of-the-dataset/1512 "2010-02-10T19:32:05Z")
I am using the report designer and due to the nature of my database, i am selecting data from the database from a view and not a table. The select statement below selects data from 3 views. select \* from opsummary\_div… --- ## [Close All Windows](https://forum.inductiveautomation.com/t/close-all-windows/1518)
**Author:** [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\ **Replies:** 2\ **Last updated:** [February 10, 2010, 8:58am UTC](https://forum.inductiveautomation.com/t/close-all-windows/1518 "2010-02-10T08:58:23Z")
Hi I am trying to write an action to close all open windows. I see there is an option from the windows menu to close all windows which closes all windows that are open and have the closable property enabled but I woul… --- ## [TIMESTAMP Problem on Reports](https://forum.inductiveautomation.com/t/timestamp-problem-on-reports/1519)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 3\ **Last updated:** [February 9, 2010, 9:18pm UTC](https://forum.inductiveautomation.com/t/timestamp-problem-on-reports/1519 "2010-02-09T21:18:04Z")
Ive attached the gateway error below. Basically I need to come up with an alarm duration time for my alarms by calculating the difference between the active\_time and the clear\_time fields in the alarmlog database table.… --- ## [Both CITEC and FActory SQL at same place,still problems](https://forum.inductiveautomation.com/t/both-citec-and-factory-sql-at-same-place-still-problems/1498)
**Author:** [@laxmanas](https://forum.inductiveautomation.com/u/laxmanas)\ **Replies:** 4\ **Last updated:** [February 8, 2010, 4:45am UTC](https://forum.inductiveautomation.com/t/both-citec-and-factory-sql-at-same-place-still-problems/1498 "2010-02-08T04:45:55Z")
Dear All, I am using Vijio Citect SCADA System in my PC and also i am using Factory SQL in the same PC( That means both are locally).When i run the frontend , it showing Citec.Opc,Citec.Remote.Opc.When i click on it ,i… --- ## [Set time to default 11:59:59 PM](https://forum.inductiveautomation.com/t/set-time-to-default-11-59-59-pm/1020)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 7\ **Last updated:** [February 5, 2010, 5:21pm UTC](https://forum.inductiveautomation.com/t/set-time-to-default-11-59-59-pm/1020 "2010-02-05T17:21:27Z")
How would I default the time to 11:59:59 PM on a calendar drop down. --- ## [Migrate Project to new DB](https://forum.inductiveautomation.com/t/migrate-project-to-new-db/1482)
**Author:** [@robertkjonesjr](https://forum.inductiveautomation.com/u/robertkjonesjr)\ **Replies:** 7\ **Last updated:** [February 4, 2010, 7:33pm UTC](https://forum.inductiveautomation.com/t/migrate-project-to-new-db/1482 "2010-02-04T19:33:04Z")
Using MySQL with Kepware/FSQL/FPMI and have about 14GB of data. Backups take 24hrs using the MySQL Admin tool, which is way too long. IT suggested I move to MSSQL because they have a backup agent with their backup tool… --- ## [Cannot browse for OPC Servers on remote PC](https://forum.inductiveautomation.com/t/cannot-browse-for-opc-servers-on-remote-pc/1490)
**Author:** [@laxmanas](https://forum.inductiveautomation.com/u/laxmanas)\ **Replies:** 3\ **Last updated:** [February 3, 2010, 11:27pm UTC](https://forum.inductiveautomation.com/t/cannot-browse-for-opc-servers-on-remote-pc/1490 "2010-02-03T23:27:05Z")
Thanks for advance if you provide the solution. when i am trying to click on "CITEC.OPCRemote" , it is giving the message like as follows "Cannot browse for OPC Servers on remote PC".Please help us what we need to do ,… --- ## [Factory SQl unable connect CITEC OPC Server](https://forum.inductiveautomation.com/t/factory-sql-unable-connect-citec-opc-server/1481)
**Author:** [@laxmanas](https://forum.inductiveautomation.com/u/laxmanas)\ **Replies:** 2\ **Last updated:** [February 3, 2010, 5:11am UTC](https://forum.inductiveautomation.com/t/factory-sql-unable-connect-citec-opc-server/1481 "2010-02-03T05:11:38Z")
Hi, thanks in advance if you provide the solution at the earliest. I am using factory sql ,from which i want to connect to CITEC OPC SERVER.When i try to connect it , the authentication has happend success fully and it… --- ## [Database locks, Why? What could cause?](https://forum.inductiveautomation.com/t/database-locks-why-what-could-cause/1471)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [January 31, 2010, 5:51pm UTC](https://forum.inductiveautomation.com/t/database-locks-why-what-could-cause/1471 "2010-01-31T17:51:27Z")
Ok I have a problem and I was not sure if to post here or in the database section so if I post it wrong sorry. For about the past 8 months we have had our project running and for the most part it has been running flawl… --- ## [How do you sort a dataset](https://forum.inductiveautomation.com/t/how-do-you-sort-a-dataset/1467)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [January 29, 2010, 7:20pm UTC](https://forum.inductiveautomation.com/t/how-do-you-sort-a-dataset/1467 "2010-01-29T19:20:21Z")
Hi, I am collecting data from various Lines and Machines and storing it in multiple tables. I often want to display this data on a window using a table where the column headings of the database table are in one column of… --- ## [Use cached login credentials for project login](https://forum.inductiveautomation.com/t/use-cached-login-credentials-for-project-login/1444)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [January 23, 2010, 3:25am UTC](https://forum.inductiveautomation.com/t/use-cached-login-credentials-for-project-login/1444 "2010-01-23T03:25:41Z")
Is there any way to pass the username and password that is cached from a windows login to the login of a project? I have active directoy for my authentication on my project, but users get tired of having login again. T… --- ## [Data Loss due to INACTIVITY?](https://forum.inductiveautomation.com/t/data-loss-due-to-inactivity/1261)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 21\ **Last updated:** [January 22, 2010, 5:23pm UTC](https://forum.inductiveautomation.com/t/data-loss-due-to-inactivity/1261 "2010-01-22T17:23:17Z")
I have been having this issue for some time now and have come to the conclusion that I must be over looking something. Example: At 10:30pm yesterday, I stopped logging ALL DATA.... I cannot see any reason why i… --- ## [Insert Statement Problem With FSQL](https://forum.inductiveautomation.com/t/insert-statement-problem-with-fsql/1440)
**Author:** [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\ **Replies:** 7\ **Last updated:** [January 22, 2010, 5:13pm UTC](https://forum.inductiveautomation.com/t/insert-statement-problem-with-fsql/1440 "2010-01-22T17:13:56Z")
I have just recently purchased the licence for Factory SQL and I have seen an intermittent problem occur with an Insert query I am running on the hour to insert a new row in 7 tables storing data about 7 different machin… --- ## [Shortcut to Launch Project to a Certain Window](https://forum.inductiveautomation.com/t/shortcut-to-launch-project-to-a-certain-window/1441)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [January 22, 2010, 4:33pm UTC](https://forum.inductiveautomation.com/t/shortcut-to-launch-project-to-a-certain-window/1441 "2010-01-22T16:33:04Z")
Is there a way to make a shortcut, maybe a batch file, to lauch a project and make start on a specified window? --- ## [Only execute group once when trigger is active](https://forum.inductiveautomation.com/t/only-execute-group-once-when-trigger-is-active/1443)
**Author:** [@Justin](https://forum.inductiveautomation.com/u/Justin)\ **Replies:** 4\ **Last updated:** [January 21, 2010, 8:12pm UTC](https://forum.inductiveautomation.com/t/only-execute-group-once-when-trigger-is-active/1443 "2010-01-21T20:12:15Z")
I've had a strange issue on a group trigger setting that I need to get resolved. Sometimes after restarting the FSQL service, the checkbox for "Only execute group once when trigger is active" is not selected. The check… --- ## [Strings and dynamic properties](https://forum.inductiveautomation.com/t/strings-and-dynamic-properties/1442)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 9\ **Last updated:** [January 21, 2010, 7:16pm UTC](https://forum.inductiveautomation.com/t/strings-and-dynamic-properties/1442 "2010-01-21T19:16:24Z")
I've got a problem with string handling, and I've got most of it figured out except for one little part. I went over this with Bobby earlier and I checked out a few things. Thanks again Bobby! This is what I'm doing: I… --- ## [How to shrink PDFs generated by Reporting Plugin](https://forum.inductiveautomation.com/t/how-to-shrink-pdfs-generated-by-reporting-plugin/1439)
**Author:** [@ilanlchait](https://forum.inductiveautomation.com/u/ilanlchait)\ **Replies:** 2\ **Last updated:** [January 19, 2010, 5:35pm UTC](https://forum.inductiveautomation.com/t/how-to-shrink-pdfs-generated-by-reporting-plugin/1439 "2010-01-19T17:35:57Z")
Hi guys, I generate reports which contain many graphs and charts. The reports range in length from 10 pages to 180 pages. With about 90% of the report covered by charts & graphs. When saved as PDFs, the larger reports … --- ## [Selecting security profiles on the fly](https://forum.inductiveautomation.com/t/selecting-security-profiles-on-the-fly/1433)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 12\ **Last updated:** [January 19, 2010, 3:40pm UTC](https://forum.inductiveautomation.com/t/selecting-security-profiles-on-the-fly/1433 "2010-01-19T15:40:34Z")
My customer has a number of regions. Each region has it's own security profile. eg a user in region 1 is not allowed to operate stuff in region 2. The normal way to handle this is to create a different project for each… --- ## [Make the property binding screen non-modal](https://forum.inductiveautomation.com/t/make-the-property-binding-screen-non-modal/1435)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 2\ **Last updated:** [January 18, 2010, 10:54pm UTC](https://forum.inductiveautomation.com/t/make-the-property-binding-screen-non-modal/1435 "2010-01-18T22:54:10Z")
Can you please put an 'Apply' button on the screen and make it non-modal? It is a major PITA trying to debug an expression or the interaction between an expression and a global script when you have to close the window af… --- ## [Access different security profiles from the client](https://forum.inductiveautomation.com/t/access-different-security-profiles-from-the-client/1434)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 1\ **Last updated:** [January 18, 2010, 10:20pm UTC](https://forum.inductiveautomation.com/t/access-different-security-profiles-from-the-client/1434 "2010-01-18T22:20:06Z")
more information here but a quick summary is the ability to do something like fpmi.security.useProfile('profile\_name') This would authentic the current user against the new profile and reset the roles granted --- ## [Share code similar to the way you share images](https://forum.inductiveautomation.com/t/share-code-similar-to-the-way-you-share-images/1436)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 1\ **Last updated:** [January 18, 2010, 10:12pm UTC](https://forum.inductiveautomation.com/t/share-code-similar-to-the-way-you-share-images/1436 "2010-01-18T22:12:29Z")
I have a number of projects on the same gateway. I would like to be able to share my global code (app.\*) between them rather then duplicating it. --- ## [FactorySQL Redundancy - Setup](https://forum.inductiveautomation.com/t/factorysql-redundancy-setup/1437)
**Author:** [@Gus](https://forum.inductiveautomation.com/u/Gus)\ **Replies:** 1\ **Last updated:** [January 18, 2010, 9:11pm UTC](https://forum.inductiveautomation.com/t/factorysql-redundancy-setup/1437 "2010-01-18T21:11:04Z")
I just enabled redundancy on FactorySQL. It seems to be working but I’m not sure if I setup this right. I have two physical servers (A and B) running a virtual servers each with a mirrored database. I setup another two v… --- ## [Redundancy](https://forum.inductiveautomation.com/t/redundancy/1162)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 13\ **Last updated:** [January 18, 2010, 7:03pm UTC](https://forum.inductiveautomation.com/t/redundancy/1162 "2010-01-18T19:03:54Z")
I'm trying to set up redundancy. I called but everyone was busy, I'll probably get a faster response in the forum. I've had FactorySQL running on a computer for a few months now. I just enabled redundancy and everythin… --- ## [Execute once trigger](https://forum.inductiveautomation.com/t/execute-once-trigger/1413)
**Author:** [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Replies:** 13\ **Last updated:** [January 18, 2010, 5:13pm UTC](https://forum.inductiveautomation.com/t/execute-once-trigger/1413 "2010-01-18T17:13:20Z")
I have several groups set up to trigger on a "PC upload bit". Only one of these groups handshakes with the PLC. I am having trouble with some of the groups not always triggering. They are set up to execute once at 1 sec … --- ## [Global Search and Replace](https://forum.inductiveautomation.com/t/global-search-and-replace/615)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 4\ **Last updated:** [January 15, 2010, 1:30am UTC](https://forum.inductiveautomation.com/t/global-search-and-replace/615 "2010-01-15T01:30:24Z")
We're developing a screen that uses ~150 occurences of a custom component. We get to the point where we think it is right, then copy 100 or so the screen and begin more full scale testing, realize we've missed something… --- ## [Disable columnt title headers](https://forum.inductiveautomation.com/t/disable-columnt-title-headers/1432)
**Author:** [@pdalwalla](https://forum.inductiveautomation.com/u/pdalwalla)\ **Replies:** 2\ **Last updated:** [January 14, 2010, 2:24pm UTC](https://forum.inductiveautomation.com/t/disable-columnt-title-headers/1432 "2010-01-14T14:24:43Z")
How can i disable or hide column titles or headers. what we are trying to do is build a dynamic horizontal sub menu under each tab and one way to do that was to have a table component of row one and multiple columns w… --- ## [New Item in FactorySQL](https://forum.inductiveautomation.com/t/new-item-in-factorysql/1430)
**Author:** [@pradip.waghmare](https://forum.inductiveautomation.com/u/pradip.waghmare)\ **Replies:** 2\ **Last updated:** [January 13, 2010, 10:32pm UTC](https://forum.inductiveautomation.com/t/new-item-in-factorysql/1430 "2010-01-13T22:32:59Z")
Dear Carl.Gould, Is it possible to create a new item in FactorySql from the FactoryPMI. Regards Pradip Waghmare [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=18) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=20)