# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=42 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 43 --- ## [Print a Report with a Button Click](https://forum.inductiveautomation.com/t/print-a-report-with-a-button-click/484)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 5\ **Last updated:** [June 27, 2008, 2:25am UTC](https://forum.inductiveautomation.com/t/print-a-report-with-a-button-click/484 "2008-06-27T02:25:09Z")
Is there an easy way to print a report with a button click. The report.print() function wont work, as i need it to print to the default printer without popping up the print dialog. Here is what i have so far fpmi.t… --- ## [Problem adding new connection for datasource](https://forum.inductiveautomation.com/t/problem-adding-new-connection-for-datasource/708)
**Author:** [@richxie](https://forum.inductiveautomation.com/u/richxie)\ **Replies:** 2\ **Last updated:** [June 25, 2008, 5:14pm UTC](https://forum.inductiveautomation.com/t/problem-adding-new-connection-for-datasource/708 "2008-06-25T17:14:14Z")
Hi, I am not SQL guy, but I am trying to add new conection in datasource. But always fail. I have a couple of screen shots attached. Please help out. Thanks, Richard --- ## [Sound Player delay](https://forum.inductiveautomation.com/t/sound-player-delay/707)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 6\ **Last updated:** [June 24, 2008, 7:24pm UTC](https://forum.inductiveautomation.com/t/sound-player-delay/707 "2008-06-24T19:24:00Z")
The new Sound Player component is great, neatly getting round the problem of having to have the same .wav file available on every View node. I would like to use this to drive an alarm if there are any unacknowledged al… --- ## [Print Chart at 6am](https://forum.inductiveautomation.com/t/print-chart-at-6am/323)
**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\ **Replies:** 7\ **Last updated:** [June 23, 2008, 6:44pm UTC](https://forum.inductiveautomation.com/t/print-chart-at-6am/323 "2008-06-23T18:44:46Z")
We now have several Easy Charts working, When you call up the page, it populates with the current days temperature, starting at 6am. Is there a way to automatically print these charts on a daily basis, i.e. At 6am, the… --- ## [Moving SQLTags editor](https://forum.inductiveautomation.com/t/moving-sqltags-editor/706)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [June 23, 2008, 6:42pm UTC](https://forum.inductiveautomation.com/t/moving-sqltags-editor/706 "2008-06-23T18:42:51Z")
Every time you open the SQLTags editor, its position moves down the screen slightly from the previous time it was opened. This continues until the buttons at the bottom are obscured and you have to drag it back up the s… --- ## [Drop Down List](https://forum.inductiveautomation.com/t/drop-down-list/554)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 24\ **Last updated:** [June 22, 2008, 4:46pm UTC](https://forum.inductiveautomation.com/t/drop-down-list/554 "2008-06-22T16:46:05Z")
OK, how would you go about this: The operators have an order entry screen where they plan orders each day. Since the operators are not exactly data entry specialists, I'm trying to reduce the number of necessary keystrok… --- ## [Multiple SQLTag Providers on one machine?](https://forum.inductiveautomation.com/t/multiple-sqltag-providers-on-one-machine/705)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [June 21, 2008, 10:53pm UTC](https://forum.inductiveautomation.com/t/multiple-sqltag-providers-on-one-machine/705 "2008-06-21T22:53:35Z")
I'm confused (it doesn't take much). As far as I understood, SQLTags is run by FactorySQL. When you configure the SQLTags Settings using the FactorySQL Configuration Client, you select which Data connection is to be us… --- ## [Capturing data from lab measurement devices](https://forum.inductiveautomation.com/t/capturing-data-from-lab-measurement-devices/633)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 10\ **Last updated:** [June 19, 2008, 3:14pm UTC](https://forum.inductiveautomation.com/t/capturing-data-from-lab-measurement-devices/633 "2008-06-19T15:14:16Z")
Hi all: Any thoughts on how possible it would be to use factorypmi/sql to capture data streams from lab devices, such as scales, ph meters, gc's etc. There are apps out there for that, but it strikes me that what we ar… --- ## [SQL query returns no rows error](https://forum.inductiveautomation.com/t/sql-query-returns-no-rows-error/700)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [June 18, 2008, 6:35pm UTC](https://forum.inductiveautomation.com/t/sql-query-returns-no-rows-error/700 "2008-06-18T18:35:01Z")
I have an SQL query that in certain circumstances will contain no information. I currently get the SQL query returns no rows error. What would be a proper way to fix this? Thanks and have a great day. SELECT firstna… --- ## [List box questions](https://forum.inductiveautomation.com/t/list-box-questions/697)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [June 13, 2008, 4:04pm UTC](https://forum.inductiveautomation.com/t/list-box-questions/697 "2008-06-13T16:04:24Z")
I was wondering, I know it use to be the case where if you have a certain item on your pallet in FPMI that if you pressed a letter of the alphabet that item would goto the alphabatized portion of itself. Example: And I… --- ## [Firebird and FSQL](https://forum.inductiveautomation.com/t/firebird-and-fsql/694)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 8\ **Last updated:** [June 13, 2008, 3:57am UTC](https://forum.inductiveautomation.com/t/firebird-and-fsql/694 "2008-06-13T03:57:05Z")
Anyone using Firebird with FSQL ? What have been your experience? Thanks --- ## [FSQL Redundancy](https://forum.inductiveautomation.com/t/fsql-redundancy/698)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 5\ **Last updated:** [June 12, 2008, 5:15am UTC](https://forum.inductiveautomation.com/t/fsql-redundancy/698 "2008-06-12T05:15:48Z")
Hi, We are proposing a "Redundancy" system for one application and I have the following questions. BTW I read your news article about redundancy, real good. Our application is a batch based system with confirmation b… --- ## [Refresh of text or numeric fields](https://forum.inductiveautomation.com/t/refresh-of-text-or-numeric-fields/699)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [June 12, 2008, 3:37am UTC](https://forum.inductiveautomation.com/t/refresh-of-text-or-numeric-fields/699 "2008-06-12T03:37:15Z")
Is it possible to refresh a text or numeric field using 'action performed' with a button? --- ## [Remote site getting different results on query](https://forum.inductiveautomation.com/t/remote-site-getting-different-results-on-query/696)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 5\ **Last updated:** [June 11, 2008, 11:14pm UTC](https://forum.inductiveautomation.com/t/remote-site-getting-different-results-on-query/696 "2008-06-11T23:14:49Z")
I have a window with a Table, Popup Calendar and various textbox components. My user clicks on a line in the table, which updates most of the textboxes and sets the date in the calendar component. Four of my textboxes… --- ## [Python and Networking type questions](https://forum.inductiveautomation.com/t/python-and-networking-type-questions/695)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [June 9, 2008, 3:00pm UTC](https://forum.inductiveautomation.com/t/python-and-networking-type-questions/695 "2008-06-09T15:00:34Z")
Hopefully this will not jump around and it will make sense. Does anyone know how many open concurrent FTP connections are allowed on one windows based PC? In Python/Jython when using the FTP, I can not seem to find t… --- ## [Matisse, db4o or VistaDB](https://forum.inductiveautomation.com/t/matisse-db4o-or-vistadb/692)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 11\ **Last updated:** [June 6, 2008, 8:28pm UTC](https://forum.inductiveautomation.com/t/matisse-db4o-or-vistadb/692 "2008-06-06T20:28:21Z")
Hi, I know this is not related to FSQL but since it is related to the topic of database maybe you guys have used one of this products. I have an ASP.NET application that I need port to a low end computer that is runnin… --- ## [Easy Chart Question](https://forum.inductiveautomation.com/t/easy-chart-question/693)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 6\ **Last updated:** [June 5, 2008, 4:19pm UTC](https://forum.inductiveautomation.com/t/easy-chart-question/693 "2008-06-05T16:19:42Z")
I think this might have been covered before but I can not seem to find the posting of it. What I am curious about is if the Easy Chart pen colors can be changed dynamically. ( I am hoping that is the correct choice of … --- ## [Date/Time query assistance](https://forum.inductiveautomation.com/t/date-time-query-assistance/691)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [June 5, 2008, 3:16pm UTC](https://forum.inductiveautomation.com/t/date-time-query-assistance/691 "2008-06-05T15:16:57Z")
Since we started running our project i have found a small minor problem with some of the SQL coding. I know how I want to fix it, I just dont know the proper commands to do. Thought I would post it here for help. Curre… --- ## [Problem with 2 State Toggle](https://forum.inductiveautomation.com/t/problem-with-2-state-toggle/690)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 6\ **Last updated:** [June 4, 2008, 4:38pm UTC](https://forum.inductiveautomation.com/t/problem-with-2-state-toggle/690 "2008-06-04T16:38:09Z")
I've noticed a problem with the 2 State Toggle control when it is linked to a SQLTag point: when you press the button to change state from 0 to 1, the 'Control Value' field actually goes 0-1-0-1. Similarly when it chang… --- ## [Problem connecting to Matrikon OPC Server](https://forum.inductiveautomation.com/t/problem-connecting-to-matrikon-opc-server/679)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 11\ **Last updated:** [May 30, 2008, 10:13pm UTC](https://forum.inductiveautomation.com/t/problem-connecting-to-matrikon-opc-server/679 "2008-05-30T22:13:47Z")
We just installed a new NDC system that came with a Matrikon OPC server. I can browse items with their opc explorer and also from my existing Kepware OPC quick client. From FSQL I cannot browse or connect to the Matrikon… --- ## [Running total](https://forum.inductiveautomation.com/t/running-total/687)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 2\ **Last updated:** [May 28, 2008, 9:23pm UTC](https://forum.inductiveautomation.com/t/running-total/687 "2008-05-28T21:23:03Z")
I have a table that keeps a running total. Every hour the new value is entered in a new record. I want to retrieve the difference between value n and n-1 in a bargraph (24 hour period). Is it possible to retrieve this… --- ## [if(I \>= smart, great, not so good)](https://forum.inductiveautomation.com/t/if-i-smart-great-not-so-good/685)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 1\ **Last updated:** [May 28, 2008, 4:28pm UTC](https://forum.inductiveautomation.com/t/if-i-smart-great-not-so-good/685 "2008-05-28T16:28:02Z")
:slight\_smile: Hey guys. I'm trying to figure out how to create an expression on an action item. Basically, I need the action item (lets call it "log trigger" to go to 1, if the tag it is pointing at (say "scale\_input… --- ## [Problem with expression SQLTags in 4.2](https://forum.inductiveautomation.com/t/problem-with-expression-sqltags-in-4-2/681)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 0\ **Last updated:** [May 23, 2008, 10:42pm UTC](https://forum.inductiveautomation.com/t/problem-with-expression-sqltags-in-4-2/681 "2008-05-23T22:42:09Z")
Hello all- We've found a problem with expression based SQLTags in version 4.2.0. It's only been reported by 1 user so far, but we believe it could affect many users. Therefore, I wanted to post a quick update here on t… --- ## [Getting \ not values in reporting plugin display](https://forum.inductiveautomation.com/t/getting-list-not-values-in-reporting-plugin-display/678)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 11\ **Last updated:** [May 22, 2008, 11:25pm UTC](https://forum.inductiveautomation.com/t/getting-list-not-values-in-reporting-plugin-display/678 "2008-05-22T23:25:33Z")
I have a bunch of labels and boxes that I am displaying in a report. I drag my data key into the box and when I view the report in the designer, in some of them it displays the data and in others it displays instead. … --- ## [Math Functions](https://forum.inductiveautomation.com/t/math-functions/378)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 23\ **Last updated:** [May 21, 2008, 6:22pm UTC](https://forum.inductiveautomation.com/t/math-functions/378 "2008-05-21T18:22:46Z")
I have been using the ROUND function with no problem, but can't seem to get CEIL to work. When I use ROUND, I can see the color of the instruction change as it should, but CEIL remains black. For instance, this works: … --- ## [SQL Tags Browser in FactoryPMI question](https://forum.inductiveautomation.com/t/sql-tags-browser-in-factorypmi-question/676)
**Author:** [@kurt](https://forum.inductiveautomation.com/u/kurt)\ **Replies:** 3\ **Last updated:** [May 19, 2008, 10:33pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser-in-factorypmi-question/676 "2008-05-19T22:33:38Z")
In FactoryPMI Designer when I click on the SQL Tags Browser I get two sources of tags. These are: 1.) "MySQL" which is the name of the Database connection I made in FactorySQL. 2.) "FSQL" which has the identical informat… --- ## [Window Won't Open](https://forum.inductiveautomation.com/t/window-wont-open/675)
**Author:** [@neato20](https://forum.inductiveautomation.com/u/neato20)\ **Replies:** 3\ **Last updated:** [May 16, 2008, 10:43pm UTC](https://forum.inductiveautomation.com/t/window-wont-open/675 "2008-05-16T22:43:33Z")
I was writing a scrip in one of my windows today and when I closed the window out and tried to open it back up I get this error before the window even opens up: java.lang.ArrayIndexOutOfBoundsException: 0 at com.sun.… --- ## [Orphan alarms](https://forum.inductiveautomation.com/t/orphan-alarms/673)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [May 15, 2008, 4:21pm UTC](https://forum.inductiveautomation.com/t/orphan-alarms/673 "2008-05-15T16:21:31Z")
I'm currently having an issue with analogue alarms. I have a point with a high alarm of 100 (inclusive) to infinity; Ack Mode is Manual; Send Clear is True; Alert Deadband is set to 5. What I expected to happen is an a… --- ## [Aggregate Functions In MSSQL](https://forum.inductiveautomation.com/t/aggregate-functions-in-mssql/671)
**Author:** [@neato20](https://forum.inductiveautomation.com/u/neato20)\ **Replies:** 5\ **Last updated:** [May 14, 2008, 8:37pm UTC](https://forum.inductiveautomation.com/t/aggregate-functions-in-mssql/671 "2008-05-14T20:37:44Z")
I am back with yet another question. I am trying to pull data from a table that it populated everyday with the weight of scrap used for each shift and show it on a bar graph according to each shift. My problem is that I … --- ## [IPSec VPN v. SSL access to FactoryPMI](https://forum.inductiveautomation.com/t/ipsec-vpn-v-ssl-access-to-factorypmi/672)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [May 14, 2008, 4:12pm UTC](https://forum.inductiveautomation.com/t/ipsec-vpn-v-ssl-access-to-factorypmi/672 "2008-05-14T16:12:52Z")
A customer is proposing giving remote access to FactoryPMI by forwarding all traffic on the relevant port to the FactoryPMI server. This then puts all the security responsibility onto FactoryPMI. I need to be sure that… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=41) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=43)