Loading/showing image from separate query

Posted by: scott on 30 September 2020, 7:08 am EST

  • 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.

    1) Use a Sub-Report and load the image data into the Picture control that is actually on the parent report.

    2) 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
  • Replied 30 September 2020, 8:51 pm EST

    Hello,

    >>1) Use a Sub-Report and load the image data into the Picture control that is actually on the parent report
    Yes, this is the correct approach. Please refer to the attached subreport that you can use in your main report.

    Thanks,
    Mohit
    test.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels