Does your main report contain more detail than just the invoice level?
I had asked about your Record Sources but you didn't provide these.
Duane Hookom
MS Access MVP
> To: MS_Access_Professionals@yahoogroups.com
> From: maxccess@gmail.com
> Date: Fri, 24 Feb 2012 12:49:04 +0500
> Subject: Re: [MS_AccessPros] Re: Word Like Table in MS Access Report
>
> Dear Duane
>
> Yes I has created Subreport
>
> No, I am not remove detail section from report, actually I put subreport
> there.
>
> Link Master/Child is InvoiceID
>
> On Fri, Feb 24, 2012 at 12:21 PM, Duane Hookom <duanehookom@hotmail.com>wrote:
>
> > **
> >
> >
> >
> > Abdul,
> > I'm not convinced you have this set up correctly.
> >
> > Did you create a subreport?
> >
> > Did you remove a level of detail out of the main report?
> >
> > Can you tell us about your record sources and Link Master/Child properties?
> >
> >
> > Duane Hookom
> > MS Access MVP
> >
> >
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: maxccess@gmail.com
> > > Date: Fri, 24 Feb 2012 09:37:41 +0500
> > > Subject: Re: [MS_AccessPros] Re: Word Like Table in MS Access Report
> >
> > >
> > > Clive-
> > >
> > > I have already Grouping on InvoiceID with "Keep whole group together on
> > one
> > > page"
> > >
> > > On Thu, Feb 23, 2012 at 5:57 PM, Clive <zctek@aol.com> wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > Hi Abdul,
> > > >
> > > > You will need to change the Sorting_And_Grouping for
> > > > the Invoice.
> > > >
> > > > Open the report in Design_View and click on
> > > > View/Sorting_And_Grouping from the menu.
> > > > You will probably just need to group on an
> > > > Invoice Field.
> > > >
> > > > Regards, Clive.
> > > >
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, Abdul Shakeel
> > <maxccess@...>
> > > > wrote:
> > > > >
> > > > > Dear Duane,
> > > > >
> > > > > thanks it works, but when an invoice have more than one record the it
> > > > > splits into to pages, and become even worse if invoice have more
> > than 2
> > > > or
> > > > > more records, however I have set can grow/shrink property to no
> > > > >
> > > > > On Thu, Feb 23, 2012 at 10:44 AM, Duane <duanehookom@...> wrote:
> > > > >
> > > > > > **
> > > >
> > > > > >
> > > > > >
> > > > > > I think you can do this with a subreport of fixed height. Make
> > sure the
> > > > > > subreport can't grow or shrink.
> > > > > >
> > > > > > Duane Hookom
> > > > > > MS Access MVP
> > > > > >
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com, Abdul Shakeel
> > > > <maxccess@>
> > > > > > wrote:
> > > > > > >
> > > > > > > Dear All,
> > > > > > >
> > > > > > > I want insert a table in access report just like we do in word
> > but
> > > > with
> > > > > > > some fixed height in width let say the table height 3 in" fixed
> > even
> > > > if
> > > > > > it
> > > > > > > had only one record, I post these question previously in
> > different
> > > > manner
> > > > > > > got some answer though which are not helpful, I also have tried
> > line
> > > > > > method
> > > > > > > but no luck. I am trying to make an invoice. any suggestions.
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar