Hi,
My application supports two profiles.. Basic and advanced.
Users with basic profile will get a basic view of the UltraWebGrid with sorting and filtering. No editing allowed here.
Advanced users will be able to add/update records in the grid along with sorting / filtering
I have already tried various levels (LevelZero to LevelTwo ) supported by
this.UltraWebGrid.DisplayLayout.ReadOnly
Still, I don't get sorting / filtering capabilities. Instead I receive javascript errors...
Any clue, what can be done in this regards?
Here is the grid code. My objective is to improve the performance for basic users by delivering HTML that solves basic purpose
i.e formatting, sorting and searching....
<igtbl:UltraWebGrid ID="grPF" runat="server" OnInitializeRow="grPF_InitializeRow" OnInitializeLayout="grPF_InitializeLayout" OnDeleteRow="grPF_DeleteRow" Width="100%" Height="697px"> <DisplayLayout CellClickActionDefault="Edit" AllowUpdateDefault="Yes" AllowDeleteDefault="Yes" AutoGenerateColumns="False" AllowColSizingDefault="Fixed" AllowAddNewDefault="Yes" RowHeightDefault="20px" HeaderClickActionDefault="SortSingle" StationaryMargins="HeaderAndFooter" SelectTypeRowDefault="Single" AllowSortingDefault="OnClient" TableLayout="Fixed" UseFixedHeaders="true" Version="4.00" BorderCollapseDefault="Separate" Name="grPF" SortCaseSensitiveDefault="False"> <FrameStyle Height="697px" Width="100%" HorizontalAlign="Center"> </FrameStyle> <HeaderStyleDefault Wrap="True" HorizontalAlign="Center" Cursor="Hand"> </HeaderStyleDefault> <FooterStyleDefault HorizontalAlign="Right"> </FooterStyleDefault> <FilterOptionsDefault AllowRowFiltering="OnClient" FilterUIType="HeaderIcons"> </FilterOptionsDefault> <ClientSideEvents BeforeRowDeletedHandler="BeforeRowDelete" BeforeEnterEditModeHandler="BeforeEnterEditMode" BeforeRowInsertHandler="BeforeRowInsert" AfterRowDeletedHandler="AfterRowDelete" AfterRowInsertHandler="AfterRowInserted" EditKeyDownHandler="EditKeyDownHandler" InitializeLayoutHandler="CientPageSize" AfterRowFilterApplied="AfterFilterApplied" AfterCellUpdateHandler="AfterCellUpdate" AfterExitEditModeHandler="AfterExit"/> <AddNewRowDefault Visible="Yes"> <RowStyle> <BorderDetails WidthLeft="1px" WidthRight="1px" WidthTop="1px" WidthBottom = "1px" ColorTop="Red" StyleTop="Solid" ColorLeft="Red" ColorRight="Red" /> </RowStyle> </AddNewRowDefault> <RowAlternateStyleDefault BackColor="#FAFAFA"> </RowAlternateStyleDefault> </DisplayLayout> <Bands> <igtbl:UltraGridBand DataKeyField="FeatureID" ColFootersVisible="Yes"> <Columns> <igtbl:UltraGridColumn AllowRowFiltering="False" BaseColumnName="FeatureFlag" DataType="System.Boolean" IsBound="True" Key="FeatureFlag" Type="CheckBox" Width="50px"> <Header Caption="RTF Enabled" Title="RTF Enabled"> </Header> <CellStyle HorizontalAlign="Center"> </CellStyle> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn BaseColumnName="UseCaseName" DataType="System.Int32" IsBound="True" Key="UseCaseId" Type="DropDownList" Width="241px"> <HeaderStyle Cursor="Hand" /> <Header Caption="UseCase Name"> </Header> <ValueList DisplayMember="UseCaseName" Key="UseCaseId" ValueMember="UseCaseId"> </ValueList> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowRowFiltering="False" AllowUpdate="No" BaseColumnName="FeatureNumber" FooterText="#" FooterTotal="Count" IsBound="True" Key="FeatureNumber" Width="50px"> <Header Caption="Feature Number"> </Header> <CellStyle BackColor="#EBEBEB" HorizontalAlign="Center"> </CellStyle> <Footer Caption="#" Formula="COUNT([FeatureNumber])" Total="Count"> </Footer> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowRowFiltering="False" BaseColumnName="FeatureName" FieldLen="500" IsBound="True" Key="FeatureName" Width="313px"> <Header Caption="Feature Name"> </Header> <Validators > <igtbl:ValidatorItem Value="reqField" /> </Validators> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowRowFiltering="False" BaseColumnName="FeatureEstimate" DataType="System.Double" FooterText="&#931" FooterTotal="Sum" IsBound="True" Key="FeatureEstimate" Width="80px"> <Header Caption="Reference Size Estimate(SP)" Title="Reference Size Estimate(in Story Points)"> </Header> <CellStyle HorizontalAlign="Right"> </CellStyle> <Footer Caption="&#931" Formula="ROUND(SUM([Total]),2)" Total="Sum"> </Footer> <Validators > <igtbl:ValidatorItem Value="reqField" /> <igtbl:ValidatorItem Value="regSP" /> </Validators> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn BaseColumnName="Priority" IsBound="True" Key="Priority" Type="DropDownList" Width="60px"> <Header Caption="Criticality"> </Header> <CellStyle HorizontalAlign="Center"> </CellStyle> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowRowFiltering="False" BaseColumnName="Weightage" DataType="System.Double" IsBound="True" Key="Weightage" Width="48px"> <Header Caption="Priority"> </Header> <CellStyle HorizontalAlign="Right"> </CellStyle> <Validators > <igtbl:ValidatorItem Value="reqField" /> <igtbl:ValidatorItem Value="regPriority" /> </Validators> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowUpdate="No" BaseColumnName="FeatureStatusName" IsBound="True" Key="FeatureStatusName" Width="65px"> <HeaderStyle Cursor="Hand" /> <Header Caption="Status"> </Header> <CellStyle HorizontalAlign="Center"> </CellStyle> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowRowFiltering="False" AllowUpdate="No" BaseColumnName="PercentageCompleted" DataType="System.Double" Format="##.##" HeaderClickAction="SortSingle" IsBound="True" Key="PercentageCompleted" Width="80px"> <HeaderStyle Cursor="Default" /> <Header Caption="% Completion" ClickAction="SortSingle" Title="Percentage Completed"> </Header> <CellStyle BackColor="#EBEBEB" HorizontalAlign="Right"> </CellStyle> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowRowFiltering="False" BaseColumnName="FeatureID" Hidden="True" IsBound="True" Key="FeatureID" Width="1px"> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowRowFiltering="False" BaseColumnName="FeatureStatusID" Hidden="True" IsBound="True" Key="FeatureStatusID" Width="1px"> </igtbl:UltraGridColumn> </Columns> <AddNewRow Visible="Yes" View="NotSet"> </AddNewRow> </igtbl:UltraGridBand> </Bands> </igtbl:UltraWebGrid>
Hello,
It is really very hard to tell without seeing the actual grid setup and the errors you are getting. Is it possible to paste us some of the javascript errors you are getting and some of your grid definition? This will certainly provide additional clues.
As far as performance goes, please check out this post for performance suggestions (and actually, the whole thread is very useful)http://forums.infragistics.com/forums/p/14306/52885.aspx#52885and finally, you can see a lot of performance related documentation topics in our online help here:http://ko.infragistics.com/support/documentation.aspx#OnlineDocumentation