Hello,
When trying to style a crosstab column header, I get the above error message. Is there a work-around? I am trying to rotate the date text 45 degrees in the following scenario:
select 'dbr.title', 'Bloom';
select 'dbr.crosstab', 'Datee';
select 'dbr.crosstab.col', '1-15','1-16','1-17','1-18','1-19','1-20','1-21','1-22','1-23','1-24','1-25','1-26','1-27','1-28';
select 'dbr.css', '.text_vert {transform:rotate(315deg)}';
select 'dbr.header.colclass', 2, 'text_vert';
select 'dbr.header.colclass', 3, 'text_vert';
select 'dbr.header.colclass', 4, 'text_vert';
select 'dbr.hsum', '1BPT'; select 'dbr.hmax', 'BDE'; select 'dbr.hidecolumn.data', '1BPT'; select 'dbr.hidecolumn.data', 'DU1BPT'; select 'dbr.hidecolumn.data', 'BDE';
select f.FieldName As 'Field', v.SVN As 'Variety', DATE_FORMAT(s.SampleDate, '%c-%e') as 'Datee', b.BPct as '%', b.1BPT as '1BPT', b.DU1BPT as 'DU1BPT', DATE_FORMAT(DATE_ADD(s.SampleDate, INTERVAL b.DU1BPT DAY), '%b %e') as 'BDE'
FROM smi_test.Bloom b Join smi_test.SampleTable s ON b.SampleID = s.SampleID JOIN smi_test.Variety v ON s.VarietyID = v.VarietyID JOIN smi_test.Section se ON s.SectionID = se.SectionID JOIN smi_test.Block bl ON se.BlockID = bl.BlockID JOIN smi_test.field f ON bl.FieldID = f.FieldID ORDER BY Field, Variety ;
The code works fine on all of the columns except the crosstab columns.
Thanks!
