Replies
good morning, happens to me the same thing but this works for me perfectly on the development team, the problem appears when'll post on my web server, if you know of any solution would be good that compartieras in the company where I work bought package a week ago and the first project that is being done got this error, I hope that the support staff can help me quickly, I send part of the program code
<Div style = "margin-top: 30px; font-size: 1px;">
<Ig: WebHierarchicalDataGrid ID = "WebHierarchicalDataGrid1" runat = "server" DataSourceID = "DatoEnCascada1" Height = "500px" width = "98%" AutoGenerateBands = "False" AutoGenerateColumns = "False" DataKeyFields = "REGIONAL" DataMember = "Cadena1_DefaultView" key = "Cadena1_DefaultView">
<Bands>
<Ig: Band AutoGenerateColumns = "False" DataKeyFields = "REGIONAL CODE" DataMember = "Cadena2_DefaultView" Key = "Cadena2_DefaultView">
<Bands>
<Ig: Band AutoGenerateColumns = "False" DataMember = "Cadena3_DefaultView" Key = "Cadena3_DefaultView">
<Columns>
<Ig: BoundDataField DataFieldName = "NIT" Key = "NIT" Width = "10%">
<Header Text = "Nit" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "CUSTOMER" Key = "CUSTOMER" Width = "25%">
<Header Text = "Customer Name" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_HOY" Key = "VTA_HOY" Width = "10%" DataFormatString = "{0: C2}">
<Header Text = "Sale Today" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_AYER" Key = "VTA_AYER" Width = "10%" DataFormatString = "{0: C2}">
<Header Text = "Sale Yesterday" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_ACUM" Key = "VTA_ACUM" Width = "10%" DataFormatString = "{0: C2}">
<Header Text = "Accrued Sale" />
</ Ig: BoundDataField>
</ Columns>
</ Ig: Band>
</ Bands>
<Columns>
<Ig: BoundDataField DataFieldName = "ZONE" Key = "ZONE" Width = "8%">
<Header Text = "Zone" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "Code" Key = "Code" Width = "4%">
<Header Text = "Code" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "NOMBRE_ASESOR" Key = "NOMBRE_ASESOR" Width = "17%">
<Header Text = "Name Advisor" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "BUDGET" Key = "BUDGET" Width = "9%" DataFormatString = "{0: C2}">
<Header Text = "Budget" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "PP_DIARIO" Key = "PP_DIARIO" Width = "7%" DataFormatString = "{0: C2}">
<Header Text = "Daily Budget" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_HOY" Key = "VTA_HOY" Width = "7%" DataFormatString = "{0: C2}">
<Header Text = "Sale Today" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_AYER" Key = "VTA_AYER" Width = "7%" DataFormatString = "{0: C2}">
<Header Text = "Sale Yesterday" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_ACUM" Key = "VTA_ACUM" Width = "7%" DataFormatString = "{0: C2}">
<Header Text = "Accrued Sale" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "% CUMP" Key = "% CUMP" Width = "4%" DataFormatString = "{0: # ##%.}">
<Header Text = "% Compliance" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_PRESUSP" Key = "VTA_PRESUSP" Width = "9%" DataFormatString = "{0: C2}">
<Header Text = "Sale Budgeted" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "% PRESUSP" Key = "% PRESUSP" Width = "4%" DataFormatString = "{0: # ##%.}">
<Header Text = "% Budget" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "PROY_MES" Key = "PROY_MES" Width = "9%" DataFormatString = "{0: C2}">
<Header Text = "Designing Month" />
</ Ig: BoundDataField>
</ Columns>
</ Ig: Band>
</ Bands>
<GroupingSettings EnableColumnGrouping = "True">
</ GroupingSettings>
<Columns>
<Ig: BoundDataField DataFieldName = "REGIONAL" Key = "REGIONAL" Width = "10%">
<Header Text = "Regional" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "BUDGET" Key = "BUDGET" Width = "9%" DataFormatString = "{0: C2}">
<Header Text = "Budget" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "PP_DIARIO" Key = "PP_DIARIO" Width = "8%" DataFormatString = "{0: C2}">
<Header Text = "Daily Budget" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_HOY" Key = "VTA_HOY" Width = "8%" DataFormatString = "{0: C2}">
<Header Text = "Sale Today" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_AYER" Key = "VTA_AYER" Width = "8%" DataFormatString = "{0: C2}">
<Header Text = "Sale Yesterday" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_ACUM" Key = "VTA_ACUM" Width = "9%" DataFormatString = "{0: C2}">
<Header Text = "Accrued Sale" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "% CUMP" Key = "% CUMP" Width = "8%" DataFormatString = "{0: # ##%.}">
<Header Text = "% Compliance" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "VTA_PRESUSP" Key = "VTA_PRESUSP" Width = "9%" DataFormatString = "{0: C2}">
<Header Text = "Sale Budgeted" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "% PRESUSP" Key = "% PRESUSP" Width = "6%" DataFormatString = "{0: # ##%.}">
<Header Text = "% Budget" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "PROY_MES" Key = "PROY_MES" Width = "9%" DataFormatString = "{0: C2}">
<Header Text = "Designing Month" />
</ Ig: BoundDataField>
<Ig: BoundDataField DataFieldName = "EFFECTIVENESS" Key = "EFFECTIVENESS" Width = "6%" DataFormatString = "{0:. # ##%}">
<Header Text = "% Effectiveness" />
</ Ig: BoundDataField>
</ Columns>
</ Ig: WebHierarchicalDataGrid>
<Ig: WebHierarchicalDataSource ID = "DatoEnCascada1" runat = "server">
<DataViews>
<Ig: DataView ID = "Cadena1_DefaultView" DataMember = "DefaultView" DataSourceID = "String1" />
<Ig: DataView ID = "Cadena2_DefaultView" DataMember = "DefaultView" DataSourceID = "String2" />
<Ig: DataView ID = "Cadena3_DefaultView" DataMember = "DefaultView" DataSourceID = "string3" />
</ DataViews>
<DataRelations>
<Ig: DataRelation ChildColumns = "REGIONAL" ChildDataViewID = "Cadena2_DefaultView" ParentColumns = "REGIONAL" ParentDataViewID = "Cadena1_DefaultView" />
<Ig: DataRelation ChildColumns = "REGIONAL CODE" ChildDataViewID = "Cadena3_DefaultView" ParentColumns = "REGIONAL CODE" ParentDataViewID = "Cadena2_DefaultView" />
</ DataRelations>
</ Ig: WebHierarchicalDataSource>
<Asp: SqlDataSource ID = "string3" runat = "server" ConnectionString = "<% $ ConnectionStrings: CENTRAL%>" SelectCommand = "REGIONAL select, CODE, f.NIT, RTRIM (pc.nombre) CLIENT, isnull (VTA_HOY, 0) VTA_HOY, isnull (VTA_AYER, 0) VTA_AYER, isnull (VTA_ACUM, 0) VTA_ACUM from esp_ventas_regional_vendedor_cli f, mtprocli pc with (nolock) where f.nit = pc.nit and f.usuario=@USUARIO and @ buscarCM = 'True 'and (regional code is not null or is not null) ">
<SelectParameters>
<Asp: SessionParameter Name = "USER" SessionField = "CODIGOUSUARIOS" Type = "String" />
<Asp: SessionParameter Name = "buscarCM" SessionField = "buscarCM" Type = "Boolean" />
<Asp: SessionParameter Name = "ANO" SessionField = "anoCM" Type = "String" />
<Asp: SessionParameter Name = "MES" SessionField = "mesCM" Type = "String" />
</ SelectParameters>
</ Asp: SqlDataSource>
<Asp: SqlDataSource ID = "String2" runat = "server" ConnectionString = "<% $ ConnectionStrings: CENTRAL%>" SelectCommand = "select REGIONAL,ZONA,CODIGO,NOMBRE_ASESOR,PRESUPUESTO,PP_DIARIO,VTA_HOY,VTA_AYER,VTA_ACUM,[%CUMP],VTA_PRESUSP,[%PRESUSP],PROY_MES Where esp_ventas_regional_vendedor from user = @ and @ buscarCM USER = 'True' and anus year and month = @ = @ month and VTA_ACUM + BUDGET <> 0 ">
<SelectParameters>
<Asp: SessionParameter Name = "USER" SessionField = "CODIGOUSUARIOS" Type = "String" />
<Asp: SessionParameter Name = "buscarCM" SessionField = "buscarCM" Type = "Boolean" />
<Asp: SessionParameter Name = "ANO" SessionField = "anoCM" Type = "String" />
<Asp: SessionParameter Name = "MES" SessionField = "mesCM" Type = "String" />
</ SelectParameters>
</ Asp: SqlDataSource>
<Asp: SqlDataSource ID = "String1" runat = "server" ConnectionString = "<% $ ConnectionStrings: CENTRAL%>" SelectCommand = "select REGIONAL,PRESUPUESTO,PP_DIARIO,VTA_HOY,VTA_AYER,VTA_ACUM,[%CUMP],VTA_PRESUSP,[%PRESUSP],PROY_MES,EFECTIVIDAD Where esp_ventas_regional from user = @ and @ buscarCM USER = 'True' and VTA_ACUM + BUDGET <> 0 and year = @ year and month = @ month ">
<SelectParameters>
<Asp: SessionParameter Name = "USER" SessionField = "CODIGOUSUARIOS" Type = "String" />
<Asp: SessionParameter Name = "buscarCM" SessionField = "buscarCM" Type = "Boolean" />
<Asp: SessionParameter Name = "ANO" SessionField = "anoCM" Type = "String" />
<Asp: SessionParameter Name = "MES" SessionField = "mesCM" Type = "String" />
</ SelectParameters>
</ Asp: SqlDataSource>