Posted 30 September 2020, 7:08 am EST
We have a report with a large image loaded from database. We are placing other images and labels on that image in the footer section of our report and it looks great. We have a report with hundreds of records and we only need one image, but we need that image in the group footer of the report.
How do we load that single image from a SQL query using the same database connection string? We don’t want that image data repeated in every row of the detail section, so we need to grab it in a separate query in C# in the GroupFooter routine in the RPX script section.
Either of 2 methods would help, but I am really hoping for a complete snippet on how to do this and fill a Picture control in the footer.
-
Use a Sub-Report and load the image data into the Picture control that is actually on the parent report.
-
A snippet that connects to the same database source as the parent report, runs a SELECT query and fills the Picture control from that query.
I am using Active Reports 12 version 12.0.11689