# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=20 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 21 --- ## [Reporting Plug-In Help Documentation](https://forum.inductiveautomation.com/t/reporting-plug-in-help-documentation/1429)
**Author:** [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Replies:** 3\ **Last updated:** [January 12, 2010, 9:23pm UTC](https://forum.inductiveautomation.com/t/reporting-plug-in-help-documentation/1429 "2010-01-12T21:23:11Z")
The help documentation for property expressions in the reporting plug-in need to be a little more robust. --- ## [How to change the Script Modules program font](https://forum.inductiveautomation.com/t/how-to-change-the-script-modules-program-font/1431)
**Author:** [@sam](https://forum.inductiveautomation.com/u/sam)\ **Replies:** 3\ **Last updated:** [January 12, 2010, 9:11pm UTC](https://forum.inductiveautomation.com/t/how-to-change-the-script-modules-program-font/1431 "2010-01-12T21:11:35Z")
\[attachment=0\]script.JPG\[/attachment\] the script modules font looks no clearly , how to change to standard font, such as : Times New Roman Thanks Sam --- ## [Map regions as a button](https://forum.inductiveautomation.com/t/map-regions-as-a-button/1409)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 12\ **Last updated:** [January 11, 2010, 7:12pm UTC](https://forum.inductiveautomation.com/t/map-regions-as-a-button/1409 "2010-01-11T19:12:45Z")
I have a geographically diverse client with operations broken down into many regions(30+). They want a map of the province (or state) with each region marked. When a user clicks on a region it will open the project for t… --- ## [Allows only Numeric Values](https://forum.inductiveautomation.com/t/allows-only-numeric-values/1428)
**Author:** [@pradip.waghmare](https://forum.inductiveautomation.com/u/pradip.waghmare)\ **Replies:** 2\ **Last updated:** [January 11, 2010, 5:48pm UTC](https://forum.inductiveautomation.com/t/allows-only-numeric-values/1428 "2010-01-11T17:48:42Z")
Dear Carl.Gould, How to allows to Enter only Integer Values ?. Regards Pradip Waghmare --- ## [Project File Madness](https://forum.inductiveautomation.com/t/project-file-madness/1298)
**Author:** [@HandledException](https://forum.inductiveautomation.com/u/HandledException)\ **Replies:** 6\ **Last updated:** [January 9, 2010, 9:26pm UTC](https://forum.inductiveautomation.com/t/project-file-madness/1298 "2010-01-09T21:26:00Z")
Hello Everyone, I just ran into a problem with FactorySQL. After opening up another project and sending it to the service, my original project (file) is now completely empty! I know that FSQL can only have one projec… --- ## [Fixing column widths in table component](https://forum.inductiveautomation.com/t/fixing-column-widths-in-table-component/1424)
**Author:** [@neville](https://forum.inductiveautomation.com/u/neville)\ **Replies:** 5\ **Last updated:** [January 6, 2010, 7:06pm UTC](https://forum.inductiveautomation.com/t/fixing-column-widths-in-table-component/1424 "2010-01-06T19:06:01Z")
Hi, I am trying to get a table to display with my pre-determined column widths. When I click on the 'Column Attributes Data' property and view the dataset I can see the width property. I can't seem to change it thoug… --- ## [Binding to the result of a SQL server stored prcedure in PMI](https://forum.inductiveautomation.com/t/binding-to-the-result-of-a-sql-server-stored-prcedure-in-pmi/1422)
**Author:** [@neville](https://forum.inductiveautomation.com/u/neville)\ **Replies:** 2\ **Last updated:** [January 5, 2010, 8:45pm UTC](https://forum.inductiveautomation.com/t/binding-to-the-result-of-a-sql-server-stored-prcedure-in-pmi/1422 "2010-01-05T20:45:10Z")
Hi, I like the data centric nature of PMI. I don't see a way at the moment to bind properties to the results of a stored procedure through (and even better pass parameters in). Can it be done? That way my SQL repo… --- ## [Binding between windows](https://forum.inductiveautomation.com/t/binding-between-windows/1423)
**Author:** [@neville](https://forum.inductiveautomation.com/u/neville)\ **Replies:** 1\ **Last updated:** [January 4, 2010, 11:20pm UTC](https://forum.inductiveautomation.com/t/binding-between-windows/1423 "2010-01-04T23:20:13Z")
I like the binding systemn and use it a lot. Is it possible to bind the the properties on another open window? It would be nice to use value from my header window and use that in the other windows. The way I do it at the… --- ## [Auto scroll to top of window when window is activated](https://forum.inductiveautomation.com/t/auto-scroll-to-top-of-window-when-window-is-activated/1420)
**Author:** [@Cas](https://forum.inductiveautomation.com/u/Cas)\ **Replies:** 4\ **Last updated:** [December 29, 2009, 8:38pm UTC](https://forum.inductiveautomation.com/t/auto-scroll-to-top-of-window-when-window-is-activated/1420 "2009-12-29T20:38:49Z")
First of all, Happy Holidays to the IA folks and to the members of this forum. My question is this: When I use a tab strip to navigate between my windows, it seems like whenever I go back to a window that I had scrolle… --- ## [Save In pop-up using exportExcel](https://forum.inductiveautomation.com/t/save-in-pop-up-using-exportexcel/1421)
**Author:** [@pradip.waghmare](https://forum.inductiveautomation.com/u/pradip.waghmare)\ **Replies:** 4\ **Last updated:** [December 28, 2009, 4:58pm UTC](https://forum.inductiveautomation.com/t/save-in-pop-up-using-exportexcel/1421 "2009-12-28T16:58:39Z")
Dear Carl.Gould I does't want to save in pop-up using exportExcel. I want to save file at defined Location. Regards Pradip Waghmare --- ## [Export Table dataset To Excel](https://forum.inductiveautomation.com/t/export-table-dataset-to-excel/1418)
**Author:** [@pradip.waghmare](https://forum.inductiveautomation.com/u/pradip.waghmare)\ **Replies:** 1\ **Last updated:** [December 24, 2009, 2:48pm UTC](https://forum.inductiveautomation.com/t/export-table-dataset-to-excel/1418 "2009-12-24T14:48:48Z")
Dear Carl.Gould I have a Excel file,file contains two sheets. sheet1 is formatted data (depends on sheet2 data). so i want to send table dataset to sheet2 . pls....help me. Regards Pradip Waghmare --- ## [Error :while importing Activex Control](https://forum.inductiveautomation.com/t/error-while-importing-activex-control/1417)
**Author:** [@Shailesh](https://forum.inductiveautomation.com/u/Shailesh)\ **Replies:** 1\ **Last updated:** [December 22, 2009, 6:53pm UTC](https://forum.inductiveautomation.com/t/error-while-importing-activex-control/1417 "2009-12-22T18:53:30Z")
Dear Support, I am getting error while Importing an Activex Control in Factory PMI. Regards, shailesh Naik. --- ## [Export to Excel](https://forum.inductiveautomation.com/t/export-to-excel/1415)
**Author:** [@pradip.waghmare](https://forum.inductiveautomation.com/u/pradip.waghmare)\ **Replies:** 1\ **Last updated:** [December 22, 2009, 6:05pm UTC](https://forum.inductiveautomation.com/t/export-to-excel/1415 "2009-12-22T18:05:01Z")
Dear Carl.Gould I have try to export dataset of Table to Excel but it is export only toolTip of the table. I want actually table dataset. please help me.. Regards Pradip Waghmare --- ## [Connection time Out error on email configuration for Alerts](https://forum.inductiveautomation.com/t/connection-time-out-error-on-email-configuration-for-alerts/1416)
**Author:** [@Shailesh](https://forum.inductiveautomation.com/u/Shailesh)\ **Replies:** 1\ **Last updated:** [December 22, 2009, 5:06pm UTC](https://forum.inductiveautomation.com/t/connection-time-out-error-on-email-configuration-for-alerts/1416 "2009-12-22T17:06:57Z")
Dear Support, I want to send mail while alert occurs for which I have done settings in Factory SQL Alert settings given in attached picture.Error occurs while I am testing alert email configuration. Regards Shailesh N… --- ## [Expected parameter error](https://forum.inductiveautomation.com/t/expected-parameter-error/1411)
**Author:** [@talhajee](https://forum.inductiveautomation.com/u/talhajee)\ **Replies:** 4\ **Last updated:** [December 20, 2009, 11:37pm UTC](https://forum.inductiveautomation.com/t/expected-parameter-error/1411 "2009-12-20T23:37:52Z")
Hi , When i start the configuration it gives me error "Expected parameter @datetime" which was not supplied. But in my configuration i am binding it with OPC item. --- ## [Can you poll data from a screen into a global script?](https://forum.inductiveautomation.com/t/can-you-poll-data-from-a-screen-into-a-global-script/1412)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [December 19, 2009, 1:48am UTC](https://forum.inductiveautomation.com/t/can-you-poll-data-from-a-screen-into-a-global-script/1412 "2009-12-19T01:48:19Z")
I have looked at the following posting viewtopic.php?f=23&t=4745 And it seemed close to what i want to do. However I keep getting an attributes error. What I am trying to do is within a Global script poll the a dat… --- ## [Enable/Disable individual tabs in a strip](https://forum.inductiveautomation.com/t/enable-disable-individual-tabs-in-a-strip/1405)
**Author:** [@Cas](https://forum.inductiveautomation.com/u/Cas)\ **Replies:** 6\ **Last updated:** [December 18, 2009, 2:57pm UTC](https://forum.inductiveautomation.com/t/enable-disable-individual-tabs-in-a-strip/1405 "2009-12-18T14:57:09Z")
I have a tab strip with 4 tabs. I am wondering if there is a way to dictate which tabs are enabled or disabled, based upon a Client Tag called "MemberType". For instance, if the user is "type" 1, then tabs 1,2 and 3 sh… --- ## [Table formatting bug](https://forum.inductiveautomation.com/t/table-formatting-bug/1410)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [December 17, 2009, 8:58pm UTC](https://forum.inductiveautomation.com/t/table-formatting-bug/1410 "2009-12-17T20:58:16Z")
I think I’ve found a fairly subtle bug in table formatting. I have a table in a window (see attached Window 2) whose data property is tied to a \[Client\] dataset testData. This dataset has 4 columns with the following h… --- ## [ToDate action item](https://forum.inductiveautomation.com/t/todate-action-item/1406)
**Author:** [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Replies:** 2\ **Last updated:** [December 15, 2009, 10:23pm UTC](https://forum.inductiveautomation.com/t/todate-action-item/1406 "2009-12-15T22:23:19Z")
I have an action item set up to look at integer values from the PLC and convert them to a date. ToDate({Int1}+"-"+{Int2}+"-"+{Int3}+" "+{Int4}+":"+{Int5}+":"+{Int6}) This triggers and works fine sometimes. Every … --- ## [Indirect SQL tags in queries](https://forum.inductiveautomation.com/t/indirect-sql-tags-in-queries/1382)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 3\ **Last updated:** [December 15, 2009, 9:25pm UTC](https://forum.inductiveautomation.com/t/indirect-sql-tags-in-queries/1382 "2009-12-15T21:25:24Z")
Quick question about indirect SQL tags- how can I embed one in an SQL query, i.e. SELECT ProductName FROM Products WHERE ProductID =('\[\]'+{Root Container.System\_1.SystemMoniker}+'/ProductID\_Setpoint') I do something… --- ## [FactorySQL Service won't start](https://forum.inductiveautomation.com/t/factorysql-service-wont-start/1408)
**Author:** [@dep05d](https://forum.inductiveautomation.com/u/dep05d)\ **Replies:** 1\ **Last updated:** [December 15, 2009, 6:35pm UTC](https://forum.inductiveautomation.com/t/factorysql-service-wont-start/1408 "2009-12-15T18:35:56Z")
We have been evaluating the demo, and are now having problems getting the FactorySQL service running. The Kepware demo is working and reading PLC values that we are trying to bring into FactorySQL and log to an Oracle da… --- ## [Designer chaching script modules](https://forum.inductiveautomation.com/t/designer-chaching-script-modules/1404)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 3\ **Last updated:** [December 14, 2009, 4:17pm UTC](https://forum.inductiveautomation.com/t/designer-chaching-script-modules/1404 "2009-12-14T16:17:29Z")
When I change a module, the designer is not picking up the change. I think it is because I am using dynamic loading. While debugging the following (app.colour), as soon as I got the dynamic loading working, any change… --- ## [Reporting Plug-In Hide Columns](https://forum.inductiveautomation.com/t/reporting-plug-in-hide-columns/1407)
**Author:** [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Replies:** 0\ **Last updated:** [December 14, 2009, 1:58pm UTC](https://forum.inductiveautomation.com/t/reporting-plug-in-hide-columns/1407 "2009-12-14T13:58:25Z")
It would be nice to have the ability in the reporting plug-in to dynamically hide/show columns. --- ## [Action item](https://forum.inductiveautomation.com/t/action-item/1344)
**Author:** [@czubak\_p](https://forum.inductiveautomation.com/u/czubak_p)\ **Replies:** 6\ **Last updated:** [December 11, 2009, 9:31pm UTC](https://forum.inductiveautomation.com/t/action-item/1344 "2009-12-11T21:31:10Z")
I have action Item with command IF({StopBit}=true,{FaultRegister},0) where StopBit and FaultRegister are OPC Items, when StopBit and FaultRegister have good opc quality than action item shows correct value, when S… --- ## [How to reference component properties in a module?](https://forum.inductiveautomation.com/t/how-to-reference-component-properties-in-a-module/1398)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 8\ **Last updated:** [December 11, 2009, 9:28pm UTC](https://forum.inductiveautomation.com/t/how-to-reference-component-properties-in-a-module/1398 "2009-12-11T21:28:26Z")
I have a number of properties (colours) in the root container. I want to change these properties based the properties of various components on the screen. (eg: is a switch open/close) I know I could write an expressio… --- ## [HTML Printing](https://forum.inductiveautomation.com/t/html-printing/1189)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 9\ **Last updated:** [December 11, 2009, 6:32pm UTC](https://forum.inductiveautomation.com/t/html-printing/1189 "2009-12-11T18:32:58Z")
Ok, I have a html doc viewer component. If I do a "select all" and copy the window contents to a text document (i.e. to TextPad or WordPad), I get a plain text copy of what I see on the screen. Is there a way to automa… --- ## [Window title](https://forum.inductiveautomation.com/t/window-title/1402)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [December 11, 2009, 12:29am UTC](https://forum.inductiveautomation.com/t/window-title/1402 "2009-12-11T00:29:52Z")
When launching a system in a window, the window title is made up of the FactoryPMI window name, followed by a string defined in the project's properties. Is it possible to hide the window name and display only the prede… --- ## [getProperty("name") for a component](https://forum.inductiveautomation.com/t/getproperty-name-for-a-component/1401)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 2\ **Last updated:** [December 10, 2009, 6:21pm UTC](https://forum.inductiveautomation.com/t/getproperty-name-for-a-component/1401 "2009-12-10T18:21:35Z")
Within a Script Module I would like to be able to retrieve the current value for a "named" property. ie: The ability to do this def some\_module(device, prop): window = getWindow("Window name") \_device = window… --- ## [Hiding the help menu](https://forum.inductiveautomation.com/t/hiding-the-help-menu/1403)
**Author:** [@neville](https://forum.inductiveautomation.com/u/neville)\ **Replies:** 1\ **Last updated:** [December 10, 2009, 8:52am UTC](https://forum.inductiveautomation.com/t/hiding-the-help-menu/1403 "2009-12-10T08:52:17Z")
Hi, How can I hide the "HELP" menu in the client. I have found a way to hide the Winodws and Command menus but not the Help. Thanks --- ## [Fpmi.dataset](https://forum.inductiveautomation.com/t/fpmi-dataset/1399)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 8\ **Last updated:** [December 10, 2009, 4:14am UTC](https://forum.inductiveautomation.com/t/fpmi-dataset/1399 "2009-12-10T04:14:00Z")
Is there a trick to using the fpmi.dataset functions? I always get an error saying no such object exists. [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=19) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=21)