Need a non-repeating label in detail section

[duluter]

Hi.

I have a report that groups on field X. Under each X, there may be multiple records showing fields Y and Z.

X1

Y1_______Z1
Y2_______Z2
​

X2

Y1_______Z1
Y2_______Z2
Y3_______Z3

​

Etc. Standard stuff.

Now for each group on X, I want to display a label to the left of the first detail row, but I don't want the label to be repeated with each subsequent detail row. Like this:


X1
[label]____Y1_______Z1
_________Y2_______Z2

X2
[label]____Y1_______Z1
_________Y2_______Z2
_________Y3_______Z3


The label is static; it's text is the same every time it appears.

How do I do this?


Thanks,

Duluter

 

[HiTechCoach]

If you use a text box control and set these properties:

Control Source ="Label Text"
Hide Duplicates = Yes

 

[duluter]

This is just what I want. Thank you.


Duluter

 

[HiTechCoach]

Using the report's sorting and grouping properties will also do what you want plus give you headers and footers into which you can put controls for counts, etc.

Pat,

I looks like they are already using group headers (see their example). What they said they want is "... to display a label to the left of the first detail row". What am I missing ... Do tell ....How will a group header handle this?