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: 112457 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Wednesday, November 08, 2006 8:27:50 PM         
   


> Can anyone offer any tips on getting multiple detail bands to work with a SQL Server database where the data is being accessed via remote views? Obviously, you can't set a relationship onto an unindexed remote view. I am thinking that I might need to have a function, called from each detail band's target alias expression, which extracts data into a temporary table and sets a relation to this.
>
> Does anyone have any experience of getting multiple detail bands to work with SQL?
>
> Thanks in anticipation
>
> John Jarman


It doesn't really have anything to do with SQL Server, it's an issue with having a flat file and wanting to see data in a relational way. But since you have a flat file, I'm not so sure that multiple details bands is what you really want. Are there different fields from the same set of records that you need to show in each detail band? Can you give more detail about the structure of the file and what you want to show?

-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