Next, populate the Data dynamic dataset property by binding it to the combined sql query from the last section. Now create a new window and drag down a Report Viewer from the Reporting tab. Once you have the plugin installed open up the FactoryPMI Designer and select the project you want to configure. SELECT C.*, I.* FROM Contacts C, Income I WHERE C.ID = I.ContactID AND C.ID = 1 īegin by installing the Reporting Plugin in the FactoryPMI Gateway Configuration under the section labeled Plugins. You can retrieve the combined data for the first contact with the following query: SELECT I.* FROM Income I ORDER BY I.ContactID The income data can be retrieved from the accounting database with the following SQL query: SELECT C.* FROM Contacts C ORDER BY C.ID The contacts data can be retrieved from the accounting database with the following SQL query: There are two tables inside the database, one called Contacts and one called Income. The database we are using for this example is called Accounting. For this example, we will fill in a 1040EZ Income Tax Return with data from a MySQL database. This article demonstrates how to use the FactoryPMI Reporting Plugin to dynamically fill an existing PDF report. Ignition Exchange Community-made Ignition resources.Ignition Maker Edition Made for hobbyist and educational use.Ignition Edge Made for field and OEM devices at the edge.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |