I currently have a cross tab as shown in the attachment. I would like to have something with the date as the column heading but Duty Hours, Duty Start Duty end as rows ie:
You can use the Date field as Column Groups, the Duty field as Row Groups and the Val field as Detail Values. This will create dynamic row and column groups based on the values of the fields. The attached image illustrates the suggested settings.
Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items