Cross Tab Component Formatting

[Jon_iSite]

Hi I have the following Data from a project plan

Event Name (Text)
Planned Start (Date)
Planned End (Date)
Forecast Start (Date)
Forecast End (date)
Actual Start (Date)
Actual End (date)

I am trying to represent it in a cross tab component.
I have put my 'Event name' in 'column'
I have put each date in 'summary', but told it not to sum for each field.
I have added nothing to Rows

When I run the report I get only one Row Label 'Planned Start' with 6 values, 1 for each date.

This is what I get

Actual Output.PNG (5.9 KiB) Viewed 1678 times

What I want is a caption for each date

This is what I need

Required Output.PNG (8.09 KiB) Viewed 1678 times

Is this possible - this is the designer

Here is what I have done in the designer

Designer Screen.PNG (31.25 KiB) Viewed 1678 times

[Alex K.]

Hello,

Can you please send us a test data as it present in the database for analysis.

Thank you.

[Jon_iSite]

SampleData.zip

(2.75 KiB) Downloaded 155 times

Here is a subset, with just event name, start date, end date

[Alex K.]

Hello,

In this case, you can use the Cross-Data component.

Thank you.