Skip to Content
author's profile photo Former Member
Former Member

Group Footer: Highlighting a Change in Date

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 12, 2016 at 04:10 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.