Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
85
Viewing different columns in same Band
posted

Hi! I have this scheme of Data on my Ultrawebgrid. By default all columns that have information are visible, now, I need to hide some columns depending of the value at TasCodigo in the 2nd Band. For example, if the value is "1" I need to hide since "AfoCodigo" column until "AfoIncorporationDate", and if the value is "2" I need to hide since "AcoCodigo" until "AcoStatus". Is it this posible ?

<Bands>
                        <igtbl:UltraGridBand>
                            <AddNewRow View="NotSet" Visible="NotSet">
                            </AddNewRow>
                            <Columns>
                                <igtbl:UltraGridColumn BaseColumnName="TasCodigo" Key="TasCodigo">
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="TasDescripcion" Key="TasDescripcion">
                                    <Header Caption="TXT_DESCRIPCION">
                                        <RowLayoutColumnInfo OriginX="1" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="1" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                            </Columns>
                        </igtbl:UltraGridBand>
                        <igtbl:UltraGridBand>
                            <AddNewRow View="NotSet" Visible="NotSet">
                            </AddNewRow>
                            <Columns>
                                <igtbl:UltraGridColumn BaseColumnName="AssCodigo" DataType="System.Int32" Hidden="True"
                                    Key="AssCodigo">
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="TasCodigo" DataType="System.Int32" Hidden="True"
                                    Key="TasCodigo">
                                    <Header>
                                        <RowLayoutColumnInfo OriginX="1" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="1" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AcoCodigo" DataType="System.Int32" Hidden="True"
                                    Key="AcoCodigo">
                                    <Header>
                                        <RowLayoutColumnInfo OriginX="2" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="2" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AcoCompanyName" Key="AcoCompanyName">
                                    <Header Caption="DP_COMPANYNAME">
                                        <RowLayoutColumnInfo OriginX="3" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="3" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AcoJurisdition" Key="AcoJurisdition">
                                    <Header Caption="DP_JURISDICTION">
                                        <RowLayoutColumnInfo OriginX="4" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="4" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AcoId" Key="AcoId">
                                    <Header Caption="DP_ID">
                                        <RowLayoutColumnInfo OriginX="5" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="5" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AcoDateIncorporation" DataType="System.DateTime"
                                    Format="MM/dd/yyyy" Key="AcoDateIncorporation">
                                    <Header Caption="DP_DATEINCORPORATION">
                                        <RowLayoutColumnInfo OriginX="6" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="6" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AcoStatus" Key="AcoStatus">
                                    <Header Caption="DP_STATUS">
                                        <RowLayoutColumnInfo OriginX="7" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="7" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AfoCodigo" DataType="System.Int32" Hidden="True"
                                    Key="AfoCodigo">
                                    <Header>
                                        <RowLayoutColumnInfo OriginX="8" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="8" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AfoFoundationName" Key="AfoFoundationName">
                                    <Header Caption="DP_FOUNDATIONNAME">
                                        <RowLayoutColumnInfo OriginX="9" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="9" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AfoJurisdition" Key="AfoJurisdition">
                                    <Header Caption="DP_JURISDICTION">
                                        <RowLayoutColumnInfo OriginX="10" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="10" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AfoIdNumber" Key="AfoIdNumber">
                                    <Header Caption="DP_IDNUMBER">
                                        <RowLayoutColumnInfo OriginX="11" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="11" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AfoStatus" Key="AfoStatus">
                                    <Header Caption="DP_STATUS">
                                        <RowLayoutColumnInfo OriginX="12" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="12" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                                <igtbl:UltraGridColumn BaseColumnName="AfoIncorporationDate" DataType="System.DateTime"
                                    Format="MM/dd/yyyy" Key="AfoIncorporationDate">
                                    <Header Caption="DP_DATEINCORPORATION">
                                        <RowLayoutColumnInfo OriginX="13" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="13" />
                                    </Footer>
                                </igtbl:UltraGridColumn>
                            </Columns>
                        </igtbl:UltraGridBand>
                    </Bands>

</Code> 

Parents
No Data
Reply
  • 1332
    posted

    Hello,

    You are trying to hide a column based on the value of a child row, is that correct? If so, handle the InitializeRow event of WebGrid and check the child rows for that particular value. Hide the column if it mathces a criteria.

Children