SQL server 2000
Select * from Orders
Open pivot grid and drop shipcountry to Row field
add frieght to Data field as shown in pic.
Then Script to New Window and execute the Script. ADS displays a blank pivot grid instead of the original chart
select * from orders
go
.setPivotResultSettings 'Index=1,
RowFields="[ShipCountry] {None} ASC",
DataFields="[Freight] {Sum} ASC",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=535,
Chart="{column}",
RotX=312,
RotY=-8,
RotZ=0,
Zoom=20.606081,
ScaleData=true,
ShowLegend=true,
ShowGrid=true,
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
Width=16.0,
Height=10.0,
Depth=5.0,
SeriesSpacing=1.0,
CategorySpacing=1.0,
Font="PMingLiU-10",
TopColor="#E9D9A9",
BottomColor="#FFFFFF",
PanX=-8.0,
PanY=-5.0,
Lighting=Default,
View2D=false,
StackedPercent=false,
ShowValueAxis=true,
ShowCategoryAxis=true,
ShowSeriesAxis=true,
UseCategoryAxisRange=false,
MergeAxis=false,
SeriesAlias="default",
SeriesSubType="",
SeriesColumnType="Cube",
SeriesMin="default",
SeriesMax="default",
SeriesColor="default",
SeriesFunctionMetaData="true",
LegendPosition=Top Right,
LegendWidthType=Fit,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=false,
FixedCategoryCount=0,
ShowFields=true,
ShowTotal=false,
ShowSubTotal=false,
SortDataAscending=true'
|
110 KB
|
159 KB
Issue resolved in ADS build 7.4.34_2
Issue #2280 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Issue resolved in ADS build 7.4.34_2