Member 13341316 Ответов: 1

Ошибка 7 поле в наборе данных "dataset1" имеет имя "условие при разряде". Имена полей должны быть CLS-совместимыми идентификаторами.


пожалуйста, любезно помогите мне с этой проблемой, спасибо

Что я уже пробовал:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  
    <reportitems>
      <Textbox Name="Textbox21">
        <cangrow>true
        <keeptogether>true
        <paragraphs>
          <paragraph>
            <textruns>
              <textrun>
                <value>ADMISSION REPORT
                
                  <FontSize>16pt</fontsize>
                  <FontWeight>Bold</fontweight>
                  <Color>Blue</color>
          </paragraph>
        </paragraphs>
        <rd:DefaultName>Textbox21</rd:DefaultName>
        <Top>0.22792in</top>
        <Left>0.20833in</left>
        <Height>0.25in</height>
        <Width>2.28125in</width>
        <Style>
          <Border>
            <Style>None
          <paddingleft>2pt
          <paddingright>2pt
          <paddingtop>2pt
          <paddingbottom>2pt
      <Tablix Name="Tablix1">
        <tablixbody>
          <tablixcolumns>
            <tablixcolumn>
              <width>1.24306in
            
            <tablixcolumn>
              <width>1.24306in
            
            <tablixcolumn>
              <width>1.24306in
            
            <tablixcolumn>
              <width>1in
            
            <tablixcolumn>
              <width>1in
            
            <tablixcolumn>
              <width>1in
            
            <tablixcolumn>
              <width>1in
            
            <tablixcolumn>
              <width>1in
            
            <tablixcolumn>
              <width>1in
            
            <tablixcolumn>
              <width>1in
            
          
          <tablixrows>
            <tablixrow>
              <height>0.25in
              <tablixcells>
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox1">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>HospitalNo
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox3">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>Patient'sName
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox3</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox5">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>DateAttended
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox5</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox7">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>RefferedBy
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox7</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox9">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>Consultant
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox9</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox11">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>Ward
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox11</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox13">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>Date Discharged
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox13</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox15">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>DischargedTo
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox15</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox17">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>ConditionOnDischarge
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox17</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Textbox19">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>DischargeSummary
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Textbox19</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
              
            
            <tablixrow>
              <height>0.25in
              <tablixcells>
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="HospitalNo">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Hospital No.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>HospitalNo</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="PatientsName">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Patient's Name.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>PatientsName</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="DateAttended">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Date Attended.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>DateAttended</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="RefferedBy">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Reffered By.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>RefferedBy</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Consultant">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Consultant.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Consultant</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="Ward">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Ward.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>Ward</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="DateDischarged">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Date Discharged.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>DateDischarged</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="DischargedTo">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Discharged To.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>DischargedTo</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="ConditionOnDischarge">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Condition On Discharge.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>ConditionOnDischarge</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
                <tablixcell>
                  <cellcontents>
                    <Textbox Name="DischargeSummary">
                      <cangrow>true
                      <keeptogether>true
                      <paragraphs>
                        <paragraph>
                          <textruns>
                            <textrun>
                              <value>=Fields!Discharge Summary.Value
                              
                            </textrun>
                          </textruns>
                          <Style />
                        </paragraph>
                      </paragraphs>
                      <rd:DefaultName>DischargeSummary</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</color>
                          <Style>Solid
                        
                        <paddingleft>2pt
                        <paddingright>2pt
                        <paddingtop>2pt
                        <paddingbottom>2pt
                      
                    
                  
                
              
            
          
        
        <tablixcolumnhierarchy>
          <tablixmembers>
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
          
        
        <tablixrowhierarchy>
          <tablixmembers>
            <tablixmember>
              <keepwithgroup>After
            
            <tablixmember>
              <Group Name="Details" />
            
          
        
        <datasetname>DataSet1
        <top>0.67583in
        <left>0.20833in
        <height>0.5in
        <width>10.72917in
        <zindex>1
        
          <Border>
            <Style>None
          
        
      
    
    <height>2.54042in
    
  </body>
  <Width>11.67708in</width>
  <Page>
    <LeftMargin>1in</leftmargin>
    <RightMargin>1in</rightmargin>
    <TopMargin>1in</topmargin>
    <BottomMargin>1in</bottommargin>
    <Style />
  </page>
  <AutoRefresh>0</autorefresh>
  <DataSources>
    &lt;DataSource Name="ButhdatabaseDataSet">
      <ConnectionProperties>
        <DataProvider>System.Data.DataSet</dataprovider>
        <ConnectString>/* Local Connection */</connectstring>
      </connectionproperties>
      <rd:DataSourceID>2933db07-c59f-478b-bc31-5a1662be9927</rd:DataSourceID>
    </datasource>
  </datasources>
  <DataSets>
    &lt;DataSet Name="DataSet1">
      <Query>
        <DataSourceName>ButhdatabaseDataSet</datasourcename>
        <CommandText>/* Local Query */</commandtext>
      </query>
      <Fields>
        &lt;Field Name="Hospital No">
          <DataField>Hospital No</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Patient's Name">
          <DataField>Patient's Name</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Date Attended">
          <DataField>Date Attended</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Reffered By">
          <DataField>Reffered By</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Consultant">
          <DataField>Consultant</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Ward">
          <DataField>Ward</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Date Discharged">
          <DataField>Date Discharged</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Discharged To">
          <DataField>Discharged To</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Condition On Discharge">
          <DataField>Condition On Discharge</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
        &lt;Field Name="Discharge Summary">
          <DataField>Discharge Summary</datafield>
          <rd:TypeName>System.String</rd:TypeName>
        </field>
      </fields>
      <rd:DataSetInfo>
        <rd:DataSetName>ButhdatabaseDataSet</rd:DataSetName>
        <rd:SchemaPath>C:\Users\teejayfpi\Desktop\Dr ajii\WindowsApplication2\ButhdatabaseDataSet.xsd</rd:SchemaPath>
        <rd:TableName>Admission</rd:TableName>
        <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
        <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
        <rd:TableAdapterName>AdmissionTableAdapter</rd:TableAdapterName>
      </rd:DataSetInfo>
    </dataset>
  </datasets>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>748e276b-e43e-49ee-a01d-55e3fc31583e</rd:ReportID>
</report>

Что я уже пробовал:

Graeme_Grant

Это похоже на дамп кода xml-файла для конструктора отчетов. Это верно?

Ввод XML-кода через Инструмент онлайн-валидатора XML[^] показывает, что XML имеет много ошибок. Вы должны решить эту проблему.

1 Ответов

Рейтинг:
0

Dave Kreskowiak

Не используйте пробелы, табуляции и специальные символы в именах таблиц и столбцов в базе данных.