Questions on Reporting Forum

1 answer

188 views

Run sub report parallel to increase the report speed

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="{"companyID":"1","lang":"en-US"}">
<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(
Parameters.lang.Value="zh-CN",
"环境",

IIf(Parameters.lang.Value="zh-TW",
"環境",

"Environmental Performance"
))
" 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(
Parameters.lang.Value="zh-CN",
"在 " + Parameters.fromYear.Value + " 财政年度，我们透过以下各范畴管理我们的环保表现。",

IIf(Parameters.lang.Value="zh-TW",
"在 " + Parameters.fromYear.Value + " 財政年度，我們透過以下各範疇管理我們的環保表現。",

"In FY " + Parameters.fromYear.Value + ", we measured and managed our environmental performance in several aspects throughout our operations."
))
" 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(
Parameters.lang.Value="zh-CN",
"社会",

IIf(Parameters.lang.Value="zh-TW",
"社會",

"Social Performance"
))" 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(
Parameters.lang.Value="zh-CN",
"年 (由)",

IIf(Parameters.lang.Value="zh-TW",
"年 (由)",

"Year (from)"
))">
<Value>
<String>2016</String>
</Value>
</ReportParameter>
<ReportParameter Name="fromMonth" Type="Integer" Text="= IIf(
Parameters.lang.Value="zh-CN",
"月 (由)",

IIf(Parameters.lang.Value="zh-TW",
"月 (由)",

"Month (from)"
))">
<Value>
<String>1</String>
</Value>
</ReportParameter>
<ReportParameter Name="toYear" Type="Integer" Text="= IIf(
Parameters.lang.Value="zh-CN",
"年 (至)",

IIf(Parameters.lang.Value="zh-TW",
"年 (至)",

"Year (to)"
))">
<Value>
<String>2016</String>
</Value>
</ReportParameter>
<ReportParameter Name="toMonth" Type="Integer" Text="= IIf(
Parameters.lang.Value="zh-CN",
"月 (至)",

IIf(Parameters.lang.Value="zh-TW",
"月 (至)",

"Month (to)"
))">
<Value>
<String>12</String>
</Value>
</ReportParameter>
<ReportParameter Name="locationIDs" Text="Location IDs" />
</ReportParameters>
</Report>

General Discussions

answered on 26 Feb 2020

7 answers

906 views

How to get min and max record data in a group

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

Report Designer (standalone)

answered on 26 Feb 2020

2 answers

108 views

Filter Graph Data

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.

Report Designer (standalone)

answered on 25 Feb 2020

2 answers

376 views

Embedding a data source in report file

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?

Report Designer (standalone)

answered on 21 Feb 2020

6 answers

383 views

Viewing a report in continues mode

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?

General Discussions

answered on 21 Feb 2020

1 answer

567 views

SQL Query doesn't match Telerik Query

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?

Report Designer (standalone)

answered on 21 Feb 2020

1 answer

86 views

info about fixed error

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?

General Discussions

answered on 21 Feb 2020

3 answers

715 views

multilingual reports in telerik designer

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

Report Designer (standalone)

answered on 20 Feb 2020

1 answer

409 views

How to set SubReports DataSource in Asp.net Core

Here is my problem. Our shop has three environments that the development team must work with, development, testing and production. I have successfully been able to change the DataSource (WebServiceDataSource) of the master report by changing the ServiceUrl. For subreports I have been able to change the ReportSource based on the environment but I have not been able to locate a way to change the DataSource. Does anyone have an idea how this is done?

Here is the code I have right now:

public class TexasProtaxCustomReportResolver : Telerik.Reporting.Services.Engine.IReportResolver

{

private readonly string _path;

private readonly string _apiUrl;

public TexasProtaxCustomReportResolver(string path, string apiUrl)

{

_path = path;

_apiUrl = apiUrl;

}

public Telerik.Reporting.ReportSource Resolve(string reportName)

{

var reportPacker = new ReportPackager();

string reportPath = Path.Combine(_path, reportName);

using (var sourceStream = System.IO.File.OpenRead( reportPath))

{

var report = (Telerik.Reporting.Report)reportPacker.UnpackageDocument(sourceStream);

SetReportSource((ReportItemBase)report);

var irs = new InstanceReportSource

{

ReportDocument = report

};

return irs;

}

private void SetReportSource(ReportItemBase reportItemBase)

{

if (reportItemBase.Items.Count < 1)

return;

if (reportItemBase is Telerik.Reporting.Report)

{

var report = (Telerik.Reporting.Report)reportItemBase;

var webServiceDataSource = (WebServiceDataSource)report.DataSource;

string url = webServiceDataSource.ServiceUrl;

url = url.ToLower().Replace("localhost:5001", _apiUrl);

webServiceDataSource.ServiceUrl = url;

}

foreach (var item in reportItemBase.Items)

{

// recursively set the reportsource

SetReportSource(item);

if (item is SubReport subReport)

{

// Save Parameters

var clonable = subReport.ReportSource.Parameters as ICloneable;

var parameters = (ParameterCollection)clonable.Clone();

string fileName = Path.GetFileName(subReport.ReportSource.ToString());

var uriReportSource = new UriReportSource

{

Uri = Path.Combine(_path, fileName)

};

uriReportSource.Parameters.AddRange(parameters);

subReport.ReportSource = uriReportSource;

continue;

}

General Discussions

answered on 19 Feb 2020

2 answers

909 views

Index must be within the bounds of the list. Parameter name: index.

Ticket :1453373

Report shows all records in Visual Studio when I Preview it in the preview page but when running the winform application from the IDE (and as a stand alone app) the viewer stops when record count ~> 220 records showing the above error. When I capture the error event and display said error in a messagebox the first page is displayed. On it I can see that pages are calculated (as my first page displays page 1 of 75) so I can conclude that the records are definitely getting retrieved, just not displayed. I say that the record count is ~> 220 because when I narrow the parameters to display < 220 records the report is generated fine: adding 10 more records to the report causes the error.
As I said, the report previews perfectly.

I call the report using

Dim TR As MaserNET.ReportViewerForm1 = New MaserNET.ReportViewerForm1
TR.ReportName = "Maserrep.DDRegister, Maserrep, Version=4.0.0.0, Culture=neutral, PublicKeyToken=null"
TR.ShowDialog()

and the viewer shows the report using

Dim typeReportSource = New Telerik.Reporting.TypeReportSource()
Dim connectionStringHandler = New ReportConnectionStringManager(GlobalConnection.ConnectionString)
typeReportSource.TypeName = ReportName
Dim reportSource = connectionStringHandler.UpdateReportSource(typeReportSource) Me.ReportViewer1.ReportSource = reportSource Me.ReportViewer1.RefreshReport()

What am I missing????

General Discussions

answered on 19 Feb 2020