Jim Lawrence
accessd at shaw.ca
Sun Jul 8 14:32:15 CDT 2007
Hi Rocky: I may go the route of a subreport or use A.D. Tejal's eloquent solution. All the data is assembled on the fly and can basically be grouped in any method. As previously stated, why doesn't MS Access report allow columns to be controlled per Group? Thanks for the suggesting so now I know all of the options available. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Saturday, July 07, 2007 5:20 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Reports rinting accross Jim: How about section C is one text box with width = width of the report, and Can Grow=True. Are sections A, B, and C sub-reports? Or do you create their controls on the fly? In any event, in the Open event of the report I'd still create a temp table - this time 2 fields, one would be the PK = whatever field it is that ties section C to sections A and B, second field would be the Ref#/Client Name concatenations. Create a temp table record for each section A/B and use that temp table data for section C. Maybe make section C a sub report with the temp table as its record source and linked to the main report through the PK? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Saturday, July 07, 2007 9:02 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Reports rinting accross Hi Rocky: These columns are fixed length. The wrinkle to the design requirements is that there are 3 individual sections within the report and the data source is in one table and it looks like as follows: Ref#, Client-Name, Account-Detail, Date, Payment The data is sorted so it group appropriately; Date, Client-Name etc. Programming within the report determines which section it is and how it will be printed. The following is a text imitation of the report and how it will print: MY REPORT --------- Line 1: Section A: Acquired Line 2: Ref#, Client-Name, Account-Detail, Date, Payment ... Line 11: Section B: Prospect Line 12: Account-Detail, Date, Payment Line 13: Account-Detail, Date, Payment ... Line 25: Section C: Referral Line 26: Ref#, Client-Name Line 27: Ref#, Client-Name Line 28: Ref#, Client-Name Line 29: Ref#, Client-Name Line 30: Ref#, Client-Name Line 31: Ref#, Client-Name ... Section C could go on for pages but would be more compact if it looked like: Line 26: Ref#, Client-Name, Ref#, Client-Name, Ref#, Client-Name Line 27: Ref#, Client-Name, Ref#, Client-Name, Ref#, Client-Name ... The Report would have to be able to something as follows. Within program control the report would have to pause while continuing to step through the data, accumulating the records in an array and when 3 records were gathered or the end of that section was reached, it would release the pause, print out and continue... I am sure it is doable... Any suggestions would be greatly appreciated. TIA Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of rockysmolin at bchacc.com Sent: Saturday, July 07, 2007 6:28 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Access Reports rinting accross Are the records fixed length or variable? For variable, I'd use a temp table with one record, and concatenate the original records into temp table records, using a fixed width font. Then bind the report to the temp table. I suppose you could do the same for fixed length records as well. HTH Rocky Original Message: ----------------- From: Jim Lawrence accessd at shaw.ca Date: Sat, 07 Jul 2007 00:53:17 -0700 To: accessd at databaseadvisors.com Subject: [AccessD] Access Reports rinting accross Hi All: Is there a way to print across the page within an Access report? Like in the following example: Record01 record02 record03 record4 record5 Record06 record07 record08 record9 record10 record11 record12 record13 record14 record15 record16 record17 record18 record19 record20 etc......... MTIA Jim -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------------------------------------------------------------- myhosting.com - Premium MicrosoftR WindowsR and Linux web and application hosting - http://link.myhosting.com/myhosting -- 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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.2/890 - Release Date: 7/7/2007 3:26 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com