Пример #1
0
 public Task <Render2Response> Render2(string executionID, ReportServiceExecution.Render2Request request)
 {
     using (OperationContextScope context = SetMessageHeaders(executionID))
     {
         return(this.Render2Async(request));
     }
 }
        public async Task <Render2Response> Render2Async(string executionID, ReportServiceExecution.Render2Request request)
        {
            //using (OperationContextScope context = SetMessageHeaders(executionID))
            //{
            return(await this.Render2Async(request));

            //}
        }
Пример #3
0
        /// <summary>
        /// Searches a specific report for your provided searchText and returns the page that it located the text on.
        /// </summary>
        /// <param name="model"></param>
        /// <param name="searchText">The text that you want to search in the report</param>
        /// <param name="startPage">Starting page for the search to begin from.</param>
        /// <returns></returns>
        public static int?FindStringInReport(ReportViewerModel model, string searchText, int?startPage = 0)
        {
            var url = model.ServerUrl + ((model.ServerUrl.ToSafeString().EndsWith("/")) ? "" : "/") + "ReportExecution2005.asmx";

            var basicHttpBinding = _initializeHttpBinding(url, model);
            var service          = new ReportServiceExecution.ReportExecutionServiceSoapClient(basicHttpBinding, new System.ServiceModel.EndpointAddress(url));

            service.ClientCredentials.Windows.AllowedImpersonationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation;
            service.ClientCredentials.Windows.ClientCredential          = (System.Net.NetworkCredential)(model.Credentials ?? System.Net.CredentialCache.DefaultCredentials);

            var cred = model.Credentials?.GetCredential(new Uri(url), "Basic");

            service.ClientCredentials.UserName.UserName = cred?.UserName;
            service.ClientCredentials.UserName.Password = cred?.Password;

            var definedReportParameters = GetReportParameters(model, true);

            if (!startPage.HasValue || startPage == 0)
            {
                startPage = 1;
            }

            var exportResult = new ReportExportResult();

            exportResult.CurrentPage = startPage.ToInt32();
            exportResult.SetParameters(definedReportParameters, model.Parameters);

            var format         = "HTML4.0";
            var outputFormat   = $"<OutputFormat>{format}</OutputFormat>";
            var encodingFormat = $"<Encoding>{model.Encoding.EncodingName}</Encoding>";
            var htmlFragment   = ((format.ToUpper() == "HTML4.0" && model.UseCustomReportImagePath == false && model.ViewMode == ReportViewModes.View) ? "<HTMLFragment>true</HTMLFragment>" : "");
            var deviceInfo     = $"<DeviceInfo>{outputFormat}{encodingFormat}<Toolbar>False</Toolbar>{htmlFragment}</DeviceInfo>";

            if (model.ViewMode == ReportViewModes.View && startPage.HasValue && startPage > 0)
            {
                deviceInfo = $"<DeviceInfo>{outputFormat}<Toolbar>False</Toolbar>{htmlFragment}<Section>{startPage}</Section></DeviceInfo>";
            }

            var reportParameters = new List <ReportServiceExecution.ParameterValue>();

            foreach (var parameter in exportResult.Parameters)
            {
                bool addedParameter = false;
                foreach (var value in parameter.SelectedValues)
                {
                    var reportParameter = new ReportServiceExecution.ParameterValue();
                    reportParameter.Name  = parameter.Name;
                    reportParameter.Value = value;
                    reportParameters.Add(reportParameter);

                    addedParameter = true;
                }

                if (!addedParameter)
                {
                    var reportParameter = new ReportServiceExecution.ParameterValue();
                    reportParameter.Name = parameter.Name;
                    reportParameters.Add(reportParameter);
                }
            }

            var executionHeader = new ReportServiceExecution.ExecutionHeader();

            ReportServiceExecution.ExecutionInfo executionInfo = null;
            string extension = null;
            string encoding  = null;
            string mimeType  = null;

            string[] streamIDs = null;
            ReportServiceExecution.Warning[] warnings = null;

            try
            {
                string historyID = null;
                executionInfo = service.LoadReportAsync(model.ReportPath, historyID).Result;
                executionHeader.ExecutionID = executionInfo.ExecutionID;
                var executionParameterResult = service.SetReportParameters(executionInfo.ExecutionID, reportParameters.ToArray(), "en-us").Result;

                var renderRequest = new ReportServiceExecution.Render2Request(format, deviceInfo, ReportServiceExecution.PageCountMode.Actual);
                var result        = service.Render2(executionInfo.ExecutionID, renderRequest).Result;

                extension = result.Extension;
                mimeType  = result.MimeType;
                encoding  = result.Encoding;
                warnings  = result.Warnings;
                streamIDs = result.StreamIds;

                executionInfo = service.GetExecutionInfo(executionHeader.ExecutionID).Result;

                return(service.FindString(executionInfo.ExecutionID, startPage.ToInt32(), executionInfo.NumPages, searchText).Result);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            return(0);
        }
        public static async Task <ReportExportResult> ExportReportToFormatAsync(ReportViewerModel model, string format, int?startPage = 0, int?endPage = 0)
        {
            var definedReportParameters = await GetReportParametersAsync(model, true);

            var url = model.ServerUrl + ((model.ServerUrl.ToSafeString().EndsWith("/")) ? "" : "/") + "ReportExecution2005.asmx";

            var basicHttpBinding = _initializeHttpBinding(url, model);
            var service          = new ReportServiceExecution.ReportExecutionServiceSoapClient(basicHttpBinding, new System.ServiceModel.EndpointAddress(url));

            service.ClientCredentials.Windows.AllowedImpersonationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation;
            service.ClientCredentials.Windows.ClientCredential          = (System.Net.NetworkCredential)(model.Credentials ?? System.Net.CredentialCache.DefaultCredentials);

            var exportResult = new ReportExportResult();

            exportResult.CurrentPage = (startPage.ToInt32() <= 0 ? 1 : startPage.ToInt32());
            exportResult.SetParameters(definedReportParameters, model.Parameters);

            if (startPage == 0)
            {
                startPage = 1;
            }

            if (endPage == 0)
            {
                endPage = startPage;
            }

            var outputFormat   = $"<OutputFormat>{format}</OutputFormat>";
            var encodingFormat = $"<Encoding>{model.Encoding.EncodingName}</Encoding>";
            var htmlFragment   = ((format.ToUpper() == "HTML4.0" && model.UseCustomReportImagePath == false && model.ViewMode == ReportViewModes.View) ? "<HTMLFragment>true</HTMLFragment>" : "");
            var deviceInfo     = $"<DeviceInfo>{outputFormat}{encodingFormat}<Toolbar>False</Toolbar>{htmlFragment}</DeviceInfo>";

            if (model.ViewMode == ReportViewModes.View && startPage.HasValue && startPage > 0)
            {
                if (model.EnablePaging)
                {
                    deviceInfo = $"<DeviceInfo>{outputFormat}<Toolbar>False</Toolbar>{htmlFragment}<Section>{startPage}</Section></DeviceInfo>";
                }
                else
                {
                    deviceInfo = $"<DeviceInfo>{outputFormat}<Toolbar>False</Toolbar>{htmlFragment}</DeviceInfo>";
                }
            }

            var reportParameters = new List <ReportServiceExecution.ParameterValue>();

            foreach (var parameter in exportResult.Parameters)
            {
                bool addedParameter = false;
                foreach (var value in parameter.SelectedValues)
                {
                    var reportParameter = new ReportServiceExecution.ParameterValue();
                    reportParameter.Name  = parameter.Name;
                    reportParameter.Value = value;
                    reportParameters.Add(reportParameter);

                    addedParameter = true;
                }

                if (!addedParameter)
                {
                    var reportParameter = new ReportServiceExecution.ParameterValue();
                    reportParameter.Name = parameter.Name;
                    reportParameters.Add(reportParameter);
                }
            }

            var executionHeader   = new ReportServiceExecution.ExecutionHeader();
            var trustedUserHeader = new ReportServiceExecution.TrustedUserHeader();

            ReportServiceExecution.ExecutionInfo executionInfo = null;
            string extension = null;
            string encoding  = null;
            string mimeType  = null;

            string[] streamIDs = null;
            ReportServiceExecution.Warning[] warnings = null;

            try
            {
                string historyID      = null;
                var    taskLoadReport = await service.LoadReportAsync(trustedUserHeader, model.ReportPath, historyID);

                executionInfo = taskLoadReport.executionInfo;
                executionHeader.ExecutionID = executionInfo.ExecutionID;

                ;
                var executionParameterResult = await service.SetExecutionParametersAsync(taskLoadReport.ExecutionHeader, new ReportServiceExecution.TrustedUserHeader(), reportParameters.ToArray(), "en-us");

                if (model.EnablePaging)
                {
                    var renderRequest = new ReportServiceExecution.Render2Request(executionHeader, trustedUserHeader, format, deviceInfo, ReportServiceExecution.PageCountMode.Actual);
                    var result        = await service.Render2Async(executionInfo.ExecutionID, renderRequest);

                    extension = result.Extension;
                    mimeType  = result.MimeType;
                    encoding  = result.Encoding;
                    warnings  = result.Warnings;
                    streamIDs = result.StreamIds;

                    exportResult.ReportData = result.Result;
                }
                else
                {
                    var renderRequest = new ReportServiceExecution.RenderRequest(executionHeader, trustedUserHeader, format, deviceInfo);
                    var result        = await service.RenderAsync(executionInfo.ExecutionID, renderRequest);

                    extension = result.Extension;
                    mimeType  = result.MimeType;
                    encoding  = result.Encoding;
                    warnings  = result.Warnings;
                    streamIDs = result.StreamIds;

                    exportResult.ReportData = result.Result;
                }

                executionInfo = await service.GetExecutionInfoAsync(executionHeader.ExecutionID);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            exportResult.ExecutionInfo = executionInfo;
            exportResult.Format        = format;
            exportResult.MimeType      = mimeType;
            exportResult.StreamIDs     = (streamIDs == null ? new List <string>() : streamIDs.ToList());
            exportResult.Warnings      = (warnings == null ? new List <ReportServiceExecution.Warning>() : warnings.ToList());

            if (executionInfo != null)
            {
                exportResult.TotalPages = executionInfo.NumPages;
            }

            return(exportResult);
        }