Draw vertical lines between subreports

[jc_msa]

I have a report that contains 5 subreports. 2 reports at the top. 1 report in the middle. 2 reports at the bottom.



AccessSubReports.zip

In the report designer, I am able to draw the 3 (blue) horizontal lines between the subreports and these lines move to the correct positions if the subreport grows. However I would like to draw the (2 orange) vertical lines to separate the subreport on the left from the one on the right.

I have added 2 vertical lines in the report designer. My plan was that I would then set the Top and Height of these lines when the report is opened. I would open the report the first time and store the position of the horizontal lines. I would then close and reopen the report and set the Top and Height of the vertical lines as I need them.

I am able to draw the top Vertical line perfectly. However although I set the Top and Height of the 2nd vertical line, to go between the 2 and last horizontal lines, Access seems to add an offset to this Top and therefore does not print line between the 2 horizontal lines. Is there an offset when Top is set? How do I determine this offset?

Is there a different way to draw vertical lines? Obviously the subreports may get longer / shorter and therefore I do not know the exact positions of the lines until runtime.

[CJ_London]

think what you probably want is

https://learn.microsoft.com/en-us/of...ss.Report.Line

[isladogs]

Following on from the last post, Access MVP, Crystal Long, has several articles on this topic.
For example Draw Lines and Boxes on Access Reports (msaccessgurus.com)

[jc_msa]

think what you probably want ishttps://learn.microsoft.com/en-us/of...ss.Report.Line

Hi,Thank you for your help. I have managed to draw the vertical lines using the article you quoted.

[jc_msa]

I have a report with multiple subreports. One of these subreports shows a number of entries. Another subreport shows of the these entries broken down into its components. For example the first subreport shows Investments by Type. One of these investment types is Cash. The other subreport shows the banks in which the cash is held. In order to show that the Cash report is a breakdown of the Investment Type report, I want to draw a line from the Cash row in the Investment Report to the Cash Report. This is shown in the attachment.




I would like to draw the green line from the Cash row to the Cash Report. If this is not possible, is there another way to highlight that the Cash Report is a breakdown of the Investment Report - Cash entry?

[CJ_London]

as far as the report.lines are concerned, not possible since these can only be horizontal or vertical. You may be able to with a line control (without the arrow) but there are two issues - the first is to determine the start and end points of the line since these could vary if the order of the list varies and pretty sure you cannot draw a line over the top of a subreport (or form), it will sit behind it regardless of 'on top' - you will have to experiment.

Alternatives:
have the line drawn from the edges of the subreports, you will still need to calculate the start position
given the list nature of the subreports, use a listbox instead
use colour to identify the connection.

[jc_msa]

as far as the report.lines are concerned, not possible since these can only be horizontal or vertical. You may be able to with a line control (without the arrow) but there are two issues - the first is to determine the start and end points of the line since these could vary if the order of the list varies and pretty sure you cannot draw a line over the top of a subreport (or form), it will sit behind it regardless of 'on top' - you will have to experiment.

Alternatives:
have the line drawn from the edges of the subreports, you will still need to calculate the start position
given the list nature of the subreports, use a listbox instead
use colour to identify the connection.

Report.lines can be diagonal. My difficulty is determining the start and end points of the lines. I do not know that there is a way to determine the location of a row within a report.

[jc_msa]

Sorry I just realized that this was posted to an existing Solved thread. I will post to a new thread.