Razzak, Thanks for your prompt response. I will check your suggestions and the samples.
Thank you. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, 16 February 2016 5:35 p.m. To: [email protected] Subject: [RBASE-L] - Re: Subreport Issue At 11:11 PM 2/15/2016, John Docherty wrote: >I would appreciate any advice on the following issues that I cannot resolve. > >I have a report which has a subreport in the detail section. This is >based on a view which has one column in common with the main report and >a variable number of rows (the view is updated for each detail row as a >before generate eep). The problem I have is that when I have more than >one row in the view only one will print. > >I also find that if I print the report for each plant item individually >as pri AG_AHU_IND_PORT where pref contains 'ahu1/2' >the sub report is printed, (albeit with only one row), however if I use >pri AG_AHU_IND_PORT where pref contains 'ahu1/' >there is no sub report appearing for ahu1/2. >I have the number of passes set to 2 and I am using XE. >I have tried many 'options' all to no avail. If anyone has any >suggestions as to what I may have wrong they would be most appreciated. John, Without knowing all details and the layout of the report and sub-report, make sure that all sub-report details are also placed under the [Detail] band of the sub-report. Keep in mind that when printing a report with sub-report, the WHERE clause is always pertinent to the Master table. For a sample report to illustrate the use of such technique take a close look at the sample "CustomerContacts" report included with RRBYW19. Database: RRBYW19 Report..: CustomerContacts Associated Tables: Customer, Contact Common Column....: CustID Hope that provides you with some blue's clues ... Very Best R:egards, Razzak
