{"id":2094,"date":"2019-03-25T17:38:01","date_gmt":"2019-03-25T20:38:01","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb36292-changing-a-reports-figure-at-run-time\/"},"modified":"2022-01-14T10:22:34","modified_gmt":"2022-01-14T13:22:34","slug":"kb36292-changing-a-reports-figure-at-run-time","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb36292-changing-a-reports-figure-at-run-time\/","title":{"rendered":"KB-36292: Changing a Report’s figure at run time."},"content":{"rendered":"
\n

Question:<\/span><\/p>\n

Can I change a Report’s figure at run time before printing it?<\/p>\n

Solution:<\/span><\/p>\n

Yes, you can. To do so, follow these procedures:<\/p>\n

1. Add a Historic with a field linked to an Internal Tag responsible for receiving the image’s path, and set it to not record registers anymore (recording time = 0);
\n2. On the Report, add a Figure object and a Data Field;
\n3. On the Report’s Query, write the following script:<\/p>\n

SELECT TemperatureTable.E3TimeStamp,TemperatureTable.Temperature1,TemperatureTable.Temperature2 ,(select (LocalImage) from TabLocalImage) as Image
\nFROM TemperatureTable
\nWHERE ( TemperatureTable.E3TimeStamp\u00a0 > #<%InitialDate%>#\u00a0 AND\u00a0\u00a0 TemperatureTable.E3TimeStamp < #<%FinalDate%># )
\nORDER BY TemperatureTable.E3TimeStamp\u00a0 ASC<\/span><\/span><\/p>\n

4. On the Data Field’s DataField <\/i>property, set the Image’s Visible <\/i>property as False (variable created on the Query’s SQL tab);
\n5. On the Report, you must write the following script to pass the image’s path to the Report’s Figure object:<\/p>\n

Sub OnFormat<\/span><\/span>Set FigureName = Report.Sections(“PageHeader”).Controls(“Field1”)<\/span><\/span>
\nSet Image = Report.Sections(“PageHeader”).Controls(“Image1”)<\/span><\/span>
\nImage.Picture = LoadPicture(FigureName)<\/span><\/span>End Sub<\/span><\/span><\/p>\n<\/div>\n

6. Before printing the Report, you must pass the image’s path to the Historic’s register created on the first step:<\/p>\n