Grouping Help

[Barrow66]

I have a report that has column name CurrentVBDate.
I want to populate this column (CurrentVBDate) with data from other columns.
The other columns are PreviousVBDate, NextSequentialVBDate and NextSequentialVBDate.
I am using CR8.5.
Any assistance will be appreciated and thanks in advance for your help.

 

[checkai]

What do you need to populate the Field with? Can you be more specific regarding your data/grouping?

DLC

 

[Ngolem]

I assume that - PreviousVBDate, NextSequentialVBDate and NextSequentialVBDate are fields within one record and only one is NOT NULL BTW that 2nd and 3rd field are the same...I renamed it "LastSequentialVBDate" for this demonstration

You could group on all of these using the following formula

@Group1

if not isnull(table.PreviousVBDate} then
{table.PreviousVBDate}
else if not isnull(table.NextSequentialVBDate} then
{table.NextSequentialVBDate}
else if not isnull(table.LastSequentialVBDate} then
{table.LastSequentialVBDate};

You should have a default condition in case all were null but that is how you could group them in one group dynamically



Jim Broadbent