Input recordset to the report

Posted by: steventong on 4 August 2017, 2:40 pm EST

  • Posted 4 August 2017, 2:40 pm EST

    Dear Sir,

    I want to write a recordset to the report outside the Detail page (maybe in Page footer/Page Header etc.), the format as follow, but I want to generate by coding at the ActiveReport_Init routine which is more easy to control. The main point is that I MUST draw a broader line in this recordset (the record count is not fix, sometime will more or less)

    p.s. MUST GENERATE by CODING


    Steven Tong


  • Replied 4 August 2017, 2:40 pm EST

    See the following KB artciles for examples of reports generated entirely through code:
    http://www.datadynamics.com/ShowPost.aspx?PostID=307
    http://www.datadynamics.com/ShowPost.aspx?PostID=95

    Keep in mind that controls cannot be bound to page header or page footer sections, so you will need to create your controls, populate them, and draw your lines all through code within the ReportStart event if you want to take that approach.  Alternatives include using a repeating group header that has a subreport control that generates a report containing this information.  The subreport could be composed of lines, or control borders, or can draw the lines in its reportend event.  There are many forum threads that discuss the creation of tables with borders within ActiveReports.
  • Replied 4 August 2017, 2:40 pm EST

    Peter,

    I still can't success to write a code to generate the recordset with border line and field header. So can you help me to write a small code for me which is the same result from my attachment?

    thanks

    Steven Tong


  • Replied 4 August 2017, 2:40 pm EST

    Please see the following thread for a recent discussion on this topic:
    http://www.datadynamics.com/ShowPost.aspx?PostID=75365
Need extra support?

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

Learn More

Forum Channels