Joe Rojas
JRojas at tnco-inc.com
Wed Mar 30 10:08:57 CST 2005
I think I may have been unclear in my description of my problem. The need to display a dynamic number of "rows" on my report is to provide space on the report for people to manually write in the information by hand. My table that holds the information for the measurements to be check for a particular part looks like this: PartNumber, Attribute, DeviceUsed So if there were only one attribute to check for a particular part number, the table would contain a row that looks like: 32-5500 Ø.250 ± .005 DC Now the problem is, if the shop order is for part number 32-5500 and the order quantity is 50 then I would need to display 50 "lines" on the report for the operator to fill in their measurements. By "lines" I mean boxed in areas for provide a space on the report for the operator to write in. What I have now is an empty label with a solid border in the detail section of the report. I was trying to think of a way that would allow the number of "lines" that are printed on the report to be dynamic and dependent on the order quantity that is entered prior to printing the report. My original idea was to insert blank lines into a table prior to opening the report. The report will use this table so that the detail section will "repeat" for each blank line in the table. In essence, giving the correct number of lines need for that particular report. I was wondering if anyone had a better idea. Thanks, JR -----Original Message----- From: JOHNWARDBELL at aol.com [mailto:JOHNWARDBELL at aol.com] Sent: Wednesday, March 30, 2005 10:25 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Dynamic number of rows on a report Hi Is using subreports too obvious or am I missing something. jwb -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This electronic transmission is strictly confidential to TNCO, Inc. and intended solely for the addressee. It may contain information which is covered by legal, professional, or other privileges. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy, or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message. While TNCO, Inc. uses virus protection, the recipient should check this email and any attachments for the presence of viruses. TNCO, Inc. accepts no liability for any damage caused by any virus transmitted by this email.