CategoryAxisNumberFormat and CategoryAxisDateFormat are not working in script. Execute script below on Northwind and see results.
select top 50 * from orders
go
.setResultSettings 'Index=1,
CategoryFields="[ShippedDate] ASC",
SeriesFields="[Freight]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=300,
Chart="{column,line}",
RotX=324,
RotY=0,
RotZ=0,
Zoom=43.0,
ScaleData=true,
ShowLegend=true,
ShowGrid=true,
Title="",
TitleValue="",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
Width=24.0,
Height=10.0,
Depth=5.0,
SeriesSpacing=1.0,
CategorySpacing=1.0,
Font="Arial Unicode MS-BOLD-10",
TopColor="#EBF0F5",
BottomColor="#D7DCF5",
PanX=-4.000001,
PanY=-3.427267E-7,
Lighting=Default,
View2D=true,
StackedPercent=false,
ShowValueAxis=true,
ShowCategoryAxis=true,
ShowSeriesAxis=true,
ValueAxisNumberFormat=,
CategoryAxisNumberFormat=#,##0,
CategoryAxisDateFormat=MM-dd-yyyy,
UseCategoryAxisRange=false,
MergeAxis=false,
SeriesAlias="default,Slope",
SeriesFunction="Moving Average ( 0, 10 ) ",
SeriesSubType=",",
SeriesColumnType="Cube,Cube",
SeriesMin="default,default",
SeriesMax="default,default",
SeriesColor="default,default",
SeriesFunctionMetaData="true,true",
LegendPosition=Top Right,
LegendWidthType=Fit,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=false,
FixedCategoryCount=0'
Issue #2278 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |