Cross Tab Component Formatting
Posted: Tue Jan 31, 2017 3:44 pm
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.
What I want is a caption for each date
Is this possible - this is the designer
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.
What I want is a caption for each date
Is this possible - this is the designer