Intersoft Community - WebGrid Enterprise - WebGrid Charts show IDs instead of Labels

WebGrid Charts show IDs instead of Labels

yudi — Wed, 09 Feb 2011 03:32:14 GMT

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.

WebGrid Charts show IDs instead of Labels

questica — Tue, 08 Feb 2011 09:24:54 GMT

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!

WebGrid Charts show IDs instead of Labels

yudi — Mon, 07 Feb 2011 23:44:06 GMT

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.

WebGrid Charts show IDs instead of Labels

questica — Tue, 01 Feb 2011 15:17:45 GMT

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

WebGrid Charts show IDs instead of Labels

yudi — Tue, 01 Feb 2011 03:13:59 GMT

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.

WebGrid Charts show IDs instead of Labels

questica — Mon, 31 Jan 2011 12:57:46 GMT

When I use charting on the WebGrids in my application, any ValueList columns display their integer ID numbers instead of the text from the valuelist.

The WebGrids in my application have columns and valuelists that are created and added dynamically at runtime (so they're not specified in the asp.net markup.)

In the "InitializeDataSource" event I provide a dataset with the grid's data and any lookups as tables. I set the columns' ValueLists' data sources in that same event.
I re-set the data source, DataTextField, and DataValueField in the PrepareDataBinding event.

This works great for all other grid functions - during display, edit, add, group, sort, and other operations, the lookups are always displayed correctly. But once I generate a chart it just shows ID numbers.

Is there a setting somwhere I can adjust to make these items appear? Thanks for your help!

note: I'm using the latest webui studio 2010, just purchased last week.