Displaying alphabetic range of records

[teddles]

I have a report that groups on a string field. How can I display the alphabetic range of the Grp Header values that list on each page?.
e.g.
First Grp header on page = CDE
Last Grp header on page = FGH
Value to display (in page footer) = "C-F".

Thanks

 

[poujor]

In the Page header insert the formula:
global Stringvar top:=GroupName ({@The formula or field you group on})[1]
Suppress this formula.
In the page footer insert a formula:
global Stringvar top;
top &" - "& Right(GroupName (The formula or field you group on}),1)

 

[Ngolem]

Your post is confusing

*************
First Grp header on page = CDE
Last Grp header on page = FGH
Value to display (in page footer) = "C-F".
*************

Are these 2 groups? or 2 groupings for the same group?

GIve us a real data example so we can see what you want

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[lbass]

A variation on poujor's post:

{@first} for the page header:
whileprintingrecords;
stringvar first := {Product.Product Name}[1];

{@last} for the page footer:
whileprintingrecords;
stringvar first;
stringvar last := left({Product.Product Name},1);
stringvar output;

output := first + " - "+ last;

-LB

 

[teddles]

Thanks for the solution guys - much appreciated.
There is one complication however. The last page of my report is the report footer formatted with 'New Page Before'. It contains a summary X-tab table.
How can I suppress either the formula providing the alphabetic range or the page footer itself, on this last page. As it stands, the alphabetic formula on the last page footer is returning values from the second last page!!.

teddles

 

[lbass]

Use the following formula either on the field or on the section:

pagenumber = totalpagecount

-LB

 

[teddles]

Thanks LB. The solutions can be so simple when you know how!!.
As you can tell by my posts, I haven't quite reached Guru status with CR yet

Teddles