If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subreport-Overlapping data when 2 subreports are in the same secti
I have 2 sub reports within the main report, both in the same section. If the
the 1st subreport has 1 line(record) it prints over the data in the 2nd subreport. Both sub reports can have varying numbers of records, so I cant know exactly where to start the 2nd report. I have tried to change the 'top' property of the 2nd subreport dependiing on the no or records in the 1st subreport, but the property is read only when running the report. Any suggestions would be greatly appreciated. |
#2
|
|||
|
|||
Subreport-Overlapping data when 2 subreports are in the same secti
Place the 2nd subreport control below (not overlapping) the first one, and
with no other controls overlapping them vertically. Set the CanGrow property of both subreport controls to Yes, and make sure the section's CanGrow is Yes as well. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "JPT" wrote in message ... I have 2 sub reports within the main report, both in the same section. If the the 1st subreport has 1 line(record) it prints over the data in the 2nd subreport. Both sub reports can have varying numbers of records, so I cant know exactly where to start the 2nd report. I have tried to change the 'top' property of the 2nd subreport dependiing on the no or records in the 1st subreport, but the property is read only when running the report. Any suggestions would be greatly appreciated. |
#3
|
|||
|
|||
Subreport-Overlapping data when 2 subreports are in the same s
Thanks so much Allen. My CanGrow properties were fine but the subreports were
just touching slightly. Such an easy thing to solve the problem, many thanks, Jan. "Allen Browne" wrote: Place the 2nd subreport control below (not overlapping) the first one, and with no other controls overlapping them vertically. Set the CanGrow property of both subreport controls to Yes, and make sure the section's CanGrow is Yes as well. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "JPT" wrote in message ... I have 2 sub reports within the main report, both in the same section. If the the 1st subreport has 1 line(record) it prints over the data in the 2nd subreport. Both sub reports can have varying numbers of records, so I cant know exactly where to start the 2nd report. I have tried to change the 'top' property of the 2nd subreport dependiing on the no or records in the 1st subreport, but the property is read only when running the report. Any suggestions would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |