Telerik Forums
Reporting Forum
1 answer
195 views

Hi, I have some WPF projects in .NET Framework 4.5 with Telerik reports working fine, but I need to make a WPF Project on .NET Framework 3.5 because I need to report on BD SQL 7, and I only can use 3.5 to can connected to this

When I add the Telerik controls, and the Themes carpet, and then I compile the Project, I have some errors:

Error 102 No se admite el tipo VisualStateManager en los proyectos Windows Presentation Foundation (WPF). C:\Users\SP6688\Documents\Visual Studio 2013\Projects\Modulo Produccion\Modulo Produccion\Modulo Produccion\Temas\Telerik.Windows.Controls.Input.xaml 1 1 Modulo Producción

and the same for Telerik.Windows.Controls.Navigation.xaml and Telerik.Windows.Controls.xaml

How I can fix this?

 

Todor
Telerik team
 answered on 27 Feb 2020
1 answer
447 views

I have a report that's supposed to show a list of employees who haven't swiped in or out, and which swipe they missed. I'm having trouble getting it working the way I need it to work, so I'm hoping someone can help me out. I can't seem to attach the report file here, so I've attached some screenshots. 

The report will be organised in a group hierarchy, but the groups themselves won't be specified in the report. In the attached sample report they're grouped by Location, Building, and Department, which for this example have been specified manually in the GroupTypes and GroupHierarchy CSV sources, but different companies might have different group hierarchies. For example they might only have 'Location' and 'Department', or they could have several other groups. Essentially the report should be able to handle any group hierarchy without needing to update the report manually.  I've seen people saying they solved this by using recursive sub-reports, but so far I haven't been able to get this working. 

The user running the report also needs to be able to select how the results are grouped, so in this example the user might want to display a list of employees in each building, ignoring the department, or they might want to display the employees per location. Would this be possible using the Toggle Visibility action on the group headers? The employees would need to be ordered by name, ignoring any hidden departments. I'm not sure if this is possible with the way the report is structured at the moment.

The actual report will be getting the data using Object Data Source methods, I've created the CSV objects to represent what they look like. The GroupHierarchy and GroupType CSV objects were created for this example, so these can be changed if necessary.

Thanks to anyone who can help me out with this.

Elena
Telerik team
 answered on 27 Feb 2020
1 answer
168 views

Hi,

     I have a report file trdx which contains many sub report, which runs very slowly. I want all the sub report to run in parallel. Is that possible to do that and how to do that? The following is my trdx report file.

<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="objectDataSourceCompanyInfo" Width="6.5in" Name="Report1" xmlns="http://schemas.telerik.com/reporting/2012/3.7">
  <DataSources>
    <ObjectDataSource DataMember="GetCompanyInformation" Name="objectDataSourceCompanyInfo" ParameterValues="{&quot;companyID&quot;:&quot;1&quot;,&quot;lang&quot;:&quot;en-US&quot;}">
      <DataSource>
        <ClrType FullName="Sustainability.BusinessObject.Client.ReportManager" Assembly="Sustainability.BusinessObject.Client" />
      </DataSource>
      <Parameters>
        <ObjectDataSourceParameter Name="companyID">
          <DataType>System.Int32</DataType>
          <Value>
            <String>= Parameters.companyID.Value</String>
          </Value>
        </ObjectDataSourceParameter>
        <ObjectDataSourceParameter Name="lang">
          <DataType>System.String</DataType>
          <Value>
            <String>= Parameters.lang.Value</String>
          </Value>
        </ObjectDataSourceParameter>
      </Parameters>
    </ObjectDataSource>
  </DataSources>
  <Items>
    <DetailSection Height="17.8395868937175in" Name="detailSection1">
      <Style BackgroundColor="White" />
      <Items>
        <SubReport Width="6.49992116292318in" Height="0.399999936421717in" Left="0.00003941853841146in" Top="2.64791679382324in" KeepTogether="False" Name="subReportEnvironmentalPerformance_AirEmissions">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_AirEmissions.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.49992116292318in" Height="0.847798506418864in" Left="0.00003941853841146in" Top="0in" Name="subReportCoverPage">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Cover.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyName">
                  <Value>
                    <String>= Fields.CompanyName</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.847798526287079in" Left="0in" Top="0.847916762034098in" Name="subReportAbout">
          <ReportSource>
            <UriReportSource Uri="ESGReport_About.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyName">
                  <Value>
                    <String>= Fields.CompanyName</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <TextBox Width="6.4999213218689in" Height="0.400000005960464in" Left="0in" Top="1.69579410552979in" Value="= IIf(&#xD;&#xA;Parameters.lang.Value=&quot;zh-CN&quot;,&#xD;&#xA;&quot;环境&quot;,&#xD;&#xA;&#xD;&#xA;IIf(Parameters.lang.Value=&quot;zh-TW&quot;,&#xD;&#xA;&quot;環境&quot;,&#xD;&#xA;&#xD;&#xA;&quot;Environmental Performance&quot;&#xD;&#xA;))&#xD;&#xA;" Name="textBox1">
          <Style>
            <Font Name="Arial Unicode MS" Size="16pt" />
          </Style>
        </TextBox>
        <TextBox Width="6.49996042251587in" Height="0.39999994635582in" Left="0in" Top="2.09587287902832in" Value="= IIf(&#xD;&#xA;Parameters.lang.Value=&quot;zh-CN&quot;,&#xD;&#xA;&quot;在 &quot; + Parameters.fromYear.Value + &quot; 财政年度,我们透过以下各范畴管理我们的环保表现。&quot;,&#xD;&#xA;&#xD;&#xA;IIf(Parameters.lang.Value=&quot;zh-TW&quot;,&#xD;&#xA;&quot;在 &quot; + Parameters.fromYear.Value + &quot; 財政年度,我們透過以下各範疇管理我們的環保表現。&quot;,&#xD;&#xA;&#xD;&#xA;&quot;In FY &quot; + Parameters.fromYear.Value + &quot;, we measured and managed our environmental performance in several aspects throughout our operations.&quot;&#xD;&#xA;))&#xD;&#xA;" Name="textBox2">
          <Style TextAlign="Justify">
            <Font Name="Arial Unicode MS" Size="11pt" />
          </Style>
        </TextBox>
        <SubReport Width="6.4999213218689in" Height="0.399999976158147in" Left="0in" Top="3.04791673024495in" Name="subReportEnvironmentalPerformance_GHG">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_GHG.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyName">
                  <Value>
                    <String>= Fields.CompanyName</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399920821189885in" Left="0.00007883707682292in" Top="3.44791698455811in" Name="subReportEnvironmentalPerformance_EnergyConsumption">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_EnergyConsumption.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399999976158147in" Left="0in" Top="3.84791692097982in" Name="subReportEnvironmentalPerformance_WaterManagement">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_WaterManagement.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399999976158147in" Left="0in" Top="4.24791685740153in" Name="subReportEnvironmentalPerformance_WastewaterDischarge">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_WastewaterDischarge.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399999976158147in" Left="0in" Top="4.64791679382324in" Name="subReportEnvironmentalPerformance_WasteManagementAndReduction1">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_WasteManagementAndReduction1.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399999976158147in" Left="0in" Top="5.04791673024495in" Name="subReportEnvironmentalPerformance_WasteManagementAndReduction2">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_WasteManagementAndReduction2.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.400000294049586in" Left="0in" Top="5.44791698455811in" Name="subReportEnvironmentalPerformance_MaterialConsumption">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_MaterialConsumption.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyName">
                  <Value>
                    <String>= Fields.CompanyName</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399999658266708in" Left="0in" Top="5.84791723887126in" Name="subReportEnvironmentalPerformance_NaturalResourcesAndEnvironment">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Environmental_Performance_NaturalResourcesAndEnvironment.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <TextBox Width="6.4999213218689in" Height="0.400000005960464in" Left="0in" Top="6.24791685740153in" Value="= IIf(&#xD;&#xA;Parameters.lang.Value=&quot;zh-CN&quot;,&#xD;&#xA;&quot;社会&quot;,&#xD;&#xA;&#xD;&#xA;IIf(Parameters.lang.Value=&quot;zh-TW&quot;,&#xD;&#xA;&quot;社會&quot;,&#xD;&#xA;&#xD;&#xA;&quot;Social Performance&quot;&#xD;&#xA;))" Name="textBox3">
          <Style>
            <Font Name="Arial Unicode MS" Size="17pt" />
          </Style>
        </TextBox>
        <SubReport Width="6.4999213218689in" Height="0.374902764956161in" Left="0in" Top="6.67293516794841in" Name="subReportSocialPerformance_EmploymentAndLabourPractices">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Social_Performance_EmploymentAndLabourPractices.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyName">
                  <Value>
                    <String>= Fields.CompanyName</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399921456972758in" Left="0in" Top="7.04791673024495in" Name="subReportSocialPerformance_HealthAndSafety">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Social_Performance_HealthAndSafety.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399921427170435in" Left="0in" Top="7.44791698455811in" Name="subReportSocialPerformance_DevelopmentAndTraining">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Social_Performance_DevelopmentAndTraining.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399920791387558in" Left="0in" Top="7.84791723887126in" Name="subReportSocialPerformance_LabourStandards">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Social_Performance_LabourStandards.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyName">
                  <Value>
                    <String>= Fields.CompanyName</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399921427170435in" Left="0in" Top="8.24791685740153in" Name="subReportSocialPerformance_SupplyChainManagement">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Social_Performance_SupplyChainManagement.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399921427170435in" Left="0in" Top="8.64791711171468in" Name="subReportSocialPerformance_ProductResponsibility">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Social_Performance_ProductResponsibility.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.399920791387558in" Left="0in" Top="9.04791736602783in" Name="subReportSocialPerformance_AntiCorruption">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Social_Performance_AntiCorruption.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyName">
                  <Value>
                    <String>= Fields.CompanyName</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.400000264247258in" Left="0in" Top="9.44791698455811in" Name="subReportSocialPerformance_CommunityInvestment">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Social_Performance_CommunityInvestment.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyID">
                  <Value>
                    <String>= Parameters.companyID.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromMonth">
                  <Value>
                    <String>= Parameters.fromMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toYear">
                  <Value>
                    <String>= Parameters.toYear.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="toMonth">
                  <Value>
                    <String>= Parameters.toMonth.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="companyName">
                  <Value>
                    <String>= Fields.CompanyName</String>
                  </Value>
                </Parameter>
                <Parameter Name="locationIDs">
                  <Value>
                    <String>= Parameters.locationIDs.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
        <SubReport Width="6.4999213218689in" Height="0.400000274181366in" Left="0in" Top="9.84791723887126in" Name="subReportIndex">
          <ReportSource>
            <UriReportSource Uri="ESGReport_Index.trdx">
              <Parameters>
                <Parameter Name="lang">
                  <Value>
                    <String>= Parameters.lang.Value</String>
                  </Value>
                </Parameter>
                <Parameter Name="fromYear">
                  <Value>
                    <String>= Parameters.fromYear.Value</String>
                  </Value>
                </Parameter>
              </Parameters>
            </UriReportSource>
          </ReportSource>
        </SubReport>
      </Items>
    </DetailSection>
    <PageHeaderSection Height="0.0520832935969036in" Name="pageHeaderSection1">
      <Style BackgroundColor="White" />
    </PageHeaderSection>
    <PageFooterSection Height="0.564666152000427in" Name="pageFooterSection1">
      <Style BackgroundColor="White" />
      <Items>
        <TextBox Width="4cm" Height="1cm" Left="2.40000025431315in" Top="0.108331044514974in" Value="{PageNumber}" Name="ReportPageNumberTextBox">
          <Style TextAlign="Center">
            <Font Name="Segoe UI" />
          </Style>
        </TextBox>
        <PictureBox Value="iVBORw0KGgoAAAANSUhEUgAAAFAAAAA0CAYAAAAddL/hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvAAADrwBlbxySQAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAA2fSURBVHhe7ZsJdFTVGccftioVXGuttaVQtXrcqqe2arVaNkHWCooLaAstevBQFUVcQAWhggugEHbZBEV2kIghCUlIDEFAEshCdjJZJ5nJbJk1k5l8/b5775uZN/Mm84ZAG075n3PPm3fvfXdefvPd7/vufS8SnFendB5gJ3XGAHpa86DZ/DbUNNwP5brucLJcgqKQQudUT+1G8wxwe46JK89tdQqgz2eCRuN4KK7ggIorJSjBUnoKj1TEOSt4zurxM/Vj/fE6veFZaPMZxIjnnk4LoM9vRUu6FwrLOBAZzEkEQtZGn6tqr2fWVqsfwI50TvXMGrFf6HVFOE51/d34gzSLbzh3FDfApuYXFOCY9WFpaHoM7M49olfHcji/wf5j2HVUZJA0bqNxouh1bkgzQH+7B8qqfsyA0R8s/+HWljWix+nJZl+P4wbHo/HLqrqB3+8UPbq2NAH0tBawqccsBQt9Nlvni9agWn3tUGTyQmqNGzaXOWHNSQesLLSzI51TPbV7/e3iiqAstk/59Mfx6Xvos9OVLlq7rmICdHsOs6klW0eF7jJob/eLVq4yixc2ljjg49wWWJDHy3z8/MnxFliSb2dHOpfbqB/1L7O0iRGCqqi+kn0PfWezZZao7brqEKC3rSoAj6ZYTcMDooWrweFjFiYD21TqhOPGVjC5lYBlUX0etlM/GSgBDpeu7g4wWeaKs66tDgGG+qU6/SBRy7Wv2s0gUNmrc4G7LXJadiQX9t9R4YQqW6QVnkuKClBOO6hU1d0iark+L3bAJ2g9ZH3WVnVr+3+RKkCKjJTosqCBAENFAYF82rbycyNKnm2pApRTFUpwPa2FohZgC0IjeLsrXaLmvCIAmixzGECyvFC/l2tohYU4bTdg9OxKMphssOXb7yFhYwqs+CoNdu8/hqua01/RHDxWBmu3Z8LiDSmweusBSD1YAE53q2iNVARAAidbX3u7l9W1t7eziEnWF0vph4rgxTkb4Eh+pagJqqi8DiTpfpB6DNFWfjQA7hw5Q1yt1KbEQ3DhreN5v6v/CtI1o3ihz5cNY8eRkxZiRDeKK6IrJ7cM7hgxHaSfDAbpypEg/exRPhYdf4rnPR4B6aZnYcr7X+CM5ExkKQA6XfuZ7yOItfq+ohYgGSMuWd8JTEE60hd7DoLUrR9I1z6GoPpCxvcnRQtX9g+lIF2FN4Q3o6n8cgyMfXWZuDqou0e9A9KlQ0H6zdO832+fAemGcbzQZ6q7ET9f/Sj0euhlcZW6/jD6XZAuQUC/fjJ4LRtvLB9Drrsez/HHenH2BnEllwJgfdNoBo/SF6c7Q9QCzEd4S1XytXA9MvFjkK57nH/hz0fBpJnrRAtXzrFyJcDeeNNkLdEK/gizl+wSV3ONeSkBrQKtTB4DIUs9h0C3m/Ez+yMRBrX/6gmQrhgOO5KPiCsjxeD8An9seSyCeMUItMIRcNFtE0DqhWOQhdN49D0XPQxtPp+4mksBUJ6+ZIWyThi9zPoON3ZsfaRjRVUgXdCf3ThNh6Zmm2jhUgBEeH9+eg6rd3u8qsUV5nucLg/7IwJWgZY++l+LRGtQydn5MIR+TIQTTdfcNxkhIxQah8a7fDjcO2YWGk+96BFUGrql4c8vgAeemi1qggqQ8vtdfC2KEKvr/yhqAbZjsksW6PRqy/f8uM7de+C4OFNKARB/7QfH/lu0aNPKzencL9H1aG0X3z5BtMSn+Wv2MisLwOs5FD5dv0+0xqcAQOb/cOrSZqfBNE3UAgscWqavFoUDlC1Qq+au2IOuYTS/Hv3f9QOmipb4xAIN+TcaB13OEy8niJb4FQBosS1l6QsVm507So+vnVnfTo15X0FpLfT6y8tw29A3mfMurlROh84CpBQlcL2YdhmHlYEqlrajT1SMgb62MwoAbDa/w7faKYCIbaRml48BTKt1s/NYWr8jizv/3k9hlBwGm/ceEi1c4QD7PvO+aNEughawHgKATv6Z15aL1tgaNfnToO/DIPHwhA9Fy+kpANBgei0A0O3+ntXpHRxgVr2HncfSl5TGyD4KU4jwCKgAiFPwpsHTYFfqD/D5ru8iyqotGVDTEJkQf/XNIWUgoSNFfkxFKEKH52nhuvreF4LpD2YKlDCrKbdIB6u3HYi4L6rLO1kteoUANJrfCgB0ubNYnUFYYEadNguMC6CAyPqrFQRC1qKmpV/u5xApzQgFSalG98Ew6B8fRqQbsljaIlswpicp2QWiRanbh73Jc83w+8IZdvPg10WvEIBm68KAD2xxbGN1Di/3gYlV2nxg3AAp8aVcUK2go+/IuVtsDpZWELBoIDcl5ojeQbEUS+6L93IQVyFqYsk6BSy6F9liqaDruefxmaJXCEC782sehbE0W4L5DgFcXaRt/RsXQITX486JcB/mXr9/9O2IctOgabAG16Sx1GxugX7PzlUHeeFA2JlyVPTkYlBCLDAp64RoUWrGJ9vgliFvsJXKzehqAhCjAWxrqw/kgXX6waIWl2clDrZpSuvhWIoLIN7IgL/PEy2dl7XFCf3/No+tSgIQCRRaXKh63DWRr1ioHX2glvyPsovQ+1YFSFLbAzyk97CVCD0MiqV4AcabxmhRUuYJngnIEK8cCXvSc0UrsMjPLJXa8EjLz1jKOlqiDSA9AGdrYQTZ6q1gdbT1Tg+B1hfHnsZdASBp4PgPEA76LvoenLLzViaKFoCF65L4Tgu13YiQcUUSS5oB2uzrmA8kiI3Gf4pagC1lTradVWdXj2yyugrAye+tx0AiNjUQ1oK1SaKFi/lL2UKvHQ1T5n4hWtSlGSCJ/GD4hoLF42dWSM9AOlK8AB8aF99aWKsYHNqOou/BxDs80o6YtDC4a0R9MWXal5UvWiNFe5uaAeoNY5kFkiUazW+IWvQtOjd7kER7g9EUF0BcrdCNtDjcbNNTrVRUN7HNiVD17vsKy+UmvPUZfJ2WiwuA4CZv8nf50JOCBP6R7DsIIoJSE9tMkIMJQcQVzZNTlkBDk0X04KLEfObiHcFtr1gA6aE57UazXekQKyQtL+DPgH8wqG9txQWQCi35KC+LVroPYulMqNiuMYGhKUqbArS0o4SXAgedy+kGQcE0Jppl0Y/DxgrtT/kjjUeFgFFEp3FleFQQ4O9GThejqAAk0QtEsi88VdNH1AJ7JYMArooylTfgUof9EXQzmGNtTeJLQlnfHS3lvzy1ayl4s7TVLmvxhmSQLh4EUh8ET+3yHxVaqJ42UxEebX91JHqewlId+lH7IEh5TDpSgAk9p++knfYL+sOshJ1ihCgASQSP+UIEaTBNEbW45MPlHe3SqCkVl0WS1I//glJftoUfqtJTet6uZm1q5eKHoX9Irujz+WH6wq1ww8CpQaujP552jKnQNWg1lFgbMcHWKnoYdc2fJvPgQj+wPB6NTd+BY9Iu07SPvmL5ZqiiAvR6TwVe66Ap3dm3sM6GyP/l5JZDYnoefJORxx5adVa0iUBjJWLuSE/o9EaraFFXVIAka8tnAX9IMGnP8LyU6hAgyWh6PZDa0FFvGCdazq6yGq0w41gVvHKkEtaVN4pabUqpN8NLhyvh+ZxyWBvntfEqJkBSs/ldxStu5bpL2Nr5bKje6QFpPQajpftBWpkO0pJUkBangLQoGT4uqBW91FVhc4G0LA2khFToty8fhu8vAmldFkgf7YXlJQ2i15mVJoAku3M3m86BFyDxc13jMMzTOl7i0S6P1xv5kF1Nelcrh7Umk//hWOacqIH3jlfDwOR8BnHq0VOit1IVLQhvbiIsOhnpB0ttDpAWfMvGOtPSDJBET+4qqq9SbDoQSF3dndBi3yR6KVWh6wmFpfwd6ljqvjGbwyMLROublRey80tA12JBiHVopeGSlqfBgqJaWHzCCpMONMILmY0wKVPPjq9kG6DEioDnJYLNe2Zfp4sLoCwKLvLutQySpjbBLNddipY5FCPkVOy3CoFfHuhD4E0W9eVbgRmthKYrwSNYOIVlDU0t5FOa2j7LgHGZJaKFKxP9JYEljUttgAKTB7IanJBndMORJjck5JtBZ/XDg0nHYXy2MrXqrE4LoCyLbRnzhxRcCGj4/4IQVDqnl8ip0GeqozZPa5EYhSuhuJ77PAbpADx3MLh+XVBYB/Pyaxg8stDe25QrnBm5VXDXHr5lNSFNDzl6F+w+1QLpdU7YU2WHpQVmKGz2wrKSeui17TDrd6bUKYCyvG01mLi+jVP5VmaVBJSsTbbQuAHi8euaZshuCr7Z0I3qaQqrAcRoLQN8MasJLB4flFhaodjsgWq7FzaWWkFn83VdgOHyt7sRUD6WPKhEnylbJYGl1+fUpJjCVHDKPpjEt9sZvNXCN6IVjg2fwnqcwktT4WA9RvCZeSC9dxz6bKyEe7brQPoQV0dY91y6AYak5netKaxFFboeLIjQi0uxpAgiGBRMHi9ct+Uwm9KsjnzjohSodagEkRVpLFqT3G1+ZoUmtw8c4pWUajvC7SpBJB7xNIbvbsdSaBpz2Zc5aDEYPFah35PhoYW+eqSDNAYBfYC+Mly5JjtI87+F2QLwmdRZBxivKEWRpzBZIQO4An0jJscfxUiky+VEGkH3x0R6BEukcSxMpJcV/48T6f+2KDWZjsFhCi7JTm8pV8Ei+dqyLrCUO6/oOg+wUwL4D1b6oR3iFsFjAAAAAElFTkSuQmCC" Width="0.900078495343523in" Height="0.564666132132213in" Left="5.59984270731608in" Top="0in" MimeType="image/png" Name="pictureBox1">
          <Style Visible="False">
            <BackgroundImage Repeat="NoRepeat" MimeType="image/png" />
          </Style>
        </PictureBox>
      </Items>
    </PageFooterSection>
  </Items>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="20, 34, 77">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Calibri" Size="9pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="Table" StyleName="Office.TableNormal" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="121, 167, 227" Color="20, 34, 77" VerticalAlign="Middle">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Calibri" Size="10pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Office.TableHeader" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Calibri" Size="9pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Office.TableBody" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind="A4" Landscape="False">
      <Margins>
        <MarginsU Left="0.800000011920929in" Right="0.800000011920929in" Top="1in" Bottom="0.300000011920929in" />
      </Margins>
    </PageSettings>
  </PageSettings>
  <ReportParameters>
    <ReportParameter Name="lang" Text="Language">
      <Value>
        <String>en-US</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="companyID" Type="Integer" Text="companyID">
      <Value>
        <String>1</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="fromYear" Type="Integer" Text="= IIf(&#xD;&#xA;Parameters.lang.Value=&quot;zh-CN&quot;,&#xD;&#xA;&quot;年 (由)&quot;,&#xD;&#xA;&#xD;&#xA;IIf(Parameters.lang.Value=&quot;zh-TW&quot;,&#xD;&#xA;&quot;年 (由)&quot;,&#xD;&#xA;&#xD;&#xA;&quot;Year (from)&quot;&#xD;&#xA;))">
      <Value>
        <String>2016</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="fromMonth" Type="Integer" Text="= IIf(&#xD;&#xA;Parameters.lang.Value=&quot;zh-CN&quot;,&#xD;&#xA;&quot;月 (由)&quot;,&#xD;&#xA;&#xD;&#xA;IIf(Parameters.lang.Value=&quot;zh-TW&quot;,&#xD;&#xA;&quot;月 (由)&quot;,&#xD;&#xA;&#xD;&#xA;&quot;Month (from)&quot;&#xD;&#xA;))">
      <Value>
        <String>1</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="toYear" Type="Integer" Text="= IIf(&#xD;&#xA;Parameters.lang.Value=&quot;zh-CN&quot;,&#xD;&#xA;&quot;年 (至)&quot;,&#xD;&#xA;&#xD;&#xA;IIf(Parameters.lang.Value=&quot;zh-TW&quot;,&#xD;&#xA;&quot;年 (至)&quot;,&#xD;&#xA;&#xD;&#xA;&quot;Year (to)&quot;&#xD;&#xA;))">
      <Value>
        <String>2016</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="toMonth" Type="Integer" Text="= IIf(&#xD;&#xA;Parameters.lang.Value=&quot;zh-CN&quot;,&#xD;&#xA;&quot;月 (至)&quot;,&#xD;&#xA;&#xD;&#xA;IIf(Parameters.lang.Value=&quot;zh-TW&quot;,&#xD;&#xA;&quot;月 (至)&quot;,&#xD;&#xA;&#xD;&#xA;&quot;Month (to)&quot;&#xD;&#xA;))">
      <Value>
        <String>12</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="locationIDs" Text="Location IDs" />
  </ReportParameters>
</Report>

Ivan Hristov
Telerik team
 answered on 26 Feb 2020
7 answers
859 views

Hello,

Is the following scenario possible in the standalone report designer without processing the raw data in sql query beforehand? 

I have an example list with participants - see attached InitialData.png

Each participant has taken part in multiple events. I need to show one row for each participant. On this same row I need to show data only for the first and the last events he has taken part in. First and last according to the date of the event, not its ID. At the same time i need to show/compare participant data from these two events - first and last - and show it on the same row accordingly. 

Example of the result data - see attached ResultData.png

I can group the data based on ParticipantId. But how can I find and show data for the first and last event?

 

Thanks in advance

 

 

Neli
Telerik team
 answered on 26 Feb 2020
2 answers
99 views

Hello,

 

I have a line graph with a start and end date filter. The data on the graph is for the past 5 years and the filter helps users to select any range between those 5 years.

 

However, the graph looks very condensed due to the 5 years of data. What i want to do is, by default, show only the past 12 months of data on the graph. Then the user can filter from the 5 years of data to get the graph they want. How is this possible? I have tried applying filtering/sorting but it does not give the required result. Attached is the graph that I have now.

 

Thank you.

Kunal
Top achievements
Rank 1
 answered on 25 Feb 2020
2 answers
351 views
I am using standalone Telerik Report Designer R3 2019.  I have created a .trdp file using standalone designer. As I am using SQLite data provider, I had to update the configuration file that comes with report designer and now I can create a data source with a provider type of "Sqlite Data Provider". 

I decided to embed a datasource in the report file so the reporting engine doesn't need to do any operation in the backend and fill data. Pretty straightforward. According to the forum post I have read If I am embedding the datasource I do not need to add config file in my application. But I cannot seem to view data using ReportViewer although I could view it on Preview using Standalone report designer. 

Any thoughts on this?
Jabed
Top achievements
Rank 1
 answered on 21 Feb 2020
6 answers
323 views

I am using HTML5 report viewer. 

When viewing a report, I want to see one continuous report because I do not need to see page headers, footers, or pages. But, when I go to print preview mode, it should be normal or it should look like paged mode. Can someone help me for my requirement?

 

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 21 Feb 2020
1 answer
507 views

I have a complex query that I didn't build myself that I need to use for a report. I ran the query in SQL Server and I can find the expected results. When I try to run this query in Telerik, I likewise get the expected results. But the expected results encompass data from as old as 2006.

There's a good chunk of data in the query and in order to make sure my report is working correctly on relevant data, I want to filter out the data that is older than 2018. I've tried to go about this two different ways. The first is I have tried to use the filter settings on the report itself.

Expression:
= Fields.EntryDate.Year >= 2018

Operator
=

Value
=True

This does not work and the preview always displays very old information first (what would appear at the beginning of the query in SQL Server). The rendering process takes too long to sit and wait before I can skip through thousands of pages before I see any data from 2018 or later. In fact, Telerik just crashes usually.

My next thought was to limit the results in the query itself. I use the WorkOrder.EntryDate in my WHERE clause and filter out dates older than 2018. I tested this query in SQL Server and it performs exactly as I expect it to. When I use this same query in Telerik, not only does the preview return 0 rows, but the preview is nothing more than a blank image. Is there a reason my SQL Server can process my query without issue, but Telerik fails to do so?

Todor
Telerik team
 answered on 21 Feb 2020
1 answer
74 views

We are experiencing this error with Telerik Reporting version 12.2.18.912:

https://feedback.telerik.com/reporting/1413307-error-handling-on-finishing-of-the-report-rendering

If I hover over the "Completed" tag, it says, "Implemented. Refer to the item for information about the release this is included in." Where can I find the information about how and when the error was fixed?

Neli
Telerik team
 answered on 21 Feb 2020
3 answers
666 views

Hi,

 

I have all my reports designed in telerik report designer.

The selection page for the report criteria is developed in .net and the report viewer used for reports is HTML5 report viewer.

How can we make our reports multilingual to show the static content on report in the language user has selected from selection page.

 

Regards,

Ashwini

Katia
Telerik team
 answered on 20 Feb 2020
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?