Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 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: 112574 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Thursday, November 09, 2006 7:18:31 PM         
   


> 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


Ah, so the problem is that the view is parameterized. (It still doesn't matter if it's remote or local.) A parameterized view just doesn't work well for reports. Can you change the view so that you have an option to pull everything you need for the report?

-BP
www.peisch.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