[AccessD] Bunch of reports with no page break

Stuart McLachlan stuart at lexacorp.com.pg
Sat Jul 3 03:39:48 CDT 2010


In that case, create a query which contains the key for each part and base the wrapper report 
on that. Put a single Kit List report in the detail and  set  the appropriate fields in the  Link 
Master Field/Link Child properties.

-- 
Stuart

On 2 Jul 2010 at 20:44, Rocky Smolin wrote:

> Well, it's really one report run many times for different parts. Think of it
> as a bill of materials report.  I pass the assembly part number to the
> report and it runs.  As each work orders are opened automatically, the Kit
> List for the work order is printed.  So it's really just one report run many
> times for different assemblies.  That's where I'm a bit stumped. If it was a
> bunch of different reports, I could make each one a sub report.  But it's
> the same report.
> 
> R
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: Friday, July 02, 2010 5:35 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Bunch of reports with no page break
> 
> That's exactly the way I do it - embed them as sub-reports in a "wrapper"
> report.
> 
> --
> Stuart
> 
> On 30 Jun 2010 at 22:32, Rocky Smolin wrote:
> 
> > Dear List:
> > 
> > I added a feature to my app to automatically release a bunch of work
> orders.
> > Client loved it.  
> > 
> > Then the client wanted to have the Kit List printed for each work 
> > order released - no problem, client loved it.
> > 
> > Now since many of these reports take only 1/3 to 1/2 page, the client 
> > requests that they be printed without the page break - save a tree.  
> > But I'm not sure how to accomplish this.  I suppose I could make the 
> > Kit List report a subreport in the detail section of a report, the 
> > record source of which would be the list or work orders to print the 
> > kit lists for, but I'm not sure that would work.  Any ideas?
> > 
> >  
> > 
> > MTIA,
> > 
> > Rocky Smolin
> > 
> > Beach Access Software
> > 
> > 858-259-4334
> > 
> > www.e-z-mrp.com <http://www.e-z-mrp.com/>
> > 
> > www.bchacc.com <http://www.bchacc.com/>
> > 
> >  
> > 
> >  
> > 
> > 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list