New user needs help with frame control

Posted by: twilson7 on 4 August 2017, 2:50 pm EST

  • Posted 4 August 2017, 2:50 pm EST

    This should be a pretty easy one.  I have a frame control in my
    detail section.  4 panes wide, I have set the left and top borders
    to the single black border on all but the right most pane (on that I
    also have the right side border set).  How do I get a "bottom"
    line to print on the last set of panes on a page.  I have tried
    adding a group header/footer (it resolved my last issue so I gave it a
    shot) but there is a gap between the last pane on the page and the
    beginning of the line drawing I put at hte very top of the group footer
    (i.e. it does not close off the pane, plus on the last page the group
    footer prints way down hear the end of the page.

    If I add a bottom border to the panes then the detail sections that
    "touch" each other look like they have the double solid border between
    them.  I have formatted my panes just as the example in the help
    file suggested but of course mine isn't printing like the example.

    Thanks again for your help in advance.

  • Replied 4 August 2017, 2:50 pm EST

    The best way that I know how to accomplish this would be to set the top, left, and right borders of the frame control as you are doing now. Add a group to the report and set the group header's height to zero. In the group footer place a horizontal line with Y positions set to zero. Set the Can Grow and Can Shrink properties to true. Make sure that the PrintAtBottom Property is set to false for the group footer ( this footer should only print a single time on the last page, since we are not setting the datafield property for the group). To draw the closing line for all of the other pages (except the last), you would loop through the pages collection after the report has been run and programmatically draw it in the correct position using the DrawLine method.


    Dim rpt As New ActiveReport1

    For i = 0 To rpt.Pages.count - 1

    rpt.Pages(i).DrawLine 1 * 1440, 8.75 * 1440, 1440 * 7.5, 1440 * 8.75

    Next i  


  • Replied 4 August 2017, 2:50 pm EST

    Yikes.  Not sure I am familiar enough with the intricacies of
    active reports to get that to work out.  Thanks though.  I
    think you gave me a clue as to what i'm looking for with the
    PrintAtBottom property.  I did not notice this and seems like what
    the Line object is doing instead of printing at the top of the group
    footer i have created. 

Need extra support?

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

Learn More

Forum Channels