Post reply

change report type insert into

  • March 22, 2005 at 12:31 am

    #113624

    I try to change the reporting type to "insert into" to add records into database. When i built the report. The error message is

    "Microosft Development Enviroment is unable to load this document:

    Deserialization failed: The element

    http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:TableCells' has incomplete content. Expected

     

  • March 25, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • July 26, 2005 at 4:25 pm

    #577334

    Well i ran into a similar problem below:

    Deserialization failed: The element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Textbox' has incomplete content. Expected 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Action http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Visibility http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:ToolTip http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Label http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:LinkToChild http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Bookmark http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:RepeatWith http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Custom http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Value http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:CanGrow http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:CanShrink http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:HideDuplicates http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:ToggleImage http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinitionataElementName http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinitionataElementOutput http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinitionataElementStyle'. An error occurred at , (3338, 13).

    The solution had to do with Nulls or empty Captions fields in the Access report being imported into Sql Reporting.

    Chances are the RDL is not dealing well with a null value for you. Good luck.

    What is a null anyway? Once you know, it still remains UNKNOWN. The extra smilies were put there by the : D replacer.


    {Francisco}

  • February 9, 2006 at 4:28 am

    #619724

    hi,

    i tried executing a code assembly to support line-cloumn chart,when it gave the following error message........

    Microosft Development Enviroment is unable to load this document:

    Deserialization failed: The report element was not found.......

    im using SQL Server 2000.

    the custom code assembly is as follows:

    <?xml version="1.0" encoding="utf-8"?>

    <Report

    xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini

    tion"

    xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

    <RightMargin>1in</RightMargin>

    <Body>

    <ReportItems>

    <Chart Name="newChart1">

    <ThreeDProperties>

    <Rotation>30</Rotation>

    <Inclination>20</Inclination>

    <Shading>Real</Shading>

    <WallThickness>25</WallThickness>

    <DrawingStyle>Cylinder</DrawingStyle>

    <Clustered>true</Clustered>

    </ThreeDProperties>

    <Style>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    <Color>Firebrick</Color>

    </Style>

    <Legend>

    <Visible>true</Visible>

    <Style>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    </Style>

    <Position>RightCenter</Position>

    </Legend>

    <Palette>Excel</Palette>

    <ChartData>

    <ChartSeries>

    <DataPoints>

    <DataPoint>

    <DataValues>

    <DataValue>

    Value>=Fields!UnitsInStock.Value</Value>

    </DataValue>

    </DataValues>

    <DataLabel>

    <Style />

    </DataLabel>

    <Marker>

    <Size>6pt</Size>

    </Marker>

    </DataPoint>

    </DataPoints>

    </ChartSeries>

    <ChartSeries>

    <DataPoints>

    <DataPoint>

    <DataValues>

    <DataValue>

    Value>=Fields!UnitsOnOrder.Value</Value>

    </DataValue>

    </DataValues>

    <DataLabel>

    <Style />

    </DataLabel>

    <Marker>

    <Type>Square</Type>

    <Size>6pt</Size>

    </Marker>

    </DataPoint>

    </DataPoints>

    <PlotType>Line</PlotType>

    </ChartSeries>

    </ChartData>

    <CategoryAxis>

    <Axis>

    <Title>

    <Caption>Products</Caption>

    <Style />

    </Title>

    <Style>

    <FontSize>8pt</FontSize>

    </Style>

    <MajorGridLines>

    <Style>

    <BorderWidth>

    <Default>1.5pt</Default>

    </BorderWidth>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    </Style>

    </MajorGridLines>

    <MinorGridLines>

    <ShowGridLines>true</ShowGridLines>

    <Style>

    <BorderStyle>

    <Default>Dotted</Default>

    </BorderStyle>

    </Style>

    </MinorGridLines>

    <MajorTickMarks>Outside</MajorTickMarks>

    <MinorTickMarks>Outside</MinorTickMarks>

    <MajorInterval>5</MajorInterval>

    <MinorInterval>1</MinorInterval>

    <CrossAt>0</CrossAt>

    <Margin>true</Margin>

    <Visible>true</Visible>

    </Axis>

    </CategoryAxis>

    <DataSetName>Northwind</DataSetName>

    <Type>Column/Type>

    <Top>0.25in</Top>

    <Title>

    <Style>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    </Style>

    </Title>

    <Width>5.625in</Width>

    <CategoryGroupings>

    <CategoryGrouping>

    <DynamicCategories>

    <Grouping Name="newChart1_CategoryGroup2">

    <GroupExpressions>

     

    <GroupExpression>=Fields!CategoryID.Value</GroupExpression>

    </GroupExpressions>

    </Grouping>

    <Label>=Fields!CategoryName.Value</Label>

    </DynamicCategories>

    </CategoryGrouping>

    <CategoryGrouping>

    <DynamicCategories>

    <Grouping Name="newChart1_CategoryGroup1">

    <GroupExpressions>

     

    <GroupExpression>=Fields!ProductName.Value</GroupExpression>

    </GroupExpressions>

    </Grouping>

    <Label>=Fields!ProductName.Value</Label>

    </DynamicCategories>

    </CategoryGrouping>

    </CategoryGroupings>

    <Height>5.25in</Height>

    <SeriesGroupings>

    <SeriesGrouping>

    <StaticSeries>

    <StaticMember>

    <Label>Stock</Label>

    </StaticMember>

    <StaticMember>

    <Label>Order</Label>

    </StaticMember>

    </StaticSeries>

    </SeriesGrouping>

    </SeriesGroupings>

    <Subtype>Plain</Subtype>

    <PlotArea>

    <Style>

    <BackgroundColor>OldLace</BackgroundColor>

    </Style>

    </PlotArea>

    <Left>0.25in</Left>

    <ValueAxis>

    <Axis>

    <Title>

    <Caption>Amount</Caption>

    <Style />

    </Title>

    <Style>

    <BorderColor>

    <Default>IndianRed</Default>

    </BorderColor>

    <FontSize>8pt</FontSize>

    </Style>

    <MajorGridLines>

    <ShowGridLines>true</ShowGridLines>

    <Style>

    <BorderColor>

    <Default>Blue</Default>

    </BorderColor>

    <BorderStyle>

    <Default>Dashed</Default>

    </BorderStyle>

    </Style>

    </MajorGridLines>

    <MinorGridLines>

    <ShowGridLines>true</ShowGridLines>

    <Style>

    <BorderColor>

    <Default>CornflowerBlue</Default>

    </BorderColor>

    <BorderStyle>

    <Default>Dotted</Default>

    </BorderStyle>

    </Style>

    </MinorGridLines>

    <MinorTickMarks>Cross</MinorTickMarks>

    <Min>0</Min>

    <MajorInterval>20</MajorInterval>

    <MinorInterval>5</MinorInterval>

    <Interlaced>true</Interlaced>

    <Margin>true</Margin>

    <Visible>true</Visible>

    <Scalar>true</Scalar>

    </Axis>

    </ValueAxis>

    </Chart>

    </ReportItems>

    <Style />

    <Height>6.5in</Height>

    </Body>

    <TopMargin>1in</TopMargin>

    <DataSources>

    <DataSource Name="Northwind">

     

    <rdataSourceID>32d95cbf-5e5b-4fb3-a37a-39b9506b8c80</rdataSourceID>

    <ConnectionProperties>

    <DataProvider>SQL</DataProvider>

    <ConnectString>data source=(local);initial

    catalog=Northwind</ConnectString>

    <IntegratedSecurity>true</IntegratedSecurity>

    </ConnectionProperties>

    </DataSource>

    </DataSources>

    <Width>8.75in</Width>

    <DataSets>

    <DataSet Name="Northwind">

    <Fields>

    <Field Name="ProductID">

    <DataField>ProductID</DataField>

    <rd:TypeName>System.Int32</rd:TypeName>

    </Field>

    <Field Name="ProductName">

    <DataField>ProductName</DataField>

    <rd:TypeName>System.String</rd:TypeName>

    </Field>

    <Field Name="SupplierID">

    <DataField>SupplierID</DataField>

    <rd:TypeName>System.Int32</rd:TypeName>

    </Field>

    <Field Name="CategoryID">

    <DataField>CategoryID</DataField>

    <rd:TypeName>System.Int32</rd:TypeName>

    </Field>

    <Field Name="QuantityPerUnit">

    <DataField>QuantityPerUnit</DataField>

    <rd:TypeName>System.String</rd:TypeName>

    </Field>

    <Field Name="UnitPrice">

    <DataField>UnitPrice</DataField>

    <rd:TypeName>System.Decimal</rd:TypeName>

    </Field>

    <Field Name="UnitsInStock">

    <DataField>UnitsInStock</DataField>

    <rd:TypeName>System.Int16</rd:TypeName>

    </Field>

    <Field Name="UnitsOnOrder">

    <DataField>UnitsOnOrder</DataField>

    <rd:TypeName>System.Int16</rd:TypeName>

    </Field>

    <Field Name="ReorderLevel">

    <DataField>ReorderLevel</DataField>

    <rd:TypeName>System.Int16</rd:TypeName>

    </Field>

    <Field Name="Discontinued">

    <DataField>Discontinued</DataField>

    <rd:TypeName>System.Boolean</rd:TypeName>

    </Field>

    <Field Name="CategoryName">

    <DataField>CategoryName</DataField>

    <rd:TypeName>System.String</rd:TypeName>

    </Field>

    <Field Name="NullUnits">

    <DataField>NullUnits</DataField>

    <rd:TypeName>System.Int32</rd:TypeName>

    </Field>

    </Fields>

    <Query>

    <DataSourceName>Northwind</DataSourceName>

    <CommandText>SELECT TOP 10 *, NULL AS NullUnits

    FROM [Alphabetical list of products]

    WHERE (UnitsOnOrder &gt; 0)</CommandText>

    <Timeout>30</Timeout>

    </Query>

    </DataSet>

    </DataSets>

    <LeftMargin>1in</LeftMargin>

    <rd:SnapToGrid>true</rd:SnapToGrid>

    <rdrawGrid>true</rdrawGrid>

    <rd:ReportID>4792d607-5639-4c89-ac36-2794e9e78a74</rd:ReportID>

    <BottomMargin>1in</BottomMargin>

    </Report>

     

     

    Any help will be appreciated.

    thanks in advance!!!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply