Solved

Access 2003:  Report - Group Totals - separator line in the group footer is not always printing

Posted on 2011-03-24
2
422 Views
Last Modified: 2012-05-11
Hi EE,

Below is an uploaded mdb of 3 report.
 parent report - fixed fields
 subrep1 - course information for fall semester
 subrep2 - course information for sprint semester

Am using subReports as pseudo columns

Grouping the subReport by Semester.
In the Group footer, i drew a horizontal separator line, that i realize is not always showing.

if you run the subreport2 by itself, you will the last separator line printing
if you run the parent report that includes 2 subreports, the last separator does not show on the printed page


tx in advance for your ideas, sandra
0
Comment
Question by:mytfein
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
pteranodon72 earned 500 total points
ID: 35209340
There is no attachment to view, but my experience with intermitant lines always seems to happen with lines set to Border Style=HairLine. Try changing to Border Style = 1pt and see that is dependable.
Hope this helps,
pT72
0
 

Author Comment

by:mytfein
ID: 35209375
Hi PT72,

tx sooo much,

followed your suggestion.... beautiful....  sorry forgot to upload file....

you solved it... tx, s
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question