Sami, I created subreports then loaded them into regions and "shift relative" the regions to each other. Subs 1-3 work great as before. Sub 4-5 same problems as before. Example: Subrep 4 has a title in Page Header "Physicians". It does not appear in preview. Move that title down to the Detail section and it repeats with every name as expected. Move it back to Page Header and no show. If I put it in the region outside of sub 4 and simply close the sub 4 page header it works, but subs 1-3 have titles in their sub page headers that still work. In Subrep 5, when building the sub with "See Data" on, adding cells show the expected data like usual. Move off the screen or save and data disappears even though the cell with field title is still there. Text written in sub 5 shows on preview, but no cells. There are a number of other report items that work great in normal reports, but I seem to have problems within them in the subreports. I keep looking for some small button or check box that I have missed to turn some feature on. V8 is up to date. Memory is 1G.
I'll keep plugging away. Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Tuesday, May 20, 2008 1:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Reports and Subreports Tom - Try putting each sub-report into its own region and change the "shift relative to" to be the preceding region. You can set each region to stretch and also set the line to be "No Line" so the region boundary is not visible. The region names will be sequentially numbered in the order that you locate the objects on the report. To prevent too much hair loss while you do this, be very careful as you locate the regions to place them in order from the top left report area on down so you can be sure which region to reference in each shift designation. Let us know how it goes ... Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Frederick Sent: Tuesday, May 20, 2008 1:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Reports and Subreports I need to make face sheets for information about people that will be 3-4 pages long for each person and could easily have 500 non-repeating, unrelated data items in a variety of text, columns, formats, checkboxes and tables. All the views and basic reports built for those views work great. Problems come when I start building these exact same report formats into subreports. 1. The first 3 subreports work perfect using Shiftrelative. These subreports have a short title in the page header section and the detail sections work well. 2. Starting with subreport 4 (which is built just like the others), problems start up. The page header simply goes away or details only show the first line. 3. Subreports 5+ simply do not show up in Preview. Deleting subreport2 and rebuilding it with the view used for subreport 4 works perfectly. Creating a new subreport 4 using the view used for the deleted subreport 2, results in the same data drop out. Looking through each subreport structure I cannot find any difference except Shiftrelative. Visible and Show Data is on. Is there a limitation in how many subreports can be in a single R:Base report? It would be great if each subreport acted like a self contained shell that could be stacked with other subs while linked by a common field. Or...is it better to simply skip the subreports for what I am trying to do? At the Indy SAT, it was suggested (if I recall right) to print sections of the report to RTF and save them to a table as Varchar and recombine the sections as variables in a final report. Being a really dim bulb that day has not helped in understanding this concept. Is there an available example that shows how this works? Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org
