Page 1 of 1

Cross Tab Component Formatting

Posted: Tue Jan 31, 2017 3:44 pm
by 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
This is what I get
Actual Output.PNG (5.9 KiB) Viewed 1677 times
What I want is a caption for each date
This is what I need
This is what I need
Required Output.PNG (8.09 KiB) Viewed 1677 times

Is this possible - this is the designer
Here is what I have done in the designer
Here is what I have done in the designer
Designer Screen.PNG (31.25 KiB) Viewed 1677 times

Re: Cross Tab Component Formatting

Posted: Wed Feb 01, 2017 8:58 pm
by Alex K.
Hello,

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

Thank you.

Re: Cross Tab Component Formatting

Posted: Tue Feb 07, 2017 4:14 pm
by Jon_iSite
SampleData.zip
(2.75 KiB) Downloaded 155 times
Here is a subset, with just event name, start date, end date

Re: Cross Tab Component Formatting

Posted: Wed Feb 08, 2017 10:33 pm
by Alex K.
Hello,

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

Thank you.