Still we are getting error. We have collapse/expand functionality on header click (you must have seen in RDL). So far we did some research and if we remove clickable headers the report doesn't give error. PFA code for reference.
try
{
Po_ReportingExecution.ReportExecutionService rs = new Po_ReportingExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
// Render arguments
byte[] result = null;
string reportPath = @"/StandardSSRSExport/LoadFactorExport";
string ExcelFormat = Convert.ToString(ConfigurationManager.AppSettings["ExcelFormat"]).Split('/')[0];
string format;
if (ExcelFormat != null)
format = ExcelFormat;
else
format = "Excel";
//string format = "Excel";
string historyID = null;
string devInfo = @"False";
// Prepare report parameter.
Po_ReportingExecution.ParameterValue[] parameters = new Po_ReportingExecution.ParameterValue[28];
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = new Po_ReportingExecution.ParameterValue();
}
if (Session["ReportParametrs"] != null)
{
dt = (System.Data.DataTable)Session["ReportParametrs"];
parameters[0].Name = "BU";
parameters[0].Value = dt.Rows[0]["BU"].ToString();
parameters[1].Name = "Analyst";
parameters[1].Value = dt.Rows[0]["Analyst"].ToString();
parameters[2].Name = "Dep_No";
parameters[2].Value = dt.Rows[0]["Dep_No"].ToString();
parameters[3].Name = "Origin";
parameters[3].Value = dt.Rows[0]["Origin"].ToString();
parameters[4].Name = "Destin";
parameters[4].Value = dt.Rows[0]["Destin"].ToString();
parameters[5].Name = "Res";
parameters[5].Value = dt.Rows[0]["Rsrc"].ToString();
parameters[6].Name = "E_Code";
parameters[6].Value = dt.Rows[0]["E_Code"].ToString();
parameters[7].Name = "IsSubClassLevel";
parameters[7].Value = dt.Rows[0]["IsSubClassLevel"].ToString();
parameters[8].Name = "DAYOFWK";
parameters[8].Value = dt.Rows[0]["DAYOFWK"].ToString();
parameters[9].Name = "Capture_Date";
parameters[9].Value = dt.Rows[0]["Capture_Date"].ToString();
parameters[10].Name = "FromDeparture_OriginalDate";
parameters[10].Value = dt.Rows[0]["FromDeparture_OriginalDate"].ToString();
parameters[11].Name = "ToDeparture_OriginalDate";
parameters[11].Value = dt.Rows[0]["ToDeparture_OriginalDate"].ToString();
parameters[12].Name = "HisOption";
parameters[12].Value = dt.Rows[0]["HisOption"].ToString();
parameters[13].Name = "CapType";
parameters[13].Value = dt.Rows[0]["CapType"].ToString();
parameters[14].Name = "LEG_SEG_TYPE";
parameters[14].Value = dt.Rows[0]["LEG_SEG_TYPE"].ToString();
parameters[15].Name = "roundTrip";
parameters[15].Value = dt.Rows[0]["roundTrip"].ToString();
//parameters[16].Name = "G1";
//parameters[16].Value = "Collapsed";
//parameters[17].Name = "G2";
//parameters[17].Value = "Collapsed";
//parameters[18].Name = "G3";
//parameters[18].Value = "Collapsed";
//parameters[19].Name = "G4";
//parameters[19].Value = "Collapsed";
//parameters[20].Name = "G5";
//parameters[20].Value = "Collapsed";
parameters[16].Name = "G1";
parameters[16].Value = (dt.Rows[0]["temp_Drillthroughs"].ToString().Contains("G1") == true) ? "Expanded" : "Collapsed";
parameters[17].Name = "G2";
parameters[17].Value = (dt.Rows[0]["temp_Drillthroughs"].ToString().Contains("G2") == true) ? "Expanded" : "Collapsed";
parameters[18].Name = "G3";
parameters[18].Value = (dt.Rows[0]["temp_Drillthroughs"].ToString().Contains("G3") == true) ? "Expanded" : "Collapsed";
parameters[19].Name = "G4";
parameters[19].Value = (dt.Rows[0]["temp_Drillthroughs"].ToString().Contains("G4") == true) ? "Expanded" : "Collapsed";
parameters[20].Name = "G5";
parameters[20].Value = (dt.Rows[0]["temp_Drillthroughs"].ToString().Contains("G5") == true) ? "Expanded" : "Collapsed";
parameters[21].Name = "ShowEqp";
parameters[21].Value = dt.Rows[0]["ShowEqp"].ToString();
parameters[22].Name = "FareMixData";
parameters[22].Value = dt.Rows[0]["FareMixData"].ToString();
parameters[23].Name = "Filter1";
parameters[23].Value = dt.Rows[0]["Filter1"].ToString();
parameters[24].Name = "Filter2";
parameters[24].Value = dt.Rows[0]["Filter2"].ToString();
parameters[25].Name = "Filter3";
parameters[25].Value = dt.Rows[0]["Filter3"].ToString();
parameters[26].Name = "DateFormat";
parameters[26].Value = dt.Rows[0]["DateFormat"].ToString();
parameters[27].Name = "Filter4";
parameters[27].Value = dt.Rows[0]["Filter4"].ToString();
}
Po_ReportingExecution.DataSourceCredentials[] credentials = null;
string showHideToggle = null;
string encoding;
string mimeType;
string extension;
Po_ReportingExecution.Warning[] warnings = null;
Po_ReportingExecution.ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
rs.Timeout = 99999999;
Po_ReportingExecution.ExecutionInfo execInfo = new Po_ReportingExecution.ExecutionInfo();
Po_ReportingExecution.ExecutionHeader execHeader = new Po_ReportingExecution.ExecutionHeader();
rs.ExecutionHeaderValue = execHeader;
execInfo = rs.LoadReport(reportPath, historyID);
rs.SetExecutionParameters(parameters, "en-us");
result = rs.Render(format, devInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);
execInfo = rs.GetExecutionInfo();
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
/*
//This header is for saving it as an Attachment and popup window should display to to offer save as or open a PDF file
Response.AddHeader("Content-Disposition", "attachment; filename=" + extension);
*/
// This header is use for open it in browser.
Response.AddHeader("content-disposition", "inline; filename=LoadFactor" + Convert.ToString(ConfigurationManager.AppSettings["ExcelFormat"]).Split('/')[1]);
Response.BinaryWrite(result);
Response.Flush();
Response.End();
}
catch (Exception ex)
{
oErrorHandler.createElmahLog(ex.Message, ex.StackTrace, ex.Source);
ScriptManager.RegisterStartupScript(this, GetType(), Guid.NewGuid().ToString(), "CloseReport();close();", true);
}