If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subreports behaving badly...
I have a master report that contains invoice header information and a
subreport that contains invoice details. The subreport works fine when run by itself but when inserted in the master (invoice header), it displays two instances of the subreport. This is being inserted in the detail section of the master. Any ideas why this is happening? Thanks, Mike |
#2
|
|||
|
|||
Subreports behaving badly...
I expect you have duplicate InvoiceID field values in your header record
source. -- Duane Hookom MS Access MVP "Mike" wrote in message ... I have a master report that contains invoice header information and a subreport that contains invoice details. The subreport works fine when run by itself but when inserted in the master (invoice header), it displays two instances of the subreport. This is being inserted in the detail section of the master. Any ideas why this is happening? Thanks, Mike |
#3
|
|||
|
|||
Subreports behaving badly...
I'm not finding that situation in the header record source (good suggestion
though!). The table only has one primary key and the query returns only one row. Don't know if this will help but here's the query for the header: SELECT DISTINCT dbo_customer.FULLNAME, dbo_customer.ADDR1, dbo_customer.ADDR2, dbo_customer.VILL, dbo_customer.STATE, dbo_customer.ZZP, dbo_HISTORY.SINV, dbo_HISTORY.BKG, dbo_HISTORY.CENT, dbo_HISTORY.CVIFLOC, tblSaleType.SaleType, dbo_HISTORY.PONUM, dbo_customer.QDLIC, dbo_customer.FEDLIC, dbo_customer.EIN, dbo_VILLAGE.VNAM, dbo_HISTORY.VOYNUM, dbo_HISTORY.DINV, dbo_HISTORY.VESSEL FROM tblSaleType INNER JOIN ((dbo_customer INNER JOIN dbo_HISTORY ON dbo_customer.CVIFLOC = dbo_HISTORY.CVIFLOC) INNER JOIN dbo_VILLAGE ON dbo_customer.VCOD = dbo_VILLAGE.VCOD) ON tblSaleType.SaleTypeCode = dbo_HISTORY.CACH WHERE (((dbo_HISTORY.SINV)=[Forms]![frmMain]![txtInvoiceNumber])); "Duane Hookom" wrote: I expect you have duplicate InvoiceID field values in your header record source. -- Duane Hookom MS Access MVP "Mike" wrote in message ... I have a master report that contains invoice header information and a subreport that contains invoice details. The subreport works fine when run by itself but when inserted in the master (invoice header), it displays two instances of the subreport. This is being inserted in the detail section of the master. Any ideas why this is happening? Thanks, Mike |
#4
|
|||
|
|||
Subreports behaving badly...
Are you suggesting that when you view the record source of the report in
datasheet view, you see only one record but your subreport duplicates? Have you set the link master/child properties of the subreport control? Do both instances of the subreport contain the exact same record? -- Duane Hookom MS Access MVP "Mike" wrote in message ... I'm not finding that situation in the header record source (good suggestion though!). The table only has one primary key and the query returns only one row. Don't know if this will help but here's the query for the header: SELECT DISTINCT dbo_customer.FULLNAME, dbo_customer.ADDR1, dbo_customer.ADDR2, dbo_customer.VILL, dbo_customer.STATE, dbo_customer.ZZP, dbo_HISTORY.SINV, dbo_HISTORY.BKG, dbo_HISTORY.CENT, dbo_HISTORY.CVIFLOC, tblSaleType.SaleType, dbo_HISTORY.PONUM, dbo_customer.QDLIC, dbo_customer.FEDLIC, dbo_customer.EIN, dbo_VILLAGE.VNAM, dbo_HISTORY.VOYNUM, dbo_HISTORY.DINV, dbo_HISTORY.VESSEL FROM tblSaleType INNER JOIN ((dbo_customer INNER JOIN dbo_HISTORY ON dbo_customer.CVIFLOC = dbo_HISTORY.CVIFLOC) INNER JOIN dbo_VILLAGE ON dbo_customer.VCOD = dbo_VILLAGE.VCOD) ON tblSaleType.SaleTypeCode = dbo_HISTORY.CACH WHERE (((dbo_HISTORY.SINV)=[Forms]![frmMain]![txtInvoiceNumber])); "Duane Hookom" wrote: I expect you have duplicate InvoiceID field values in your header record source. -- Duane Hookom MS Access MVP "Mike" wrote in message ... I have a master report that contains invoice header information and a subreport that contains invoice details. The subreport works fine when run by itself but when inserted in the master (invoice header), it displays two instances of the subreport. This is being inserted in the detail section of the master. Any ideas why this is happening? Thanks, Mike |
#5
|
|||
|
|||
Subreports behaving badly...
Hey Duane...my answers are between your questions:
"Duane Hookom" wrote: Are you suggesting that when you view the record source of the report in datasheet view, you see only one record but your subreport duplicates? Yes. But I think I'm getting two subreports not just duplicate rows. Have you set the link master/child properties of the subreport control? I have set them and removed them with the same result. Do both instances of the subreport contain the exact same record? Exact same record (or records depending on the invoice I'm inquiring on). The subreport has a frame around it and the frame is appearing twice with the same row(s) in each frame. This is why I think there are two instances of the subreport and not just a doubling of the rows. -- Duane Hookom MS Access MVP "Mike" wrote in message ... I'm not finding that situation in the header record source (good suggestion though!). The table only has one primary key and the query returns only one row. Don't know if this will help but here's the query for the header: SELECT DISTINCT dbo_customer.FULLNAME, dbo_customer.ADDR1, dbo_customer.ADDR2, dbo_customer.VILL, dbo_customer.STATE, dbo_customer.ZZP, dbo_HISTORY.SINV, dbo_HISTORY.BKG, dbo_HISTORY.CENT, dbo_HISTORY.CVIFLOC, tblSaleType.SaleType, dbo_HISTORY.PONUM, dbo_customer.QDLIC, dbo_customer.FEDLIC, dbo_customer.EIN, dbo_VILLAGE.VNAM, dbo_HISTORY.VOYNUM, dbo_HISTORY.DINV, dbo_HISTORY.VESSEL FROM tblSaleType INNER JOIN ((dbo_customer INNER JOIN dbo_HISTORY ON dbo_customer.CVIFLOC = dbo_HISTORY.CVIFLOC) INNER JOIN dbo_VILLAGE ON dbo_customer.VCOD = dbo_VILLAGE.VCOD) ON tblSaleType.SaleTypeCode = dbo_HISTORY.CACH WHERE (((dbo_HISTORY.SINV)=[Forms]![frmMain]![txtInvoiceNumber])); "Duane Hookom" wrote: I expect you have duplicate InvoiceID field values in your header record source. -- Duane Hookom MS Access MVP "Mike" wrote in message ... I have a master report that contains invoice header information and a subreport that contains invoice details. The subreport works fine when run by itself but when inserted in the master (invoice header), it displays two instances of the subreport. This is being inserted in the detail section of the master. Any ideas why this is happening? Thanks, Mike |
#6
|
|||
|
|||
Subreports behaving badly...
If you are getting two instances then I think you either have two invoice
records or you have two copies of the same subreport. -- Duane Hookom MS Access MVP "Mike" wrote in message ... Hey Duane...my answers are between your questions: "Duane Hookom" wrote: Are you suggesting that when you view the record source of the report in datasheet view, you see only one record but your subreport duplicates? Yes. But I think I'm getting two subreports not just duplicate rows. Have you set the link master/child properties of the subreport control? I have set them and removed them with the same result. Do both instances of the subreport contain the exact same record? Exact same record (or records depending on the invoice I'm inquiring on). The subreport has a frame around it and the frame is appearing twice with the same row(s) in each frame. This is why I think there are two instances of the subreport and not just a doubling of the rows. -- Duane Hookom MS Access MVP "Mike" wrote in message ... I'm not finding that situation in the header record source (good suggestion though!). The table only has one primary key and the query returns only one row. Don't know if this will help but here's the query for the header: SELECT DISTINCT dbo_customer.FULLNAME, dbo_customer.ADDR1, dbo_customer.ADDR2, dbo_customer.VILL, dbo_customer.STATE, dbo_customer.ZZP, dbo_HISTORY.SINV, dbo_HISTORY.BKG, dbo_HISTORY.CENT, dbo_HISTORY.CVIFLOC, tblSaleType.SaleType, dbo_HISTORY.PONUM, dbo_customer.QDLIC, dbo_customer.FEDLIC, dbo_customer.EIN, dbo_VILLAGE.VNAM, dbo_HISTORY.VOYNUM, dbo_HISTORY.DINV, dbo_HISTORY.VESSEL FROM tblSaleType INNER JOIN ((dbo_customer INNER JOIN dbo_HISTORY ON dbo_customer.CVIFLOC = dbo_HISTORY.CVIFLOC) INNER JOIN dbo_VILLAGE ON dbo_customer.VCOD = dbo_VILLAGE.VCOD) ON tblSaleType.SaleTypeCode = dbo_HISTORY.CACH WHERE (((dbo_HISTORY.SINV)=[Forms]![frmMain]![txtInvoiceNumber])); "Duane Hookom" wrote: I expect you have duplicate InvoiceID field values in your header record source. -- Duane Hookom MS Access MVP "Mike" wrote in message ... I have a master report that contains invoice header information and a subreport that contains invoice details. The subreport works fine when run by itself but when inserted in the master (invoice header), it displays two instances of the subreport. This is being inserted in the detail section of the master. Any ideas why this is happening? Thanks, Mike |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
calling subreports in subreports | ramadevi k via AccessMonster.com | Setting Up & Running Reports | 6 | March 25th, 2005 06:04 AM |
calling subreports in subreports | ramadevi k via AccessMonster.com | Setting Up & Running Reports | 0 | March 24th, 2005 04:45 AM |
Displaying subreports with more than one record | franciscan | Setting Up & Running Reports | 10 | March 17th, 2005 09:31 PM |
Opening Subreports with dates | Don Sealer | Using Forms | 1 | December 28th, 2004 02:19 AM |
Chart Objects Behaving Badly | Chris \( Val \) | Charts and Charting | 4 | April 26th, 2004 08:34 AM |