Report shows only some certain lines

[BittenApple]

Hello team,
I have a report that comes on a table:

RecordID HosID HosName Year field1, field2
1 1 HosA 2014 4 9
2 1 HosA 2015 2 3
3 1 HosA 2016 5 6
4 2 HosB 2014 3 7
5 2 HosB 2015 9 8

I have a subform on the above table; I made a report of this subform. Is there any way to make the HosName only comes one time on the report? I can delete HosName completely, because my subform in linked to a main form and that main form shows the name of hospital. However, I want to have hospital name only one time on the subform?

I hope this make sense.

BittenApple

[HansV]

You can set the Hide Duplicates property of the HosName text box to Yes.

[BittenApple]

How interesting...!
So valuable.
Regards,
BittenApple

[BittenApple]

Hello Hans,
This worked on the report for the section which was coming from the subform. I have a text box on a main form whose value is coming from a combo box on the main form. I want the value of this text box only is duplicated one time only; I followed the instruction, but that didn't work on the case that I mentioned on the top, although it worked on the part of the report whose value was coming from subform.
Regards,
BittenApple

[HansV]

You could try grouping the report by the field that comes from the main form, and placing the text box bound to that field in the group header section.
That way it won't be repeated.

[BittenApple]

Hans,
Thanks!
I sent you a thank you this morning by my phone and I see that it has not gotten to you.
BittenApple