formating question

[espltd]

Hi just wondering if anyone knows any way to have the last entry displayed a group formated differently, like a different font color. I currently have
bike1
a
b
c
Bike2
e
f
g
would like c and g bolded or something simular, thanks.

 

[synapsevampire]

Try a formula in the right click the field->format field->Font->Color of something like:

whileprintingrecords;
if not(onlastrecord)
and
next({table.field}) <> {table.field} then
cryellow
else
crblack

Base the table.field on the group field

-k

 

[espltd]

thanks for the response. I am getting either a 0 or a 65xxx number, just wondering if i am missing something?

 

[lbass]

Right click on the detail field->format field->font->color->x+2 and enter:

if onlastrecord or
next({table.field}) <> {table.field} then
crRed else
defaultattribute

If you want it to be bold, then instead use the formula area for style and replace crRed with crBold.

-LB

 

[espltd]

Hi thanks for the response. I am using version 9.2.2.6 but noticed when I right click in the dtails field it does not have format field, just selections like snap to grid, rulers, guidlines, tooltips, ect.

 

[espltd]

Hi got it working partially. I have 3 groups and for the inner most group I only want the last value in the group formated differently so do not think I need the next({table.field}) <> {table.field} section. Just wondering if there is a ifonlastrecord in a group type of statement, thanks.

 

[lbass]

You NEED the next statement--that is what will identify the last record in the group. Not sure why your right click doesn't have format field, but anyway, select the field you want to format and then go to format in the toolbar->field->font-color->x+2 and enter:

if onlastrecord or
next({table.group3field}) <> {table.group3field} then
crRed else
defaultattribute

-LB

 

[espltd]

ok thanks will give it a try.

 

[espltd]

thanks, it worked!.