Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 To: Bob Lawson
  Where is Bob Lawson?
 Oakville, Ontario
 Canada
 Bob Lawson
Subject: RE: Data Grouping and variables
Thread ID: 96055 Message ID: 96062 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Reports and Printers
Date: Monday, May 15, 2006 7:59:55 PM         
   



> I want to save a description from the greoup header and use it again in the group footer.
>
> Something like:
> Cash Accounts <- Group header
> account
> account
> Total - Cash Accounts <- Group footer
>
> I want to save the value 'Cash Accounts' into a variable so I can use it in the footer.
> It seems when I try and assign it anywhere that VFP is intrepreting the equal(=) as a comparison and not assignment operator.
>
> Also I tried to define variables in the init:
> Public cLevel1 as character
>
> but when I go to use it it VFP sees the variable is logical!
>
> Any suggestions would be appreciated.


As Borislav suggests, you can use a field from the table driving the report for this. I'm assuming you have a group by expression on this field, and are using the field in the group header. If that's the case, using the same field in the footer will work just fine.

-BP
www.peisch.com

ENTIRE THREAD

Data Grouping and variables Posted by Bob Lawson @ 5/15/2006 7:34:44 PM
RE: Data Grouping and variables Posted by Borislav Borissov @ 5/15/2006 7:52:50 PM
RE: Data Grouping and variables Posted by Barbara Peisch @ 5/15/2006 7:59:55 PM
RE: Data Grouping and variables Posted by Bob Lawson @ 5/15/2006 8:43:17 PM
RE: Data Grouping and variables Posted by Yuri Rubinov @ 5/15/2006 8:52:41 PM
RE: Data Grouping and variables Posted by Bob Lawson @ 5/15/2006 9:02:32 PM
RE: Data Grouping and variables Posted by Yuri Rubinov @ 5/15/2006 9:06:09 PM
RE: Data Grouping and variables Posted by Barbara Peisch @ 5/15/2006 8:58:07 PM
RE: Data Grouping and variables Posted by Yuri Rubinov @ 5/15/2006 8:01:32 PM
RE: Data Grouping and variables Posted by Yuri Rubinov @ 5/15/2006 9:29:03 PM