public static Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[] ConvertPeriodicReportParameters(Hashtable parameters) { Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[] reportParameters = null; reportParameters = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[parameters.Count]; // set the report parameters if (parameters.Count > 0) { int i = 0; foreach (DictionaryEntry parameter in parameters) { try { reportParameters[i] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[i].Name = parameter.Key.ToString(); if (parameter.Value is DateTime) { //yyyy'-'MM'-'dd'T'HH':'mm':'ss (SortableDateTimePattern) reportParameters[i].Value = ((DateTime)parameter.Value).ToString("s"); } else { reportParameters[i].Value = parameter.Value.ToString(); } } catch (Exception Ex) { } i++; } } return(reportParameters); }
/// <summary> /// Get report parameter's values /// </summary> /// <remarks> /// This method is called in the ReportViewer control /// </remarks> /// <param name="parameters"></param> /// <returns></returns> public static Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[] ConvertReportParameters(Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[] parameters) { Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[] reportParameters = null; reportParameters = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[40]; reportParameters = parameters; return(reportParameters); }
/* * /// <summary> * /// Get report parameter's values * /// </summary> * /// <remarks> * /// This method is called in the export and stream rendering. * /// It gets sessionGuid id from querystring and gets parameter value array from session * /// </remarks> * /// <param name="parameters">It is from query string</param> * /// <returns></returns> * public static ParameterValue[] GetReportParameters(NameValueCollection parameters) * { * Hashtable paras; * * ParameterValue[] reportParameters = null; * * paras =(Hashtable)HttpContext.Current.Session[Util.GetSessionID()]; * * reportParameters = Util.GetReportParameters(paras); * * return reportParameters; * } */ /// <summary> /// Get report parameter's values from session /// </summary> /// <remarks> /// </remarks> /// <returns></returns> public static ReportExecution20051.ParameterValue[] GetReportParameters(string sessionID) { ReportExecution20051.ParameterValue[] reportParameters = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[0]; reportParameters = (ReportExecution20051.ParameterValue[])HttpContext.Current.Session[sessionID]; if (reportParameters == null) { throw new Exception("SESSION TIMEOUT: The required Browser session ID of " + sessionID + " could not be found (the current browser session = " + HttpContext.Current.Session.SessionID.ToString() + "), session timeout = " + HttpContext.Current.Session.Timeout.ToString() + " minutes. Has " + HttpContext.Current.Session.Timeout.ToString() + " minutes expired since you first displayed the Report?"); } return(reportParameters); }
public void ExportDataSetNew(string SP_Name, string Param1, string Param2, string Param3, string CurrentCultureName, ExportType FileType, String FileName, String ReportTitle, String LangInterfaceName, String LangResourceName, String Expanded) { Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[] reportParameters = null; reportParameters = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue[9]; reportParameters[0] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[0].Name = "SP_Name"; reportParameters[0].Value = SP_Name; reportParameters[1] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[1].Name = "Param1"; reportParameters[1].Value = Param1; reportParameters[2] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[2].Name = "Param2"; reportParameters[2].Value = Param2; reportParameters[3] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[3].Name = "Param3"; reportParameters[3].Value = Param3; reportParameters[4] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[4].Name = "CurrentCultureName"; reportParameters[4].Value = CurrentCultureName; reportParameters[5] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[5].Name = "LangInterfaceName"; reportParameters[5].Value = LangInterfaceName; reportParameters[6] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[6].Name = "Expanded"; reportParameters[6].Value = Expanded; reportParameters[7] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[7].Name = "ReportTitle"; reportParameters[7].Value = ReportTitle; reportParameters[8] = new Bdw.SqlServer.Reporting.ReportExecution20051.ParameterValue(); reportParameters[8].Name = "LangResourceName"; reportParameters[8].Value = LangResourceName; String format = "DOC"; if (FileType == ExportType.CSV) { format = "CSV"; } ; if (FileType == ExportType.PDF) { format = "PDF"; } ; if (FileType == ExportType.Excel) { format = "XLS"; } ; string thecontent; string[] streamIDs = null; Bdw.SqlServer.Reporting.ReportService20051.ReportingService2005 rs; Bdw.SqlServer.Reporting.ReportExecution20051.ReportExecutionService rsExec; rs = GetReportingService(); rsExec = GetReportExecutionService(); ReportSettings settings = GetSettings(); string encoding; string mimeType; string _historyID = null; Bdw.SqlServer.Reporting.ReportExecution20051.Warning[] warnings = null; string extension = null; Bdw.SqlServer.Reporting.ReportExecution20051.ExecutionInfo ei = rsExec.LoadReport(settings.ReportFolder + "/GridExport", _historyID); //rsExec.ExecutionHeaderValue.ExecutionID = SessionID; rsExec.SetExecutionParameters(reportParameters, "en-us"); string Format = "HTML4.0"; if (FileType == ExportType.PDF) { Format = "PDF"; } if (FileType == ExportType.Word) { Format = "WORD"; } if (FileType == ExportType.CSV) { Format = "CSV"; } if (FileType == ExportType.Excel) { Format = "EXCEL"; } //string deviceInfo = "<DeviceInfo><HTMLFragment>True</HTMLFragment><Toolbar>False</Toolbar><Section>0</Section><StreamRoot>{Emerging.Systems.MultipartMime}</StreamRoot></DeviceInfo>"; string deviceInfo = "<DeviceInfo><Encoding>ASCII</Encoding></DeviceInfo>"; Bdw.SqlServer.Reporting.ReportExecution20051.PageCountMode Exact = new Bdw.SqlServer.Reporting.ReportExecution20051.PageCountMode(); Exact = Bdw.SqlServer.Reporting.ReportExecution20051.PageCountMode.Actual; //byte[] content = rsExec.Render2(Format, deviceInfo, Exact, out extension, out mimeType, out encoding, out warnings, out streamIDs); byte[] content = rsExec.Render(Format, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = mimeType; Response.AppendHeader("Content-Length", content.Length.ToString()); Response.AddHeader("content-disposition", "attachment; filename=\"" + FileName + "." + extension + "\""); Response.BinaryWrite(content); Response.Flush(); Response.Close(); }