Group Footer: Highlighting a Change in Date

[Former Member]

Hi all,

I have a report that is grouped by date. All of my data is in the group footer, and the details are suppressed. Here is a sample of my report

          Age           Admission Date         

           5                    7/1/2016

           10                  7/1/2016

   ->     8                    7/2/2016         

           25                  7/2/2016
           32                  7/2/2016

   ->     14                  7/3/2016   

What I want to do is add highlighting to the rows when the admission date changes (rows with arrows). What is the best way to do this?

[abhilash_kumar]

Hi Nate,

Create a formula (@AdmissionDate) with this code:

shared datevar prev;

shared numbervar x := x + 1;

if x = 1 then

prev := date({Admission Date})

else

(

    shared datevar prev2 := prev;

    prev := date({Admission Date});

);

prev2;

Drag and drop this on the group footer. You may choose to suppress this formula field as we don't need it to display.

Go to the Section Expert > Highlight the Group Footer > Color tab > Click the formula button beside 'Color' and use this code:

if {@Admission Date} = date(0,0,0) OR {@Admission Date} = {Admission Date} then

crNoColor

else if {@Admission Date} <> {Admission Date} then

crSilver

-Abhilash