private void GeneratePDFReport()
        {
            string Grade = string.Empty; ;
            string Subject = string.Empty; ;
            string Course = string.Empty; ;
            string StudentId = string.Empty; ;

            if (Request.QueryString["Grade"] != null)
            { Grade = Standpoint.Core.Classes.Encryption.DecryptString(Request.QueryString["Grade"].ToString()); }

            if (Request.QueryString["Subject"] != null)
            { Subject = Standpoint.Core.Classes.Encryption.DecryptString(Request.QueryString["Subject"].ToString()); }

            if (Request.QueryString["Course"] != null)
            { Course = Standpoint.Core.Classes.Encryption.DecryptString(Request.QueryString["Course"].ToString()); }

            if (Request.QueryString["StudentId"] != null)
            { StudentId = Standpoint.Core.Classes.Encryption.DecryptString(Request.QueryString["StudentId"]); }

            var DParms = DistrictParms.LoadDistrictParms();
            string ClientID = DParms.ClientID;
            string Year = DParms.Year;

            Microsoft.Reporting.WebForms.ReportViewer rptViewer = new Microsoft.Reporting.WebForms.ReportViewer();
            rptViewer.ProcessingMode = ProcessingMode.Remote;


            rptViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials(reportUsername.Value, reportPassword.Value, reportDomain.Value);
            rptViewer.ServerReport.ReportServerUrl = new Uri(reportServerUrl.Value);
            rptViewer.ServerReport.ReportPath = reportPath.Value;

            rptViewer.ShowParameterPrompts = false;

            var reportParameterCollection = new ReportParameterCollection();
            reportParameterCollection.Add(new ReportParameter("ClientID", ClientID));
            reportParameterCollection.Add(new ReportParameter("Year", Year));
            reportParameterCollection.Add(new ReportParameter("Grade", Grade));
            reportParameterCollection.Add(new ReportParameter("Subject", Subject));
            reportParameterCollection.Add(new ReportParameter("Course", Course));
            reportParameterCollection.Add(new ReportParameter("StudentTGID", StudentId));

            rptViewer.ServerReport.SetParameters(reportParameterCollection);
            rptViewer.ServerReport.Refresh();

            Warning[] warnings;
            string[] streamids;
            string mimeType, encoding, extension;

            byte[] bytes = rptViewer.ServerReport.Render("PDF", string.Empty, out mimeType, out encoding, out extension, out streamids, out warnings);

            using (MemoryStream memoryStream = new MemoryStream(bytes))
            {
                Response.Clear();
                Response.Buffer = true;
                Response.ContentType = "application/pdf";
                Response.AddHeader("content-disposition", "inline; filename=AssessmentReportCard.pdf");
                Response.AddHeader("content-length", bytes.Length.ToString());
                Response.BinaryWrite(memoryStream.ToArray());
                Response.Flush();
                Response.End();
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Microsoft.Reporting.WebForms.ReportViewer rview = new Microsoft.Reporting.WebForms.ReportViewer();
            rview.ServerReport.ReportServerUrl = new Uri(WebConfigurationManager.AppSettings["ReportServer"]);

            System.Collections.Generic.List<Microsoft.Reporting.WebForms.ReportParameter> paramList = new System.Collections.Generic.List<ReportParameter>();
            paramList.Add(new Microsoft.Reporting.WebForms.ReportParameter("Param1", "Value1"));
            paramList.Add(new Microsoft.Reporting.WebForms.ReportParameter("Param2", "Value2"));

            rview.ServerReport.ReportPath = "/FlamingoSSRSReports/CustomerwiseInquiryReport";
            rview.ServerReport.SetParameters(paramList);

            string mimeType, encoding, extension, deviceInfo;
            string[] streamids;
            Microsoft.Reporting.WebForms.Warning[] warnings;

            string format = "Excel";

            deviceInfo = "<DeviceInfo>" + "<Head1>True</Head1>" + "</DeviceInfo>";
            byte[] bytes = rview.ServerReport.Render(format, deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
            Response.Clear();

            Response.ContentType = "application/excel";
            Response.AddHeader("Content-disposition", "filename=output.xls");

            Response.OutputStream.Write(bytes, 0, bytes.Length);
            Response.OutputStream.Flush();
            Response.OutputStream.Close();
            Response.Flush();
            Response.Close();
        }
Пример #3
0
        //SMC
        public ActionResult SMC(string FacilityCode, string sdate, string edate)
        {
            int x = 0;
            //Boolean y = false;
            ReportsModel obj = new ReportsModel();

            if (int.TryParse(FacilityCode, out x))
            {
                obj.FacilityCode = System.Convert.ToInt32(FacilityCode);
            }

            DateTime?StartDate = DateTime.ParseExact(sdate, "dd/MM/yyyy", null);
            DateTime?EndDate   = DateTime.ParseExact(edate, "dd/MM/yyyy", null);

            obj.StartDate = StartDate;
            obj.EndDate   = EndDate;
            Microsoft.Reporting.WebForms.ReportViewer reportViewer = new Microsoft.Reporting.WebForms.ReportViewer();
            reportViewer.ProcessingMode      = ProcessingMode.Local;
            reportViewer.SizeToReportContent = true;
            //reportViewer.Width = Unit.Percentage(900);
            //reportViewer.Height = Unit.Percentage(900);

            //List<spView_Admin_Calender_ScheduleAppointmentsGetAll_Result> titles = obj.GetDetailedReport();

            reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\Report_WebTemplate_SMC_SLM.rdlc";
            reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("ds_consumption", obj.SMC().ToList()));
            reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("ds_header", obj.SMC_Header().ToList()));

            ViewBag.ReportViewer = reportViewer;
            return(View());
        }
Пример #4
0
 public void ProcessReportShowing(Microsoft.Reporting.WebForms.ReportViewer myReportViewer)
 {
     try
     {
         foreach (Microsoft.Reporting.WebForms.RenderingExtension re in myReportViewer.LocalReport.ListRenderingExtensions())
         {
             ////屏蔽掉你需要取消的导出功能 Excel PDF WORD  
             //if (re.Name == "PDF")
             //{
             //    FieldInfo fi = re.GetType().GetField("m_isVisible", BindingFlags.Instance | BindingFlags.NonPublic);
             //    fi.SetValue(re, false);
             //}
             //else
             if (re.Name == "WORDOPENXML")
             {
                 FieldInfo fi = re.GetType().GetField("m_isVisible", BindingFlags.Instance | BindingFlags.NonPublic);
                 fi.SetValue(re, false);
             }
         }
         //谷歌兼容性修复
         myReportViewer.SizeToReportContent = true;
         myReportViewer.ShowPrintButton     = false;
     }
     catch
     {
     }
 }
Пример #5
0
        public ActionResult GenerateAndDisplayReport()
        {
            //ReportViewer reportViewer = new ReportViewer();
            //reportViewer.ProcessingMode = ProcessingMode.Remote;

            //reportViewer.ServerReport.ReportPath = "/AdventureWorks 2012/Sales_by_Region";
            //reportViewer.ServerReport.ReportServerUrl = new Uri("http://localhost/ReportServer/");

            //ViewBag.ReportViewer = reportViewer;

            ReportViewer rpvReports  = new Microsoft.Reporting.WebForms.ReportViewer();
            LocalReport  localReport = new LocalReport();

            return(View());

            System.Data.DataSet dsLocalReport = new System.Data.DataSet();
            ReportViewer        reportViewer  = new ReportViewer();

            reportViewer.ProcessingMode = ProcessingMode.Local;

            reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\YourLocalReport.rdlc";
            reportViewer.LocalReport.DataSources.Add(new ReportDataSource("dsLocalReport", dsLocalReport.Tables["SampleTable"]));

            ViewBag.ReportViewer = reportViewer;
        }
Пример #6
0
        private void OpenReportInPDF(Microsoft.Reporting.WebForms.ReportViewer rpViewerObj)
        {
            var path = Server.MapPath("~/CrystalPersonInfo.pdf");

            string mimeType, encoding, extension;

            string[] streamids; Microsoft.Reporting.WebForms.Warning[] warnings;
            string   format = "PDF";

            byte[] bytes = rpViewerObj.LocalReport.Render(format, "", out mimeType, out encoding, out extension, out streamids, out warnings);



            FileStream fs = new FileStream(path, FileMode.Create);

            byte[] data = new byte[fs.Length];
            fs.Write(bytes, 0, bytes.Length);
            fs.Close();

            Response.ContentType = "Application/pdf";
            //Get the physical path to the file.
            string FilePath = Server.MapPath("~/CrystalPersonInfo.pdf");

            //Write the file directly to the HTTP content output stream.
            Response.WriteFile(FilePath);
            Response.End();
        }
Пример #7
0
        private void OpenReportInPDF(Microsoft.Reporting.WebForms.ReportViewer rpViewerObj)
        {
            string reportType = "PDF";
            string mimeType;
            string encoding;
            string fileNameExtension;

            string deviceInfo = "<DeviceInfo>" + "<OutputFormat>PDF</OutputFormat>" + "</DeviceInfo>";

            Warning[] warnings;
            string[]  streams;
            byte[]    renderedBytes;

            //Render the report
            renderedBytes = rpViewerObj.LocalReport.Render(
                reportType,
                deviceInfo,
                out mimeType,
                out encoding,
                out fileNameExtension,
                out streams,
                out warnings);

            Response.Clear();
            Response.ContentType = mimeType;
            Response.AddHeader("content-disposition", "attachment; filename=UniSoftReport." + fileNameExtension);
            Response.BinaryWrite(renderedBytes);
            Response.End();
        }
Пример #8
0
        public ActionResult RelatorioPedido()
        {
            Usuario admin = (Usuario)HttpContext.Session["admin"];

            if (admin == null)
            {
                return(View("Login"));
            }

            var viewer = new Microsoft.Reporting.WebForms.ReportViewer();

            viewer.ProcessingMode         = Microsoft.Reporting.WebForms.ProcessingMode.Local;
            viewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"report/RelatorioPedido.rdlc";

            ReportDataSource datasource = new ReportDataSource();

            datasource.Name  = "DataSet1";
            datasource.Value = PedidoBO.ListarTodosPedidos();
            viewer.LocalReport.DataSources.Add(datasource);
            viewer.SizeToReportContent = true;
            viewer.Width         = System.Web.UI.WebControls.Unit.Pixel(800);
            viewer.Height        = System.Web.UI.WebControls.Unit.Pixel(1200);
            ViewBag.ReportViewer = viewer;

            return(View("Relatorio"));
        }
Пример #9
0
        public ActionResult All_Products(string sdate, string edate, int?_emmergency)
        {
            bool?emergency = null;

            if (_emmergency == 1)
            {
                emergency = false;
            }
            else if (_emmergency == 2)
            {
                emergency = true;
            }
            ProductModel obj       = new ProductModel();
            DateTime?    StartDate = DateTime.ParseExact(sdate, "dd/MM/yyyy", null);
            DateTime?    EndDate   = DateTime.ParseExact(edate, "dd/MM/yyyy", null);

            // obj.GetAll(StartDate, EndDate);
            //obj.EndDate = EndDate;
            Microsoft.Reporting.WebForms.ReportViewer reportViewer = new Microsoft.Reporting.WebForms.ReportViewer();
            reportViewer.ProcessingMode      = ProcessingMode.Local;
            reportViewer.SizeToReportContent = true;

            reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Views\Queries\ALLProducts.rdlc";
            reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("aLLProducts", obj.GetOrders(StartDate, EndDate, emergency).ToList()));

            ViewBag.ReportViewer = reportViewer;
            return(View());
        }
Пример #10
0
        public void GenerateSLIIReport(string ProspectCode)
        {
            Microsoft.Reporting.WebForms.ReportViewer vr  = new Microsoft.Reporting.WebForms.ReportViewer();
            System.Data.SqlClient.SqlConnection       con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
            con.Open();
            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
            cmd.Connection  = con;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "USP_GetSLIIEXAMAPPLICATIONPDF";
            cmd.Parameters.AddWithValue("@ProspectCode", ProspectCode);
            List <DataSet> dslst = new List <DataSet>();
            DataSet        ds    = new DataSet();

            System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);
            da.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {
                dslst.Add(ds);
                ReportParameter[] parameters = new ReportParameter[1];
                parameters[0] = new ReportParameter("ProspectCode", ProspectCode);

                byte[] bytes = GenerateRDLCReports(dslst, null, @"~/Reports/AgentonBoarding/SLIIExamination.rdlc");
                RenderReports(bytes, "AIA SLII Examination Letter");
            }
        }
Пример #11
0
        public static ReportDados ToReport <T>(this IEnumerable <T> dados, string fileRdlc, enumReportFormat format, string dataSetName)
        {
            ReportViewer rv = new Microsoft.Reporting.WebForms.ReportViewer();

            rv.ProcessingMode         = ProcessingMode.Local;
            rv.LocalReport.ReportPath = fileRdlc;

            ReportDataSource reportDataSource = new ReportDataSource();

            reportDataSource.Name  = dataSetName;
            reportDataSource.Value = ConvertToDataTable(dados);
            rv.LocalReport.DataSources.Add(reportDataSource);

            byte[] streamBytes       = null;
            string mimeType          = "";
            string encoding          = "";
            string filenameExtension = "";

            string[]  streamids = null;
            Warning[] warnings  = null;

            streamBytes = rv.LocalReport.Render(format.ToString(), null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);

            return(new ReportDados()
            {
                Content = streamBytes, MimeType = mimeType, Encoding = encoding, FileNameExtension = filenameExtension, Warnings = warnings
            });
        }
        ConfigReportViewer()
        {
            var reportViewer = new Microsoft.Reporting.WebForms.ReportViewer();

            reportViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;

            reportViewer.ViewStateMode       = System.Web.UI.ViewStateMode.Inherit;
            reportViewer.SizeToReportContent = true;
            reportViewer.Width             = System.Web.UI.WebControls.Unit.Percentage(110);
            reportViewer.Height            = System.Web.UI.WebControls.Unit.Percentage(100);
            reportViewer.AsyncRendering    = true;
            reportViewer.ZoomMode          = Microsoft.Reporting.WebForms.ZoomMode.FullPage;
            reportViewer.BackColor         = System.Drawing.ColorTranslator.FromHtml("#FFFBF7");
            reportViewer.ShowPrintButton   = true;
            reportViewer.ShowRefreshButton = false;

            reportViewer.ShowZoomControl = true;

            PermissionSet permissions = new PermissionSet(PermissionState.None);

            permissions.AddPermission(new FileIOPermission(PermissionState.Unrestricted));
            permissions.AddPermission(new SecurityPermission(SecurityPermissionFlag.Execution));

            reportViewer.LocalReport.SetBasePermissionsForSandboxAppDomain(permissions);

            Assembly     asm      = Assembly.Load(Assembly.GetExecutingAssembly().FullName);
            AssemblyName asm_name = asm.GetName();

            reportViewer.LocalReport.AddFullTrustModuleInSandboxAppDomain(new StrongName(new StrongNamePublicKeyBlob(asm_name.GetPublicKeyToken()), asm_name.Name, asm_name.Version));

            return(reportViewer);
        }
Пример #13
0
        public void GeneratePersonalData(string ProspectCode)
        {
            Microsoft.Reporting.WebForms.ReportViewer vr  = new Microsoft.Reporting.WebForms.ReportViewer();
            System.Data.SqlClient.SqlConnection       con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
            //System.Data.SqlClient.SqlConnection(@"data source = issdbs01; database = AVOJSLife; Uid = sa_policyjs; Pwd = iNube@123;");
            con.Open();
            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
            cmd.Connection  = con;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[USP_Getpersonaldatapdf]";
            cmd.Parameters.AddWithValue("@ProspectCode", ProspectCode);
            List <DataSet> dslst = new List <DataSet>();
            DataSet        ds    = new DataSet();

            System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);
            da.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {
                dslst.Add(ds);
                ReportParameter[] parameters = new ReportParameter[1];
                parameters[0] = new ReportParameter("ProspectCode", ProspectCode);

                byte[] bytes = GenerateRDLCReports(dslst, null, @"~/Reports/AgentonBoarding/PersonalDataForm.rdlc");
                RenderReports(bytes, "AIA Personal Data Letter");
            }
        }
Пример #14
0
        public bool CreateReport(ref Microsoft.Reporting.WebForms.ReportViewer ReportViewer)
        {
            ReportViewer.LocalReport.ReportPath = System.Configuration.ConfigurationManager.AppSettings["ReportPath"].ToString() + _reportConfig.ReportName;

            SqlDataSource sqlDS = new SqlDataSource();

            sqlDS.ConnectionString  = ConfigurationHelper.GetsmARTDBContextConnectionString();
            sqlDS.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
            sqlDS.SelectCommand     = _reportConfig.StoreProcedureName;
            foreach (var param in _reportConfig.Parameters)
            {
                sqlDS.SelectParameters.Add(param.Key, param.Value.ToString());
            }
            ReportDataSource datasource1 = new ReportDataSource(_reportConfig.ReportDataSetName, sqlDS);

            ReportViewer.LocalReport.DataSources.Clear();
            ReportViewer.LocalReport.DataSources.Add(datasource1);

            List <ReportParameter> rptParams = new List <ReportParameter>();

            foreach (var param in _reportConfig.Parameters)
            {
                ReportParameter rptParam = new ReportParameter(param.Key, param.Value.ToString());
                rptParams.Add(rptParam);
            }
            ReportViewer.LocalReport.SetParameters(rptParams);

            ReportViewer.LocalReport.Refresh();
            return(true);
        }
Пример #15
0
        public ActionResult OrderTracking(string Order_Number)
        {
            //int x = 0;
            //Boolean y = false;
            ReportsModel obj = new ReportsModel();

            //if (int.TryParse(ProductCategory, out x))
            //    obj.ProductCategoryId = System.Convert.ToInt32(ProductCategory);
            obj.OrderNumber = Order_Number;

            Microsoft.Reporting.WebForms.ReportViewer reportViewer = new Microsoft.Reporting.WebForms.ReportViewer();
            reportViewer.ProcessingMode      = ProcessingMode.Local;
            reportViewer.SizeToReportContent = true;
            //reportViewer.Width = Unit.Percentage(900);
            //reportViewer.Height = Unit.Percentage(900);

            //List<spView_Admin_Calender_ScheduleAppointmentsGetAll_Result> titles = obj.GetDetailedReport();

            reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\OrderStatus.rdlc";
            reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("OrderStatus", obj.GetCurrentTracking().ToList()));
            reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("OrderDetails", obj.GetTrackingDetails().ToList()));
            //reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("ds_regional_activity", obj.GetCoARegionalMeetings().ToList()));
            //reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("ds_activity_distribution", obj.GetCoADistributionOfActivities().ToList()));
            //reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("CoA_AcitivitiesByFundingType", obj.GetCoAActivitiesByFundingType().ToList()));
            //reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("CoA_AcitivitiesByMeetingType", obj.GetCoAActivitiesByMeetingType().ToList()));

            ViewBag.ReportViewer = reportViewer;
            return(View());
        }
Пример #16
0
        public ActionResult Fluconazole(string sdate, string edate, int?_emmergency)
        {
            bool?emergency = null;

            if (_emmergency == 1)
            {
                emergency = false;
            }
            else if (_emmergency == 2)
            {
                emergency = true;
            }
            ARTModels obj       = new ARTModels();
            DateTime? StartDate = DateTime.ParseExact(sdate, "dd/MM/yyyy", null);
            DateTime? EndDate   = DateTime.ParseExact(edate, "dd/MM/yyyy", null);

            // obj.GetAll(StartDate, EndDate);
            //obj.EndDate = EndDate;
            Microsoft.Reporting.WebForms.ReportViewer reportViewer = new Microsoft.Reporting.WebForms.ReportViewer();
            reportViewer.ProcessingMode      = ProcessingMode.Local;
            reportViewer.SizeToReportContent = true;

            reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Views\Queries\Fluconazole.rdlc";
            reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("fluconazole", obj.GetTreatment_Fluconazole(StartDate, EndDate, emergency)));

            ViewBag.ReportViewer = reportViewer;
            return(View());
        }
Пример #17
0
        public HttpResponseMessage SalesReportView(int id, SalesGetReportEntity obj)
        {
            HttpResponseMessage message;

            try
            {
                //dsRptInvoice

                //DalLayer dal = new DalLayer();
                var result           = _POMasterService.ReturnSalesList(id, obj);
                ReportDataSource rds = new ReportDataSource();
                rds.Name  = "DataSet3";
                rds.Value = result.Tables[0];

                ReportDataSource rds1 = new ReportDataSource();
                rds1.Name  = "DataSet4";
                rds1.Value = result.Tables[1];



                ReportViewer rv = new Microsoft.Reporting.WebForms.ReportViewer();
                rv.ProcessingMode         = ProcessingMode.Local;
                rv.LocalReport.ReportPath = System.Web.Hosting.HostingEnvironment.MapPath("~/report/SalesReport.rdlc");

                // Add the new report datasource to the report.
                rv.LocalReport.DataSources.Add(rds);
                rv.LocalReport.DataSources.Add(rds1);

                rv.LocalReport.Refresh();
                //rv.LocalReport.

                byte[]    streamBytes       = null;
                string    mimeType          = "";
                string    encoding          = "";
                string    filenameExtension = "";
                string[]  streamids         = null;
                Warning[] warnings          = null;

                streamBytes = rv.LocalReport.Render("PDF", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);
                string filename     = Guid.NewGuid().ToString().Replace("-", string.Empty).Substring(0, 8);
                string locationPath = System.Web.Hosting.HostingEnvironment.MapPath("~/report/");
                using (FileStream stream = new FileStream(locationPath + filename + ".pdf", FileMode.Create))
                {
                    stream.Write(streamBytes, 0, streamBytes.Length);
                }
                ResultSales rs = new ResultSales();
                rs.data = result;
                rs.path = filename + ".pdf";
                message = Request.CreateResponse(HttpStatusCode.OK, rs);
            }
            catch (Exception ex)

            {
                //_invoice.errorLog(ex.Message.ToString());
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" });
            }
            return(message);
        }
Пример #18
0
            public PagingState(ReportNavigation navigationControl)
            {
                _reportViewer = (ReportViewer)navigationControl.Parent.FindControl(navigationControl.ReportViewerID);
                _currentPage  = (HiddenField)navigationControl.Parent.FindControl(navigationControl.CurrentPageControlID);
                _dirtyPage    = (HiddenField)navigationControl.Parent.FindControl(navigationControl.DirtyPageID);

                _dirtyPage.Value = bool.FalseString;
                InitCurrentPage();
            }
Пример #19
0
        private static void GuardaCatalogos(List <Categorias> categorias)
        {
            List <FutureVisitsModel> lstcatalogos = new List <FutureVisitsModel>();
            FutureVisitsModel        cat          = new FutureVisitsModel();

            foreach (var categoria in categorias)
            {
                cat.id     = categoria.Id.ToString();
                cat.nombre = categoria.Nombre;

                foreach (var marca in categoria.Submarcas)
                {
                    //cat.descripcion = marca.Descripcion;
                    //cat.marca = marca.Marca;
                    //cat.subMarca = marca.Submarca;
                    //cat.claveBanorte = marca.ClaveBanorte;
                    //cat.anio = marca.Anio.ToString();
                    cat.idSM     = marca.Id.ToString();
                    cat.nombreSM = marca.Nombre;

                    //cat.idLoc = local.Id.ToString();
                    //cat.municipio = local.Municipio;
                    //cat.estado = local.Estado;
                    lstcatalogos.Add(cat);
                    cat = new FutureVisitsModel();
                }
                //lstcatalogos.Add(cat);
            }

            //Catalogos catal = new Catalogos();
            //foreach (var catalogo in catalogos.Result)
            //{
            //    catal.Codigo = catalogo.Codigo;
            //    catal.Descripcion = catalogo.Descripcion;
            //}

            Microsoft.Reporting.WebForms.ReportViewer rv = new Microsoft.Reporting.WebForms.ReportViewer();
            Warning[] warnings;
            string[]  streamids;
            string    mimeType;
            string    encoding;
            string    extension;

            rv.ProcessingMode         = ProcessingMode.Remote;
            rv.LocalReport.ReportPath = @"C:/Users/SaoSistemas/Desktop/atlasws/atlasws/Report9.rdlc";
            rv.LocalReport.DataSources.Clear();

            rv.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", lstcatalogos));
            byte[] bytes = rv.LocalReport.Render("EXCEL", null, out mimeType, out encoding, out extension, out streamids, out warnings);

            string     absoluteFileName = Path.Combine(@"C:/Users/SaoSistemas/Desktop/atlasws", "SubMarca_VehRegularizados.xls");
            FileStream file             = new FileStream(absoluteFileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);

            file.Write(bytes, 0, bytes.Length);
            file.Close();
            file.Dispose();
        }
Пример #20
0
        private void ExportToPdf()
        {
            Microsoft.Reporting.WebForms.ReportViewer oViewer = new Microsoft.Reporting.WebForms.ReportViewer();

            if (reportName != string.Empty)
            {
                oViewer.LocalReport.ReportEmbeddedResource = reportName;
            }
            oViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(RptSubreportProcessingEventHandler);
            oViewer.LocalReport.DataSources.Clear();

            ReportDataSource ds = new ReportDataSource(reportDatasourceName, dataSource);

            oViewer.LocalReport.DataSources.Add(ds);

            // David [2008-10-27] : In case some reports using extrenal images, the Property 'EnableExternalImages' should be enabled.
            oViewer.LocalReport.EnableExternalImages = true;

            int paramCount = this.parameters.GetLength(0);

            if (paramCount > 0)
            {
                ReportParameter[] param = new ReportParameter[paramCount];
                for (int i = 0; i < paramCount; i++)
                {
                    param[i] = new ReportParameter(parameters[i, 0], parameters[i, 1]);
                }
                oViewer.LocalReport.SetParameters(param);
            }

            oViewer.ProcessingMode = ProcessingMode.Local;
            oViewer.LocalReport.Refresh();

            Warning[] warnings;
            string[]  streamids;
            string    mimeType;
            string    encoding;
            string    extension;

            byte[] bytes = oViewer.LocalReport.Render(
                "PDF", null, out mimeType, out encoding, out extension,
                out streamids, out warnings
                );

            HttpResponse response = VWGContext.Current.HttpContext.Response;

            response.Clear();
            response.ClearHeaders();

            response.ContentType = "application/pdf";
            response.AddHeader("content-disposition", "attachment; filename=\"Export.pdf\"");
            response.BinaryWrite(bytes);
            response.Flush();
            response.End();
        }
Пример #21
0
        protected void BindDataSource(MsReportViewer reportViewer, IReport report)
        {
            if (report.ReportProcessingLocation is ILocalReportProcessingLocation)
            {
                reportViewer.ProcessingMode = MsProcessingMode.Local;

                BindLocalReport(reportViewer.LocalReport, report);
            }
            else
            {
                reportViewer.ProcessingMode = MsProcessingMode.Remote;

                BindServerReport(reportViewer.ServerReport, report);
            }
        }
Пример #22
0
 private void ConfigureLogoParameter(string logo, Microsoft.Reporting.WebForms.ReportViewer viewer)
 {
     if (!string.IsNullOrWhiteSpace(logo))
     {
         _logger.Debug($"Start SetParameters ImagePath: {string.Join("", logo.Take(250))}");
         if (logo.Contains("http"))
         {
             viewer.LocalReport.SetParameters(new ReportParameter("ImagePath", logo));
         }
         else
         {
             viewer.LocalReport.SetParameters(new ReportParameter("ReportLogo", logo));
         }
         _logger.Debug($"End SetParameters ImagePath: {string.Join("", logo.Take(250))}");
     }
 }
Пример #23
0
        public Engine(string baseUrl, string reportPath, string reportName, NameValueCollection querystring)
        {
            this.BaseUrl       = baseUrl;
            this.ReportPath    = reportPath;
            this.ReportName    = reportName;
            this.ErrorMessages = new List <ErrorMessage>();

            this.CurrentReportViewer = new WebForms.ReportViewer
            {
                ProcessingMode      = WebForms.ProcessingMode.Local,
                SizeToReportContent = true
            };

            _reportParameters = new Hashtable();
            this.CurrentReportViewer.ReportError += CurrentReportViewer_ReportError;
            SetParameters(querystring);
        }
Пример #24
0
        private void SaveReport()
        {
            //clsNum2Word csw = new clsNum2Word();
            ExamUserComponent ec = new ExamUserComponent();
            int    ResDetId      = CurrentSession.CurrStudent.ExamResultDetail.ExmResultDetailId;
            int    StudId        = CurrentSession.CurrStudent.StudentId;
            string FileName      = CurrentSession.FileName.ToString();
            bool   isModExam     = CurrentSession.CurrStudent.isModExam;

            DataSet dsComp     = ec.GetCompInfo();
            DataSet dsExamRes  = ec.GetExamResultPrint(ResDetId, StudId, 1, false);
            DataSet dsExResSum = ec.GetExamResultPrint(ResDetId, StudId, 2, false);

            Microsoft.Reporting.WebForms.ReportViewer rview = new Microsoft.Reporting.WebForms.ReportViewer();
            rview.ProcessingMode         = ProcessingMode.Local;
            rview.LocalReport.ReportPath = Server.MapPath("~/eReports/Rdlc/rpt_examResult.rdlc");

            rview.LocalReport.DataSources.Clear();
            rview.LocalReport.DataSources.Add(new ReportDataSource("dsCompInfo", dsComp.Tables[0]));
            rview.LocalReport.DataSources.Add(new ReportDataSource("dsResPrint", dsExamRes.Tables[0]));
            rview.LocalReport.DataSources.Add(new ReportDataSource("dsExamSum", dsExResSum.Tables[0]));
            rview.LocalReport.Refresh();

            string mimeType, encoding, extension, deviceInfo;

            string[] streamids;
            Microsoft.Reporting.WebForms.Warning[] warnings;

            //Desired format goes here (PDF, Excel, or Image)
            deviceInfo = "<DeviceInfo>" + "<SimplePageHeaders>True</SimplePageHeaders>" + "</DeviceInfo>";
            byte[] bytes = rview.LocalReport.Render("PDF", deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
            Response.Clear();

            System.IO.FileStream oFileStream = null;
            string strFilePath = string.Empty;

            //strFilePath = ConfigurationManager.AppSettings["AttachFile"].ToString() + FileName + ".pdf";// Server.MapPath("../EmailAttachments/" + filename1 + ".pdf");
            //strFilePath = strFilePath.Replace("\\\\", "\\");
            strFilePath = Server.MapPath("~/AttachFile/" + FileName + ".pdf");
            oFileStream = new System.IO.FileStream(strFilePath, System.IO.FileMode.Create);
            oFileStream.Write(bytes, 0, bytes.Length);
            oFileStream.Close();

            //string script = string.Format("~/eReports/PdfReport.aspx?FileName={0}", FileName);
            //ScriptManager.RegisterStartupScript(this, this.GetType(), "openprintwindow", "javascript:window.open('" + ResolveClientUrl(script) + "',null,'width=850px,height=630px,scrollbars=yes,,resizable=yes,toolbar=no,menubar=no,location=no');", true);
        }
Пример #25
0
        public FileResult File()
        {
            ReportViewer rv = new Microsoft.Reporting.WebForms.ReportViewer();
            rv.ProcessingMode = ProcessingMode.Local;
            rv.LocalReport.ReportPath = Server.MapPath("~/AuditingLogs2/AuditReport.rdlc");
            rv.LocalReport.Refresh();

            byte[] streamBytes = null;
            string mimeType = "";
            string encoding = "";
            string filenameExtension = "";
            string[] streamids = null;
            Warning[] warnings = null;

            streamBytes = rv.LocalReport.Render("PDF", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);

            return File(streamBytes, mimeType, "AuditReport.pdf");
        }
Пример #26
0
        public byte[] Generate(string reportPath, string logo, IDictionary <string, string> paramenters, IDictionary <string, object[]> dataSources, string format, out string extension)
        {
            try
            {
                Warning[] warnings;
                string[]  streamids;
                string    mimeType;
                string    encoding;

                var viewer = new Microsoft.Reporting.WebForms.ReportViewer();
                viewer.ProcessingMode = ProcessingMode.Local;
                viewer.LocalReport.EnableHyperlinks = true;
                viewer.LocalReport.ReportPath       = reportPath;
                _logger.Debug($"Report Path: {reportPath}");
                viewer.LocalReport.EnableExternalImages = true;

                foreach (var d in paramenters)
                {
                    _logger.Debug($"Start SetParameters: {d.Key}");
                    viewer.LocalReport.SetParameters(new ReportParameter(d.Key, d.Value));
                    _logger.Debug($"End SetParameters: {d.Key}");
                }

                ConfigureLogoParameter(logo, viewer);

                foreach (var d in dataSources)
                {
                    var reportDataSource = new ReportDataSource(d.Key, d.Value);
                    viewer.LocalReport.DataSources.Add(reportDataSource);
                }
                _logger.Debug($"Start Render report: {reportPath}");
                byte[] bytes = viewer.LocalReport.Render(
                    format, null, out mimeType, out encoding, out extension,
                    out streamids, out warnings);
                _logger.Debug($"End Render report: {reportPath}");
                return(bytes);
            }
            catch (Exception ex)
            {
                _logger.Error(ex.Message, ex);
                throw;
            }
        }
 private void Load(Microsoft.Reporting.WebForms.ReportViewer rptViewer, string reportType, ReportParameter[] reportParma)
 {
     if (string.IsNullOrEmpty(reportType))
     {
         throw new Exception("Null ReportParameter Or Null Report Name");
     }
     rptViewer.ProcessingMode = ProcessingMode.Remote;
     rptViewer.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportURL"]);
     rptViewer.ServerReport.ReportPath      = "/EMS.Report/" + reportType;
     rptViewer.ServerReport.SetParameters(reportParma);
     rptViewer.ServerReport.DisplayName = reportType + "_" + DateTime.Now.Ticks.ToString();
     rptViewer.ShowCredentialPrompts    = false;
     rptViewer.ShowPrintButton          = true;
     rptViewer.ShowParameterPrompts     = false;
     rptViewer.ShowPromptAreaButton     = false;
     rptViewer.ShowToolBar     = true;
     rptViewer.ShowPrintButton = true;
     rptViewer.ShowReportBody  = true;
     rptViewer.ServerReport.Refresh();
 }
Пример #28
0
        public FileResult File()
        {
            ReportViewer rv = new Microsoft.Reporting.WebForms.ReportViewer();

            rv.ProcessingMode         = ProcessingMode.Local;
            rv.LocalReport.ReportPath = Server.MapPath("~/Reports/RDLC/Report1.rdlc");
            rv.LocalReport.Refresh();

            byte[] streamBytes       = null;
            string mimeType          = "";
            string encoding          = "";
            string filenameExtension = "";

            string[]  streamids = null;
            Warning[] warnings  = null;

            streamBytes = rv.LocalReport.Render("PDF", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);

            return(File(streamBytes, mimeType, "Report1.pdf"));
        }
Пример #29
0
        private void ShowReport()
        {
            ExamUserComponent ec = new ExamUserComponent();
            int    ResDetId      = CurrentSession.CurrStudent.ExamResultDetail.ExmResultDetailId;
            int    StudId        = CurrentSession.CurrStudent.StudentId;
            string isDetailed    = "0";
            //if (chkIsDetailed.Checked)
            //isDetailed = "2";
            bool   isModExam = CurrentSession.CurrStudent.isModExam;
            string FileName  = hdnFileName.Value;

            DataSet dsComp     = ec.GetCompInfo();
            DataSet dsExamRes  = ec.GetExamResultPrint(ResDetId, StudId, 1, false);
            DataSet dsExResSum = ec.GetExamResultPrint(ResDetId, StudId, 2, false);

            Microsoft.Reporting.WebForms.ReportViewer rview = new Microsoft.Reporting.WebForms.ReportViewer();
            rview.ProcessingMode         = ProcessingMode.Local;
            rview.LocalReport.ReportPath = Server.MapPath("~/eReports/Rdlc/rpt_examResult.rdlc");

            rview.LocalReport.DataSources.Clear();
            rview.LocalReport.DataSources.Add(new ReportDataSource("dsCompInfo", dsComp.Tables[0]));
            rview.LocalReport.DataSources.Add(new ReportDataSource("dsResPrint", dsExamRes.Tables[0]));
            rview.LocalReport.DataSources.Add(new ReportDataSource("dsExamSum", dsExResSum.Tables[0]));
            rview.LocalReport.Refresh();

            string mimeType, encoding, extension, deviceInfo;

            string[] streamids;
            Microsoft.Reporting.WebForms.Warning[] warnings;

            //Desired format goes here (PDF, Excel, or Image)
            deviceInfo = "<DeviceInfo>" + "<SimplePageHeaders>True</SimplePageHeaders>" + "</DeviceInfo>";
            byte[] bytes = rview.LocalReport.Render("PDF", deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);

            System.Web.HttpContext.Current.Response.Clear();
            System.Web.HttpContext.Current.Response.ContentType = mimeType;

            System.Web.HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=Result.PDF");
            System.Web.HttpContext.Current.Response.BinaryWrite(bytes);
            System.Web.HttpContext.Current.Response.End();
        }
Пример #30
0
        // GET: RPTContrato
        public ActionResult ImpressaoContrato()
        {
            var ds = Reports.Data.DsImpressaoContrato.ObterRelatorio();


            var viewer = new Microsoft.Reporting.WebForms.ReportViewer();

            //viewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
            viewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\Rpt\Rpt_ImpressaoContrato.rdlc";
            viewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("dsDetalhe1", (System.Data.DataTable)ds.PR_IMPRESSAO_CONTRATO));



            viewer.SizeToReportContent = true;
            viewer.Width  = System.Web.UI.WebControls.Unit.Percentage(100);
            viewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);


            ViewBag.ReportViewer = viewer;
            return(View());
        }
Пример #31
0
        public static byte[] GeneratePdf(string report, string server, IList <WebReporting.ReportParameter> parameters)
        {
            string mimeType;
            string encoding;

            string[] streamids;
            WebReporting.Warning[] warnings;
            var extension = "pdf";

            WebReporting.ReportViewer rpv = new WebReporting.ReportViewer();

            rpv.ProcessingMode               = WebReporting.ProcessingMode.Remote;
            rpv.ServerReport.ReportPath      = report;
            rpv.ServerReport.ReportServerUrl = new Uri(server);

            rpv.ServerReport.SetParameters((IEnumerable <WebReporting.ReportParameter>)parameters);

            byte[] bytes = rpv.ServerReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);

            return(bytes);
        }
Пример #32
0
        public ActionResult ReportingRatesCopy(string productCategory, string sdate, string edate)
        {
            ReportsModel obj = new ReportsModel();

            if (productCategory == "")
            {
                productCategory = null;
            }

            obj.productCategory = productCategory;

            DateTime?StartDate; //= DateTime.ParseExact(sdate, "dd/MM/yyyy", null);
            DateTime?EndDate;   //= DateTime.ParseExact(edate, "dd/MM/yyyy", null);

            if ((!sdate.Contains("null") && sdate != "") || (!edate.Contains("null") && edate != ""))
            {
                StartDate = DateTime.ParseExact(sdate, "dd/MM/yyyy", null);
                EndDate   = DateTime.ParseExact(edate, "dd/MM/yyyy", null);
            }
            else
            {
                StartDate = null; // Convert.ToDateTime(DBNull.Value);
                EndDate   = null; // Convert.ToDateTime(DBNull.Value);
            }
            obj.StartDate = StartDate;
            obj.EndDate   = EndDate;

            Microsoft.Reporting.WebForms.ReportViewer reportViewer = new Microsoft.Reporting.WebForms.ReportViewer();
            reportViewer.ProcessingMode      = ProcessingMode.Local;
            reportViewer.SizeToReportContent = true;

            reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\LMIS_Reports\Reporting_Rates.rdlc";
            reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("ReportingRates", obj.GetReportingRatesCopy().ToList()));

            ViewBag.ReportViewer = reportViewer;

            return(View());
        }
 public string DownloadBalanceSheet(DateTime dtStart, DateTime dtEnd)
 {
     using (AprosysAccountingEntities db = new AprosysAccountingEntities())
     {
         try
         {
             BO_BalanceSheet        RetainedEarning = GetRetainedEarning(dtStart, dtEnd, db);
             List <BO_BalanceSheet> exp             = GetBalanceSheetByDate(dtStart, dtEnd);
             //var exp = db.GetBalanceSheetByDate(dtStart, dtEnd).ToList();
             if (RetainedEarning != null)
             {
                 exp.Add(RetainedEarning);
             }
             Microsoft.Reporting.WebForms.ReportViewer rv = new Microsoft.Reporting.WebForms.ReportViewer();
             rv.LocalReport.ReportPath = "Reports/Definitions/BalanceSheet.rdlc";
             ReportDataSource  rd         = new ReportDataSource();
             string            rptName    = db.ReportConfigs.First(x => x.active == true && x.repoConfigID == 12).title;
             ReportParameter[] parameters = new ReportParameter[6];
             parameters[0] = new ReportParameter("TitleParam", rptName != "" ? rptName : "MOMAND ENTERPRISES");
             parameters[1] = new ReportParameter("StartDate", dtStart.ToString("yyyy-MM-dd"));
             parameters[2] = new ReportParameter("EndDate", dtEnd.ToString("yyyy-MM-dd"));
             parameters[3] = new ReportParameter("TotalAssetsAmount", exp.Where(x => x.HeadAccount == 1).Sum(x => (x.DEBIT - x.Credit)).ToString());
             parameters[4] = new ReportParameter("TotalLiabilities", exp.Where(x => x.HeadAccount == 2).Sum(x => (x.Credit - x.DEBIT)).ToString());
             parameters[5] = new ReportParameter("TotalEquity", exp.Where(x => x.HeadAccount == 3).Sum(x => (x.Credit - x.DEBIT)).ToString());
             rd.Value      = exp;
             rd.Name       = "DataSet1";
             rv.LocalReport.SetParameters(parameters);
             rv.LocalReport.DataSources.Add(rd);
             byte[] bt = rv.LocalReport.Render("PDF");
             return(WriteBytesToTempFile(bt, ".pdf"));
         }
         catch (Exception ex)
         {
             //Logger.Write("DownloadAuthReportByDate", ex.Message, ex.StackTrace, Logger.LogType.ErrorLog);
             throw;
         }
     }
 }
Пример #34
0
        private void LoadReportSourceData(string value)
        {
            try
            {
                DataSet CompanyList = new DataSet();
                Microsoft.Reporting.WebForms.ReportViewer rview = new Microsoft.Reporting.WebForms.ReportViewer();
                switch (value)
                {
                    case "Voucher":
                        {
                            String orgKey = "1";//(String)Session["OrgKey"];
                            String voucherNo = (String)Session["VoucherNo"];
                            if (orgKey.IsNotNullOrEmpty())
                            {
                                ReportManager manager = new ReportManager();
                                CompanyList = manager.GetCompany(orgKey);
                                ReportDataSources = manager.GetVoucherDataSources(voucherNo);
                            }
                            rview.LocalReport.ReportPath = Report.ReportPath;
                            ReportDataSource companyDatasource = new ReportDataSource("Company", CompanyList.Tables["spGetCompany"]);
                            ReportDataSource masterDatasource = new ReportDataSource("Voucher", ReportDataSources.Tables["spPreviewVoucher"]); rpViewer.LocalReport.DataSources.Add(companyDatasource);
                            rview.LocalReport.DataSources.Add(companyDatasource);
                            rview.LocalReport.DataSources.Add(masterDatasource);
                            SetReportParameters(value, rview);
                            OpenReportInPDF(rview);
                            //rview.LocalReport.Refresh();

                            break;
                        }//Transaction
                    case "PO":
                        {
                            String poID = (String)Session["POID"];

                            ReportManager manager = new ReportManager();
                            ReportDataSources = manager.GetPODataSources(poID);
                            rview.LocalReport.ReportPath = Report.ReportPath;
                            ReportDataSource masterDatasource = new ReportDataSource("PurchaseOrder", ReportDataSources.Tables["sprptPurchaseOrder"]);
                            rview.LocalReport.DataSources.Add(masterDatasource);
                            SetReportParameters(value, rview);
                            OpenReportInPDF(rview);
                            //rview.LocalReport.Refresh();

                            break;
                        }
                    case "Transaction":
                        {
                            String StockTransID = (String)Session["StockTransID"];

                            ReportManager manager = new ReportManager();
                            ReportDataSources = manager.GetAllTransactionDataSources(StockTransID);
                            rview.LocalReport.ReportPath = Report.ReportPath;
                            ReportDataSource masterDatasource = new ReportDataSource("DataSet1", ReportDataSources.Tables["sprptStorckTransactionAll"]);
                            rview.LocalReport.DataSources.Add(masterDatasource);
                            SetReportParameters(value, rview);
                            OpenReportInPDF(rview);
                            //rview.LocalReport.Refresh();

                            break;
                        }
                    case "Requisition":
                        {
                            String RequisitionID = (String)Session["RequisitionID"];

                            ReportManager manager = new ReportManager();
                            ReportDataSources = manager.GetAllRequisitionDataSources(RequisitionID);
                            rview.LocalReport.ReportPath = Report.ReportPath;
                            ReportDataSource masterDatasource = new ReportDataSource("Requisition", ReportDataSources.Tables["sprptRequisitionAll"]);
                            rview.LocalReport.DataSources.Add(masterDatasource);
                            SetReportParameters(value, rview);
                            OpenReportInPDF(rview);
                            //rview.LocalReport.Refresh();

                            break;
                        }
                }
            }
            catch (Exception ex)
            {
                //Message.ShowErrorMessage("Error: <br>" + ex.Message + "<br>Call Stack: <br>" + ex.StackTrace);
            }
        }