Jeff
Tue Aug 10 14:41:10 CDT 2004
Lee,
Thanks for the feedback.
The relationships are all one-to-one but there are three of them:
Letters->Client (1-to-1)
Letters->Debtor (1-to-1)
Letters->Collectors (1-to-1)
Each Letter (Grouped by Client and Debtor) contains one or more records per
report but each records only points to a single client, a single debtor, and
a single collector on the expressions cli_code, debt_code, and
substr(debt_code,1,1) respectively.
The only thing that doesn't work is the first page of the report and what's
missing from that page is some but not all of the fields from both the
client and debtor tables.
Thanks again,
Jeff
"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:Et4XPBxfEHA.3636@cpmsftngxa06.phx.gbl...
> Hi Jeff:
>
> As best as I can understand your scenario, you are trying to create a
> one-to many -to many (a multi child) report. The Visual FoxPro Report
> Designer cannot create such a nested report. However, there are
> workarounds to this limitation. Navigate to
>
http://fox.wikis.com/wc.dll?Wiki~MultiChildFoxProReports~VFP for one
> solution. Also,
> Cathy Pountney's book "The Visual FoxPro Report Writer: Pushing it to the
> Limit and Beyond" has a technique you can use to simulate multiple detail
> bands in the VFP Report Writer.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 Public Beta Now Available!! --*
> Download the VFP9 beta here:
http://msdn.microsoft.com/vfoxpro/
>
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
>
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
>
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
>
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
> >Hello All, Thanks in advance for any help.
>
> >I have a report which is basically a form letter. This letter is from our
> >clients (known as clients) and to our client's clients (known as
debtors).
> >The letter has to be signed by one of our staff (known as collectors).
>
> >I have a query results which contain the line items for each report
sorted
> >by Client and within client by debtor.
>
> >I have the following relationships
>
> >SET RELATION TO CLI_CODE INTO CLIENTS
> >SET RELATION TO DEBT_CODE INTO DEBTORS ADDI
> >SET RELATION TO SUBSTR(DEBT_CODE, 1, 1) INTO COLLECTORS ADDI
>
> >The report specifies the client's address from the client table, and the
> >debtors address from the debtor table.
>
> >The problem is that the first page of the report does not contain all of
> the
> >address information for either the client or the debtor. Every other page
> is
> >fine.
>
> >If I use a FOR clause in the report command the first letter as missing
> >info. Every other one is fine.
>
> >If I insert a blank record into the table (which is readwrite and indexed
> by
> >cli_code + debt_code) the problem will occur on that first (blank)
report
> >and then every other page will be fine.
>
> >I'm sure it is something simple and obvious that I'm overlooking but does
> >anyone have any ideas?
>
> >Thanks again,
>
> >Jeff
>