Help W/ Creating Dynamic Page Tabs

[kg2report]

HI.
I was wondering if anyone can help me with a project I have for work. I have a Crystal Report that has users with their first names, last names, zip codes, and other demographic fields. I'd like to create a page tab at the bottom of each page of the report. The tab would display the last record of each page with the first letter of the user's last name. In addition, is there a way that every time the letter changes, as the page changes, the tab would move slightly to the right?

Any help would be greatly appreciated. Thanks in advance.

kg

 

[lbass]

Add the following formula to the page footer:

whileprintingrecords;
stringvar x;
stringvar y := x;
numbervar rpt;
x := {User.Last Name}[1]; //replace with your user name field
if
x=y then
rpt := rpt+1;
if
pagenumber = 1 then
x else
replicatestring(chr(9), 6*(pagenumber-rpt))+x

-LB