"john" wrote:

> Hi,
> My table contains the following fields and records:
> first name  surname
> peter         green
> dave          black
> I now wish to utilise Report Design in order to create a report.In Design
> View and in the Details section I arrange the textbox controls and what I see
> is:
> first name surname
> first name surname
> I then switch to Report View and what I see is:
> first name  surname
> peter         green
> first name  surname
> dave          black
> I want first name and surname to appear once only and not twice.What I want
> is:
> first name  surname
> peter         green
> dave          black
> How do I achieve this?I read somewhere that I must look for the
> HideDuplicates "entry" in the Property Sheet but I cannot find such an
> "entry" there.
> (I know that I can click on Tabular in the Control Layout group of the
> Arrange tab to achieve such a "look" but then the label controls appear in
> the Page Header section and I don't want them there because I have other
> information entered there)
> Any assistance would be appreciated.
> john.
>

"Wayne-I-M" wrote:

> Hi John
>
> You have the put "first name  surname" in the head of the sorting group so
> you will have a header for each group - it looks like you have grouped your
> report by name (or person) so you will have lots of headers
>
> delete the text from the group header - put it in the page header or
> somewhere else that you want.
>
> Good luck
> --
> Wayne
> Manchester, England.
>
>
>
> "john" wrote:
>
> > Hi,
> > My table contains the following fields and records:
> > first name  surname
> > peter         green
> > dave          black
> > I now wish to utilise Report Design in order to create a report.In Design
> > View and in the Details section I arrange the textbox controls and what I see
> > is:
> > first name surname
> > first name surname
> > I then switch to Report View and what I see is:
> > first name  surname
> > peter         green
> > first name  surname
> > dave          black
> > I want first name and surname to appear once only and not twice.What I want
> > is:
> > first name  surname
> > peter         green
> > dave          black
> > How do I achieve this?I read somewhere that I must look for the
> > HideDuplicates "entry" in the Property Sheet but I cannot find such an
> > "entry" there.
> > (I know that I can click on Tabular in the Control Layout group of the
> > Arrange tab to achieve such a "look" but then the label controls appear in
> > the Page Header section and I don't want them there because I have other
> > information entered there)
> > Any assistance would be appreciated.
> > john.
> >

"john" wrote:

> Hi Wayne-I-M,
> Thanks for your reply.
> I did not apply any grouping or sorting.I just clicked on Add Existing
> Fields and then in the Field List pane I double clicked on first name and on
> surname and then the two text box controls appeared in the Details section.I
> did play around with Group and Sort a bit but I cannot achieve the results I
> want in the Details section. (I also clicked on the label part of one text
> box control and then clicked on Property sheet and in the Property sheet for
> Labels I set "Visible" to "No" but that setting takes away all the labels.)
> Regards,John
>
>
> "Wayne-I-M" wrote:
>
> > Hi John
> >
> > You have the put "first name  surname" in the head of the sorting group so
> > you will have a header for each group - it looks like you have grouped your
> > report by name (or person) so you will have lots of headers
> >
> > delete the text from the group header - put it in the page header or
> > somewhere else that you want.
> >
> > Good luck
> > --
> > Wayne
> > Manchester, England.
> >
> >
> >
> > "john" wrote:
> >
> > > Hi,
> > > My table contains the following fields and records:
> > > first name  surname
> > > peter         green
> > > dave          black
> > > I now wish to utilise Report Design in order to create a report.In Design
> > > View and in the Details section I arrange the textbox controls and what I see
> > > is:
> > > first name surname
> > > first name surname
> > > I then switch to Report View and what I see is:
> > > first name  surname
> > > peter         green
> > > first name  surname
> > > dave          black
> > > I want first name and surname to appear once only and not twice.What I want
> > > is:
> > > first name  surname
> > > peter         green
> > > dave          black
> > > How do I achieve this?I read somewhere that I must look for the
> > > HideDuplicates "entry" in the Property Sheet but I cannot find such an
> > > "entry" there.
> > > (I know that I can click on Tabular in the Control Layout group of the
> > > Arrange tab to achieve such a "look" but then the label controls appear in
> > > the Page Header section and I don't want them there because I have other
> > > information entered there)
> > > Any assistance would be appreciated.
> > > john.
> > >

"john" wrote:

> Hi,
> My table contains the following fields and records:
> first name  surname
> peter         green
> dave          black
> I now wish to utilise Report Design in order to create a report.In Design
> View and in the Details section I arrange the textbox controls and what I see
> is:
> first name surname
> first name surname
> I then switch to Report View and what I see is:
> first name  surname
> peter         green
> first name  surname
> dave          black
> I want first name and surname to appear once only and not twice.What I want
> is:
> first name  surname
> peter         green
> dave          black
> How do I achieve this?I read somewhere that I must look for the
> HideDuplicates "entry" in the Property Sheet but I cannot find such an
> "entry" there.
> (I know that I can click on Tabular in the Control Layout group of the
> Arrange tab to achieve such a "look" but then the label controls appear in
> the Page Header section and I don't want them there because I have other
> information entered there)
> Any assistance would be appreciated.
> john.
>