Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print the First record on page Footer 1

Status
Not open for further replies.

Nro

Programmer
May 15, 2001
337
CA
Hi all.

I'm using Crystal 8.5. I have a customer list (Name, address and Phone number)

I want to print the name of the first Customer of the page to the print footer (like a dictionary). I've never use functions with memory variables, but I can understand VB code.

Thanks in advance.

Nro
 
Create 3 formula.
Formula one - placed in the page header band and suppressed

whileprintingrecords;
numbervar reset :=0

Formula 2 - placed (and suppressed) in band containing Customer Field.

whileprintingrecords;
numbervar reset;
stringvar name;
if reset=0 then
(reset:=1;
name:={Custoomer.Name})
else
name:=name


Formula 3. Placed in Page Footer
whileprintingrecords;
stringvar name;



Mike
 
Thanks Mike.

Fast and precise answer, exactly what I like from this Forum.

One star for you!

Have a nice Day

Nro
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top