It is the default behavior of WebGrid that when the grid’s view is set to pivot chart view then the ValueList column will displays their integer ID numbers instead of the text from the ValueList.

When the PivotChartView is enabled, the column displayed at the chart UI will be the original column provided to WebGrid itself. In order to show the text instead of the integer ID numbers, please try to modify your query for example: the CategoryID column in Products table used to be filled by CategoryName using ValueList, please use the inner join query to Category table in order to get the text as the representation of the integer ID number.

Hope this helps.

Hi Yudi,

I'm not totally clear on your suggestion.  Are you saying I should remove my lookup column and replace it with a text column?

Are you saying that the charting feature can't work with value lists?

Thanks,

James

The fields that shown in Chart Field List are the fields that defined in WebGridColumn object.

The sample below will help to describe the behavior.

Case #1:

WebGrid is bind to Products table of Northwind.mdb file through AccessDataSource. The select command of the AccessDataSource is defined as follow: "SELECT ProductID, ProductName, CategoryID FROM [Products]".

The WebGridColumn is defined as follow.

<Columns>
    <ISWebGrid:WebGridColumn Caption="ProductID" DataMember="ProductID" DataType="System.Int32"
        Name="ProductID" Width="100px">
    </ISWebGrid:WebGridColumn>
    <ISWebGrid:WebGridColumn Caption="ProductName" DataMember="ProductName" Name="ProductName"
        Width="100px">
    </ISWebGrid:WebGridColumn>
    <ISWebGrid:WebGridColumn Caption="CategoryID" DataMember="CategoryID" DataType="System.Int32"
        Name="CategoryID" Width="100px">
        <ValueList DataSourceID="AccessDataSource2" DataTextField="CategoryName" DataValueField="CategoryID">
        </ValueList>
    </ISWebGrid:WebGridColumn>
</Columns>

When the view is switch to PivotChart view, the CategoryID will be shown as integer, instead of the text from the ValueList.

Case #2:

WebGrid is bind to Northwind.mdb using following select command: “SELECT ProductID, ProductName, CategoryName FROM (Products INNER JOIN Categories ON Categories.CategoryID = Products.CategoryID) ORDER BY ProductID”.

The WebGridColumn is defined as follow.

<Columns>
    <ISWebGrid:WebGridColumn Caption="ProductID" DataMember="ProductID" DataType="System.Int32"
        Name="ProductID" Width="100px">
    </ISWebGrid:WebGridColumn>
    <ISWebGrid:WebGridColumn Caption="ProductName" DataMember="ProductName" Name="ProductName"
        Width="100px">
    </ISWebGrid:WebGridColumn>
    <ISWebGrid:WebGridColumn Caption="CategoryName" DataMember="CategoryName"
        Name="CategoryName" Width="100px">
    </ISWebGrid:WebGridColumn>
</Columns>

When the view is switch to PivotChart view, the CategoryName text will be shown in the Chart Field List.

Hope this helps.

Hi Yudi,

Thanks for taking the time to put that together.  Just a couple more questions:

Is there a way to hide the "ProductID" column from charting, so that only the ProductName column is visible?  I have a large number of lookup fields in many grids, so all those ID columns being visible would be undesirable.

Is there any plan to support ValueLists in charts in the future?

Thanks!

Is there a way to hide the "ProductID" column from charting, so that only the ProductName column is visible? I have a large number of lookup fields in many grids, so all those ID columns being visible would be undesirable.

The main Pivot Charting’s User Interface consists of two main parts: Ribbon UI and Pivot Surface Area. The Chart Field List is one of the six essential user interface element in Pivot Surface Area. It represents the fields available for pivot charting. The available fields are WebGridColumn objects which ShowInChartFieldList property is set to True.

In order to hide the “ProductID” column from charting, please try to set the value of ShowInChartFieldList property in the “ProductID” column (WebGridColumn object) to False.

...
<Columns>
    <ISWebGrid:WebGridColumn Caption="ProductID" DataMember="ProductID" Name="ProductID"
        Width="100px" ShowInChartFieldList="False">
    </ISWebGrid:WebGridColumn>
</Columns>
...

Is there any plan to support ValueLists in charts in the future?

I need to check the roadmap of WebGrid, especially the chart feature, to determine whether the feature will support ValueList or not.

Hope this helps.