Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Frank Cazabon
  Where is Frank Cazabon?
 
 Trinidad And Tobago
 Frank Cazabon
 To: John Jarman
  Where is John Jarman?
 Belper, Derbyshire
 United Kingdom
 John Jarman
 Tags
Subject: RE: Multiple Detail Bands and SQL Server
Thread ID: 112412 Message ID: 112543 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Thursday, November 09, 2006 2:45:18 PM         
   


Hi John,

I haven't worked with views in ages, but can't you create indexes on them? I'm sure I used to.

> 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




Frank.

Frank Cazabon
Samaan Systems Ltd.
www.SamaanSystems.com/

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