Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get column header value from Crosstab?

Hi,

I have created crosstab report now, I want to display last column header value into Group Header section. For this I had tried following logic

Create two formula field test1 and test2

test1 code:

     WhilePrintingRecords;

     Global dateTimeVar EEDate;

test2 code:

     WhileReadingRecords;

     Global dateTimeVar EEDate;

     EEDate := database.field

Now put test2 filed in detail section and test1 put in Group Header section. But didn't get correct value. I had also try to put test2 field into Group Footer section but the result is same.

I want to display 07/12/2014 as start date and 07/26/2014 as end date.

Can anybody help me please ?

Thanks in advance.

Former Member
replied

Hi Bhavin,

If the Crosstab is placed on the Group Header and if you've used a Date field as the column (set to print for each day) then you simply use this formula to display the start date and end date on the GH:

Minimum({date_field}, {Group_field}) & " to " & Maximum({date_field}, {Group_field})

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question