Repeat Detail Section (Different then Anita Howard's question)

[Tony Vrolyk]

Although the scenario is different from Anita's, the answer may be the same
so I will watch both threads. I don't like it when someone responds to a
question with "Yea, me too but a little different" so I started a new topic.

I am trying to create a report to compare several group medical plans. The
fields are arranged vertically with headigns to the left identifying each
row. I couldn't find a way to have headings to the left of the columns only
once per page so here is what I did - except now the second and subsequent
pages don't look right.

I am using a Main report/subreport layout. The main report supplies the page
header/footer and the headings that appear to the left of the columns. I
also added gray bars across the page to make the rows easier to read. Then I
have a subreport to the right of the headings and over the gray bars and
sized to the right limit of the page. The first page looks great. The gray
bars show through beautifully, I have code that changes color of controls to
show differences between plans, yada yada yada.

However if there are enough records on the subreport to push it to two pages
only the heade/footer and subreport repeat. The headings and gray bars do
not.

You can see a sample of the out put here
http://personalpages.tds.net/~tvrolyk/sample_column_report.pdf

thanks for you help
Tony

 

[Marshall Barton]

Although the scenario is different from Anita's, the answer may be the same
so I will watch both threads. I don't like it when someone responds to a
question with "Yea, me too but a little different" so I started a new topic.

I am trying to create a report to compare several group medical plans. The
fields are arranged vertically with headigns to the left identifying each
row. I couldn't find a way to have headings to the left of the columns only
once per page so here is what I did - except now the second and subsequent
pages don't look right.

I am using a Main report/subreport layout. The main report supplies the page
header/footer and the headings that appear to the left of the columns. I
also added gray bars across the page to make the rows easier to read. Then I
have a subreport to the right of the headings and over the gray bars and
sized to the right limit of the page. The first page looks great. The gray
bars show through beautifully, I have code that changes color of controls to
show differences between plans, yada yada yada.

However if there are enough records on the subreport to push it to two pages
only the heade/footer and subreport repeat. The headings and gray bars do
not.

Take a look at KB article 148397 for an alternate approach
that avoids using a subreport. You'll have to figure out
how to add the color bars part though.

 

[Tony Vrolyk]

It worked after MUCH redesigning.

In my first rendition I was able to make the headings smaller than the data
column width since they required less space. With the method suggested I had
to make all 5 columns the same width. And with the LARGE number of labels
and controls it took 175 lines to handle the visible/invisible property.
Also still needed the subreport layout to provide the headers and footers
but that is not a problem.

But as I said, it worked and the users and more importantly the boss will be
happy.
Thanks
Tony