Hi
I Have the following DataSet structure:

Price__MakeID__SourceID__Day
100______1________1_______1 
101______1________1_______2 
101______1________1_______3 
101______1________1_______4 
101______1________1_______5 
101______1________1_______6 
102______1________1_______7 
102______1________1_______8 
102______1________1_______9 
100______1________2_______1 
102______1________2_______2 
102______1________2_______3 
102______1________2_______4 
103______1________2_______5 
103______1________2_______6 
102______1________2_______7 
101______1________2_______8 
100______1________2_______9 

100______2________1_______1 
101______2________1_______2 
101______2________1_______3 
101______2________1_______4 
101______2________1_______5 
101______2________1_______6 
102______2________1_______7 
102______2________1_______8 
102______2________1_______9 
100______2________2_______1 
102______2________2_______2 
102______2________2_______3 
102______2________2_______4 
103______2________2_______5 
103______2________2_______6 
102______2________2_______7 
101______2________2_______8 
100______2________2_______9 

Basically I am tracking the price of products from a number of sources over a number of days.

How would I bind this dataset to a Line Grid so that the y axis shows the price, the x axis shows the Day and lines on the grid show the variation in price by make (different color line for each source)

Any pointers would be great!

Thanks

I have a pretty simple grid that I want the users to be able to expand the row for more information. The issue I am having is that the default ExpandCollapseColumn the grid drops in is something like 100px wide (maybe wider) and shows images of both a right-pointing icon and a left-pointing icon (e.g. " >      < ").

The following is my grid declaration:

<telerik:RadGrid runat="server" ID="grdResults" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" GridLines="None" OnNeedDataSource="grdResults_NeedDataSource" >
    <MasterTableView DataKeyNames="ClaimId" CommandItemDisplay="None" PageSize="50" Width="100%" HierarchyLoadMode="ServerOnDemand">
        <RowIndicatorColumn> 
            <HeaderStyle Width="20px"></HeaderStyle> 
        </RowIndicatorColumn> 
        <ExpandCollapseColumn> 
            <HeaderStyle Width="20px"></HeaderStyle> 
        </ExpandCollapseColumn>
        <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" Position="Bottom" />
        <Columns>
            <telerik:GridBoundColumn UniqueName="claimIdColumn" DataField="ClaimId" HeaderText="" Visible="false"></telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="policyIdColumn" DataField="PolicyId" HeaderText="" Visible="false"></telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="carrierIdColumn" DataField="CarrierId" HeaderText="" Visible="false"></telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="fileNumberColumn" DataField="FileNumber" HeaderText="File Number"></telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="carrierNameColumn" DataField="CarrierFormattedName" HeaderText="Carrier Name"></telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="carrierPolicyNumberColumn" DataField="PolicyNumber" HeaderText="Policy Number"></telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="carrierClaimNumberColumn" DataField="ClaimNumber" HeaderText="Claim Number"></telerik:GridBoundColumn>
            <telerik:GridDateTimeColumn UniqueName="lossDateColumn" DataField="LossDate" HeaderText="Date of Loss" DataFormatString="{0:M/d/yyyy}"></telerik:GridDateTimeColumn>
            <telerik:GridBoundColumn UniqueName="insuredNameColumn" DataField="PolicyHolderDisplayName" HeaderText="Insured Name"></telerik:GridBoundColumn>
            <telerik:GridTemplateColumn UniqueName="lossCityStateColumn" HeaderText="Loss Location" SortExpression="Location">
                <ItemTemplate>
                    <%# Eval("LossCity") %>,&nbsp<%# Eval("LossState") %>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridBoundColumn UniqueName="lossPostalColumn" DataField="LossPostal" HeaderText="Loss ZIP"></telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="lossCatNumber" DataField="CatNumber" HeaderText="CAT No."></telerik:GridBoundColumn>
        </Columns>
        <NestedViewSettings>
            <ParentTableRelation>
                <telerik:GridRelationFields DetailKeyField="ClaimId" MasterKeyField="ClaimId" />
            </ParentTableRelation>
        </NestedViewSettings>
        <NestedViewTemplate>                                               
            <asp:Panel runat="server" ID="pnlDetails" BackColor="Ivory" >
                <fieldset style="padding:10px;">  
                    Details will go here.
                </fieldset>
            </asp:Panel>
        </NestedViewTemplate>
        <NoRecordsTemplate>
            No data found
        </NoRecordsTemplate>
    </MasterTableView>
</telerik:RadGrid>

Searched through the forum for answers and everything I have tried doesn't seem to work. There is one thread that suggests setting the MasterTableView-ExpandCollapseColumn-HeaderStyle-Width in the grid declaration but that was unsuccessful. In addition, there were various suggestions of changing the width on OnColumnCreated event but that too did not work.

I have the 2011 Q1 Release of the tools and am running IE8 (both compatibility mode on and off). Any kind of help would be greatly appreciated.

~ Jon

Hi,

I am having an issue getting the dialogs to work for the RadEditor.  When I click one of the icons that use Dialogs I get the dialog but the "Insert" button does nothing.  I added the path properties to the RadEditor and added images to those folders.  The dialog that shows has the formatted columns and the "insert" button but nothing else.

Hi,

I have a requirement to generate the RadGrid Columns at runtime. Also the data supplied to the grid as the Data Source would be the result of a transpose.

            I have tables in my database that store the definitions for the structure of the grid. The tables define the number of columns, type of column to be used, header text, tooltip, group that the column belongs to, the auto generated id of the column, etc as shown in the attached image Post1.png.

 We might have additional add-ons to the set of properties of the table that would be stored later. For example an additional column called PARENT_COLUMN may be added to the above schema as shown in the attached image Post2.png.

. Based on the definition, columns would need to be constructed into a RadGrid whose tag is statically defined in the .aspx.

Example, the following would be placed on the aspx page.

<telerik:RadGrid ID=’grdDynamic’ runat=’server’ />

The grid has to support inline editing. Also the headers have to support grouping, i.e. rowspan and colspan.

The following structure is an example.

            The data which is added into the grid, displayed into the grid is transposed. I have a few tables with the same structure except for where the name of the primary representative columns in the grid changes.

For instance in the below displayed grid the CHECKLIST_ITEM_ID is the primary representative. In this case this might be autogenerated. We may also have a column , say ‘XYZ’, which might be a FOREIGN KEY to another table.

‘XYZ’ may not be autogenerated..

 The tables contain the reference column which points to the relative record to which the current item belongs to. For example, we have a table which stores all the grid structures defined as templates. TEMPLATE_ID represents each structure defined.Refer to image Post3.png

We have another table that contains the structure of the grid. In this table TEMPLATE_FIELD_ID is the primary key whereas TEMPLATE_ID is the foreign key that defines the TEMPLATE or grid to which these columns belong to.Refer to image Post4.png

The data for this particular template is stored in a third table which stores the TEMPLATE_FIELD_ID, i.e. the ID of the column in the database, the ROW_NUM , which represents the row number of the item in the table, the Item, which stores the value entered by the user in the cell represented by the ROW_NUM, TEMPLATE_FIELD_ID,CHECKLIST_ID.

The CHECKLIST_ID represents the checklist that is created using the template as start.

Multiple checklists can be created using one TEMPLATE.Refer to image Post5.png

The code should handle the transpose of the data to get the data in the required format.

Also, it should create the grid at runtime.

I would like the programmer to have minimum effort to get the work done as it is to be done in multiple places.

Also, it would be better if you provided us with a custom Grid Control that would take very minimum parameters to get the work done. The code should also be easy to maintain as in the long run we are expecting to have more changes to the structure. Also it should provide flexibility to provide join querys . On the insert/update/delete command it should either perform the required actions automatically or provide the updated values in the untransposed format in a simple manner so that the developer can perform the required operations.

Thanks in Advance.