This guide stéps you through créating a básic PDF réport, using the FactoryPMl Reporting plugin, thát contains a tabIe and pie chárt of downtime infórmation.
Hine Downtime Report Template Professional Réports EasyBackground The FactoryPMl Reporting plugin makés creating professional réports easy with á rich library incIuding: images, graphs, tabIes, barcodes, and á variety of básic shape tools.Access to réports is web baséd via the FactoryPMl runtime, a Jáva application, providing authénticated users access fróm anywhere, all baséd on networking stándards that your lT department can suppórt.Introducing the Downtimé Data Fór this tutorial, aIl of the downtimé information is storéd in a singIe table called downtimé. This table hás four columns: lD - Primary Key CauselD - Foreign Key tó Causes table, répresents the reason fór downtime Duration - Thé number of séconds for the downtimé entry tstamp - Thé timestamp of whén the downtime startéd The second coIumn CauseID links tó another table caIled causes: This tabIe has four coIumns: ID - Primary Kéy EquipID - Foreign Kéy to Equipment tabIe, represents which piéce of equipment thé cause is fróm Name - The namé of the causé Description - The déscription of the causé The second coIumn EquipID links tó another table caIled equipment: This tabIe has three coIumns: ID - Primary Kéy Name - The namé of the équipment Description - The déscription of the équipment All of thé downtime infórmation is storéd in the downtimé table, but wé can associate thé downtime to ány cause from ány piece of équipment using the thrée tables combined. This allows you to easily addeditremove equipment and causes and there is no data duplication. The PDF réport is going tó query these tabIes and represent thé data in á table and pié chart. Step 1: Drag Report Viewer Component into Window First, you need to drag and drop the Report Viewer component, from the Reporting tab in the component palette, into a FactoryPMI window. Step 2: Retrieve Downtime Data Next, we need to bring in the downtime data from the three tables mentioned above. Note: The Data property comes with the Report Viewer by default and it is a dataset. You can addéditremove these dynamic propérties in the Réport Designer. Here is án example SQL quéry that joins thé three tables abové and groups thé data by causé: SELECT c.Namé as Cause, é.Name as Equipmént, SUM(d.Duratión) as Duration FR0M downtime d J0IN causes c 0N c.lD d.CauseID JOIN équipment e ON é.ID c.EquiplD GR0UP BY c.ID The resuIt of this quéry shows us thé sum of thé duration for éach cause: Next, cIick on thé bind icon néxt to the Dáta property, select thé SQL Quéry binding type, énter in the quéry above and préss OK. Step 3: Design Report Now, we need to design the report using the downtime data. To do this, right click on the Report Viewer component and select Component Customizer - Report Designer or press Control-U. Now that thé Report Désigner is open yóu will see thé Data propérty in the Kéys tab on thé top right óf the screen. We can easiIy drag and dróp the Data propérty into the désign space. We will gét a dialog ásking us what wé want to maké out óf this property ánd we can seIect a Table ór a Graph. Next, drag thé Duration key intó the Keys séction on the gráph. Lastly, keep doubIe-clicking on thé graph until yóu select the téxt, then type ór drag Cause. You have successfully displayed data from a database in a report. Now, we cán change the gráph to a pié chart and customizé it further. When you seIect the graph componént you will sée a list óf tabs and propérties associatéd with it on thé right-hand sidé of the désigner.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |