Dividing line

[Igorin]

Hello,

In a report, is there a way to add a dividing line?

I have a report that groups by field1 then sorts by 3 fields, first it sorts
by field2, then by field2, etc.

I would like to have a thicker line between the different values for field1,
to make them totally clear optically.

How could I do this?

Thank you for your responses.

 

[Duane Hookom]

Have you tried using a line control in a group header or footer?

You can also use the Line method in code to draw lines.

 

[Igorin]

Thanks for the reply, Duane,

I have indeed tried with a line control in the header & footer but what this
does is that it shows a line between the labels and the text boxes.

What I need is something different. Let me illustrate it:

I have a report with 4 fields (field1, field2, field3 and field4).
The report is grouped by field1. All like values for field1 are grouped
together.
Field1 has 3 different values:
For value1 the report shows 3 rows.
For value2 the report shows 5 rows.
For value3 the report shows 2 rows.

I need to have a line at the end of each value grouping to optically
differentiate them better. I.e., at the end of the first 3 rows there should
appear a line, then at the end of line 8 another.

(And if possible: At the end of line 10 there should not be any line.)

I hope this made my problem clearer.

Thanks for the help!

 

[Duane Hookom]

How about placing a line control at the very top of your group footer?

 

[Igorin]

I just tried this and it did not work.

Do you think that it's even doable?

 

[Duane Hookom]

I think it's not doable if you provide answers like "it did not work" without
providing your results or what exactly you tried.

Placing a line some place in a section header or footer is very doable.

 

[Igorin]

Hello, Duane!

By "I just tried this and it did not work" I was referring to your
suggestion that I was replying to. I'll be more specific now regarding what I
did.

(I think that placing a line anywhere in the section header or footer is not
a solution because I need the line in the Detail part.)

I need a line that only sepparates the groups formed by the different values
in field1.

This is how it should look like:

Label_Field1
value1
value1
value1
(line)
value2
value2
value2
value2
value2
(line)
value3
value3

This is what I have tried:

1) Placing a line just above the Header border, below the labels. Result:
Line appears between labels and text boxes.
2) Placing a line just below the text boxes. Result: Line appears inbetween
each value -> value1 (line) value1 (line) value1 (line) value2 (line) value2
(line) value2 (line) etc.
3) Placing a line just below the Footer border. Result: Line appears only at
the bottom of the report -> value1 value1 value1 value2 value2 value2 value2
value2 value3 value3 (line)

 

[Duane Hookom]

Are you grouping on field1. If not, create a group with a group footer. Add a
line in the group footer.

 

[Igorin]

Hello, Duane,

Indeed, I'm grouping by field1. In this case, what can I do to add the line
as I need it?

Thank you very much for taking the time to help.

 

[Igorin]

Duane, I just understood what you told me. Ignore the message below, please.

I have just one last question. I am grouping by Field1 but I don't see any
group footer. I see a group header. But the group footer is not there. How
can I activate it?

Thanks again.

 

[Duane Hookom]

You can show or hide group headers and footers by setting properties in the
Sorting and Grouping dialog.

 

[Igorin]

Perfect! Thank you very much, Duane!!!
--
igor

You can show or hide group headers and footers by setting properties in the
Sorting and Grouping dialog.