Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: John Jarman
  Where is John Jarman?
 Belper, Derbyshire
 United Kingdom
 John Jarman
 To: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 Tags
Subject: RE: Multiple Detail Bands and SQL Server
Thread ID: 112412 Message ID: 112524 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Thursday, November 09, 2006 10:24:26 AM         
   


I am just trying to make use of the powerful multiple detail bands facility. One example is a report which runs off a list of customers. I have set up relationships from the customer list into the contacts, orders and ledger tables. Using the multiple detail bands, the report can show the contacts, o/s orders, invoices and payments for each customer. This all works wonderfully using a VFP database. With SQL the related data is in remote views, not tables, which means I can't set a relationship. Instead, we use a function to requery the remote views each time the record pointer moves in the base report data table (this has been extracted into a temp VFP table by a query). The function is called via a report variable which is set to call it. This was designed to handle a one to one relationship for lookup values, e.g. customer names.

I think what I will need to do for multiple detail bands is to create a temporary table to sit alongside each view. I can then index the table, set a relationship to it from the base report table and fill it with data each time the view is requeried. This is a bit messy, which is why I was asking for any advice on any alternate methods.

I guess it might work with cursor adaptors, but we haven't gone down that road with our software yet.

John Jarman

ENTIRE THREAD

Multiple Detail Bands and SQL Server Posted by John Jarman @ 11/8/2006 10:51:10 AM
RE: Multiple Detail Bands and SQL Server Posted by Barbara Peisch @ 11/8/2006 8:27:50 PM
RE: Multiple Detail Bands and SQL Server Posted by John Jarman @ 11/9/2006 10:24:26 AM
RE: Multiple Detail Bands and SQL Server Posted by Frank Cazabon @ 11/9/2006 2:45:18 PM
RE: Multiple Detail Bands and SQL Server Posted by Barbara Peisch @ 11/9/2006 10:22:13 PM
RE: Multiple Detail Bands and SQL Server Posted by Barbara Peisch @ 11/9/2006 7:18:31 PM