I had a solution to a this thread that was different than the ones suggested. thread767-1439697 The other options seemed to involve having access to the database in more than a read manner. I am in an environment where I have to develop reports in a copy of the production database then can only run the reports against the actual database so making an alias table is not an option. I work with Homecare and Hospice agencies and one of them wanted to be able to print a full page of labels for a single patient that contained the patient name, date of birth and medical record number These could be used to adhere to lab specimen containers. I created a standard report that has a grouping based on my record selection (the patient medical record number) that I wanted displayed in my labels. I then added 10 detail sections. In each sections I added a blank text field that I sized to 1 inch height as a gauge to the height of the sections. I then created a subreport that contained the tables required for the 3 items on my labels. The subreport is linked by the medical record number. This sub report was then sized to 2.69 inches and placed in one third of one of the detail sections. I hen saved the subreport as a report and made 28 more copies and gave them each a unique name (subreport2, subreport3...). I then added each one and sized them each to 2.69 inches and linked them on the medical record number and formatted them to not have borders and suppressed all sections except the detail.(saving the subreport for some reason adds and additional unsuppressed report header and footer. A little tedious but it works. So in the end these 30 subreports are arranged in the 10 detail sections to be like an Avery 5160, 3 wide by 10 row label sheet. Then you simply setup the other variables. Top and Bottom margins .5 inch, Left / Right .188 inch. Finally I started with the subreports in the vertical center of each detail sections. I then printed a sample and compared it the a sample Avery sheet and adjusted the placement of the subreports vertical position in each detail section to align to the labels. I also adjusted the width and horizontal placement as well. Hope this helps someone that is not a DB expert. the whole alias table thing was a big deep for me. Thank you
Bob Lafler
Bob Lafler