Run Report Error!

GRUBBYFANS
GRUBBYFANS Member Posts: 154
edited 2009-09-08 in NAV Three Tier
I have design a Customer Report in Nav2009 sp1,but when I run it,The Error is :the metadata of 50001 is invalid,See Event View! Then I have seen the Event View Error:Service: MicrosoftDynamicsNavServer
User: 65D667C8937D4F0\Administrator
Type: System.Xml.XmlException
LineNumber: 391
LinePosition: 10
Message: '.', hexadecimal value 0x00, is an invalid character. Line 391, position 10.
StackTrace:
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String[] args)
at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar)
at System.Xml.XmlTextReaderImpl.ParseCDataOrComment(XmlNodeType type, Int32& outStartPos, Int32& outEndPos)
at System.Xml.XmlTextReaderImpl.ParseCDataOrComment(XmlNodeType type)
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at Microsoft.Dynamics.Nav.Service.Metadata.MetadataProvider.GetNavObjectAsXMLDocument(Int32 id, ObjectType navObjectType)
at Microsoft.Dynamics.Nav.Service.Metadata.MetadataProvider.<>c__DisplayClass7.<GetNavObjectAsXMLDocumentUsingCache>b__6()
at Microsoft.Dynamics.Nav.Types.Cache.GlobalVersionCache`2.GetItem[TItem](TKey key, ObtainItem`1 obtainItem)
at Microsoft.Dynamics.Nav.Service.Metadata.MetadataProvider.GetNavObjectAsXMLDocumentUsingCache(Int32 id, ObjectType navObjectType)
at Microsoft.Dynamics.Nav.Service.Metadata.MetadataProvider.GetReportMetadata(Int32 id)
Source: System.Xml


Please help me friends!

Answers

  • kine
    kine Member Posts: 12,562
    Try to recompile the objects...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • GRUBBYFANS
    GRUBBYFANS Member Posts: 154
    kine wrote:
    Try to recompile the objects...
    I have compiled this Report,but also It have this error,why?
  • kine
    kine Member Posts: 12,562
    Open the report Layout in the Visual Studio and try to save it, may be there was some change in the design of native report which was not mirrored in the layout for NAV 2009. E.g. when you remove some control from native report, you need to remove the same field from RTC layout.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • GRUBBYFANS
    GRUBBYFANS Member Posts: 154
    kine wrote:
    Open the report Layout in the Visual Studio and try to save it, may be there was some change in the design of native report which was not mirrored in the layout for NAV 2009. E.g. when you remove some control from native report, you need to remove the same field from RTC layout.
    Everytime I quit VS2005,I have save the Report,but the Error remain,this question make me crazy all day,
  • GRUBBYFANS
    GRUBBYFANS Member Posts: 154
    kine wrote:
    Open the report Layout in the Visual Studio and try to save it, may be there was some change in the design of native report which was not mirrored in the layout for NAV 2009. E.g. when you remove some control from native report, you need to remove the same field from RTC layout.
    this is my code
    OBJECT Report 50001 CustBalance
    {
    OBJECT-PROPERTIES
    {
    Date=09-09-08;
    Time=12:44:14 上午;
    Modified=Yes;
    Version List=GRUBBY;
    }
    PROPERTIES
    {
    }
    DATAITEMS
    {
    { PROPERTIES
    {
    DataItemTable=Table18;
    ReqFilterFields=No.;
    }
    SECTIONS
    {
    { PROPERTIES
    {
    SectionType=Body;
    SectionWidth=12000;
    SectionHeight=1692;
    }
    CONTROLS
    {
    { 1000000000;TextBox;450 ;0 ;1500 ;423 ;SourceExpr="No.";
    DataSetFieldName=Customer__No__ }
    { 1000000001;Label ;450 ;0 ;1500 ;846 ;ParentControl=1000000000;
    VertAlign=Bottom;
    FontBold=Yes;
    MultiLine=Yes;
    DataSetFieldName=Customer__No__Caption }
    { 1000000002;TextBox;2100 ;0 ;4500 ;423 ;SourceExpr=Name;
    DataSetFieldName=Customer_Name }
    { 1000000003;Label ;2100 ;0 ;4500 ;846 ;ParentControl=1000000002;
    VertAlign=Bottom;
    FontBold=Yes;
    MultiLine=Yes;
    DataSetFieldName=Customer_NameCaption }
    { 1000000004;TextBox;7800 ;0 ;1800 ;423 ;SourceExpr="Balance (LCY)";
    DataSetFieldName=Customer__Balance__LCY__ }
    { 1000000005;Label ;7800 ;0 ;1800 ;846 ;ParentControl=1000000004;
    HorzAlign=Right;
    VertAlign=Bottom;
    FontBold=Yes;
    MultiLine=Yes;
    DataSetFieldName=Customer__Balance__LCY__Caption }
    }
    }
    }
    }
    }
    REQUESTFORM
    {
    PROPERTIES
    {
    Width=9020;
    Height=3410;
    }
    CONTROLS
    {
    }
    }
    REQUESTPAGE
    {
    PROPERTIES
    {
    }
    CONTROLS
    {
    }
    }
    CODE
    {

    BEGIN
    END.
    }
    RDLDATA
    {
    <?xml version="1.0" encoding="utf-8"?>
    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition&quot; xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"&gt;
    <Body>
    <ColumnSpacing>1cm</ColumnSpacing>
    <Height>2.5cm</Height>
    <ReportItems>
    <Table Name="table1">
    <DataSetName>DataSet_Result</DataSetName>
    <Details>
    <TableRows>
    <TableRow>
    <Height>0.63492cm</Height>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="Customer__No__">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <Value>=First(Fields!Customer__No__.Value)</Value>
    <ZIndex>2</ZIndex>
    <rd:DefaultName>Customer__No__</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox1">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <Value />
    <ZIndex>1</ZIndex>
    <rd:DefaultName>textbox1</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox3">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <Value />
    <rd:DefaultName>textbox3</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    </TableRow>
    </TableRows>
    </Details>
    <Footer>
    <TableRows>
    <TableRow>
    <Height>0.63492cm</Height>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox7">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <Value />
    <ZIndex>5</ZIndex>
    <rd:DefaultName>textbox7</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox2">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <Value />
    <ZIndex>4</ZIndex>
    <rd:DefaultName>textbox2</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="Customer__Balance__LCY__">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    <TextAlign>Right</TextAlign>
    </Style>
    <Value />
    <ZIndex>3</ZIndex>
    <rd:DefaultName>Customer__Balance__LCY__</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    </TableRow>
    </TableRows>
    </Footer>
    <Header>
    <TableRows>
    <TableRow>
    <Height>0.63492cm</Height>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="Customer__No__Caption">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <Value>=First(Fields!Customer__No__Caption.Value)</Value>
    <ZIndex>8</ZIndex>
    <rd:DefaultName>Customer__No__Caption</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox5">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <Value />
    <ZIndex>7</ZIndex>
    <rd:DefaultName>textbox5</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox4">
    <CanGrow>true</CanGrow>
    <Style>
    <FontFamily>宋体</FontFamily>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <Value />
    <ZIndex>6</ZIndex>
    <rd:DefaultName>textbox4</rd:DefaultName>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    </TableRow>
    </TableRows>
    </Header>
    <Height>1.90476cm</Height>
    <Style>
    <FontFamily>宋体</FontFamily>
    </Style>
    <TableColumns>
    <TableColumn>
    <Width>10cm</Width>
    </TableColumn>
    <TableColumn>
    <Width>10cm</Width>
    </TableColumn>
    <TableColumn>
    <Width>10cm</Width>
    </TableColumn>
    </TableColumns>
    </Table>
    </ReportItems>
    </Body>
    <BottomMargin>2.5cm</BottomMargin>
    <Code>Public Function BlankZero(ByVal Value As Decimal)
    if Value = 0 then
    Return ""
    end if
    Return Value
    End Function

    Public Function BlankPos(ByVal Value As Decimal)
    if Value > 0 then
    Return ""
    end if
    Return Value
    End Function

    Public Function BlankZeroAndPos(ByVal Value As Decimal)
    if Value >= 0 then
    Return ""
    end if
    Return Value
    End Function

    Public Function BlankNeg(ByVal Value As Decimal)
    if Value < 0 then
    Return ""
    end if
    Return Value
    End Function

    Public Function BlankNegAndZero(ByVal Value As Decimal)
    if Value <= 0 then
    Return ""
    end if
    Return Value
    End Function
    </Code>
    <DataSets>
    <DataSet Name="DataSet_Result">
    <Fields>
    <Field Name="Customer__No__">
    <DataField>Customer__No__</DataField>
    </Field>
    <Field Name="Customer__No__Caption">
    <DataField>Customer__No__Caption</DataField>
    </Field>
    <Field Name="Customer_Name">
    <DataField>Customer_Name</DataField>
    </Field>
    <Field Name="Customer_NameCaption">
    <DataField>Customer_NameCaption</DataField>
    </Field>
    <Field Name="Customer__Balance__LCY__">
    <DataField>Customer__Balance__LCY__</DataField>
    </Field>
    <Field Name="Customer__Balance__LCY__Format">
    <DataField>Customer__Balance__LCY__Format</DataField>
    </Field>
    <Field Name="Customer__Balance__LCY__Caption">
    <DataField>Customer__Balance__LCY__Caption</DataField>
    </Field>
    </Fields>
    <Query>
    <CommandText />
    <DataSourceName>DummyDataSource</DataSourceName>
    </Query>
    <rd:DataSetInfo>
    <rd:DataSetName>DataSet</rd:DataSetName>
    <rd:TableName>Result</rd:TableName>
    </rd:DataSetInfo>
    </DataSet>
    </DataSets>
    <DataSources>
    <DataSource Name="DummyDataSource">
    <ConnectionProperties>
    <ConnectString />
    <DataProvider>SQL</DataProvider>
    </ConnectionProperties>
    <rd:DataSourceID>35f0fe1e-12fa-4983-8052-593d59e3e571</rd:DataSourceID>
    </DataSource>
    </DataSources>
    <InteractiveHeight>29.7cm</InteractiveHeight>
    <InteractiveWidth>21cm</InteractiveWidth>
    <Language>zh-CN</Language>
    <LeftMargin>2.5cm</LeftMargin>
    <PageFooter>
    <Height>0.75cm</Height>
    <PrintOnFirstPage>true</PrintOnFirstPage>
    <PrintOnLastPage>true</PrintOnLastPage>
    </PageFooter>
    <PageHeader>
    <Height>0.75cm</Height>
    <PrintOnFirstPage>true</PrintOnFirstPage>
    <PrintOnLastPage>true</PrintOnLastPage>
    </PageHeader>
    <PageHeight>29.7cm</PageHeight>
    <PageWidth>21cm</PageWidth>
    <RightMargin>2.5cm</RightMargin>
    <TopMargin>2.5cm</TopMargin>
    <Width>30cm</Width>
    <rd:DrawGrid>true</rd:DrawGrid>
    <rd:GridSpacing>0.25cm</rd:GridSpacing>
    <rd:ReportID>60d50698-e977-461b-912e-d7159439947a</rd:ReportID>
    <rd:SnapToGrid>true</rd:SnapToGrid>
    </Report>
    END_OF_RDLDatA
    }
    }
  • GRUBBYFANS
    GRUBBYFANS Member Posts: 154
    kine wrote:
    Open the report Layout in the Visual Studio and try to save it, may be there was some change in the design of native report which was not mirrored in the layout for NAV 2009. E.g. when you remove some control from native report, you need to remove the same field from RTC layout.
    now I have know the reason,because this is chinese font,replace all font to Arial.you can solved this question! :D:D:D ,and however thank you Kine
  • kine
    kine Member Posts: 12,562
    You are welcome... :-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories