Thursday, November 27, 2014

ASP.NET MVC razor SAP Crystal report

Crete a new project:

Add a aspx Master Page

Create a new folder Reports and 2 sub folder crystal & crystalviewer

Now add a web form page in crystalviewer  folder.
Add the master page namespace in your web form page.


Replace your web form by this code

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

Now go to design mode of your web form drag & drop the crystal report viewer in your web form.

After that your page will be look look like this.

Replace the code:

<CR:CrystalReportViewer ID="EmployeeList" runat="server"  HasCrystalLogo="False"
    AutoDataBind="True"  Height="50px"  EnableParameterPrompt="false" EnableDatabaseLogonPrompt="false" ToolPanelWidth="200px"
    Width="350px" ToolPanelView="None" />

I am also add a preview button if you need you can add more control as you need.
 Now add a crystal report 

Right click the field expert field then select the database (I will use store procedure)

Select your store procedure.

 Design your report based on your store procedure.
Add the namespace in your web form cs file
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

replace the code in your button event
public string thisConnectionString = ConfigurationManager.ConnectionStrings["ConnectionStringOther"].ConnectionString;
        CrystalDecisions.CrystalReports.Engine.ReportDocument reportDocument = null;

        protected void Page_Load(object sender, EventArgs e)
            if (Page.IsPostBack)
        protected void Preview_Click(object sender, EventArgs e)
        private void LoadReport()
            if (this.reportDocument != null)
            SqlConnectionStringBuilder SConn = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["ConnectionStringOther"].ConnectionString);
            SqlConnection thisConnection = new SqlConnection(thisConnectionString);
            // store procedure
            SqlCommand mySelectCommand = new System.Data.SqlClient.SqlCommand("PIS_GetAllEmployeeInfo", thisConnection);
            mySelectCommand.CommandType = CommandType.StoredProcedure;
            reportDocument = new ReportDocument();
            //Report path
            string reportPath = Server.MapPath("~/Report/Crystal/EmployeeListCrystalReport.rpt");
            // Report connection
            ConnectionInfo connInfo = new ConnectionInfo();
            connInfo.ServerName = SConn.DataSource;
            connInfo.DatabaseName = SConn.InitialCatalog;
            connInfo.UserID = SConn.UserID;
            connInfo.Password = SConn.Password;
            TableLogOnInfo tableLogOnInfo = new TableLogOnInfo();
            tableLogOnInfo.ConnectionInfo = connInfo;
            foreach (CrystalDecisions.CrystalReports.Engine.Table table in reportDocument.Database.Tables)
                table.LogOnInfo.ConnectionInfo.ServerName = connInfo.ServerName;
                table.LogOnInfo.ConnectionInfo.DatabaseName = connInfo.DatabaseName;
                table.LogOnInfo.ConnectionInfo.UserID = connInfo.UserID;
                table.LogOnInfo.ConnectionInfo.Password = connInfo.Password;
                table.Location = "dbo." + table.Location;
           // You can pass parameter in your store procedure if you need
            //reportDocument.SetParameterValue("@FromDate", ProjectUtilities.ConvertToDate(txtFromDate.Text));
            //reportDocument.SetParameterValue("@ToDate", ProjectUtilities.ConvertToDate(txtToDate.Text));

            EmployeeListCrystalReport.ReportSource = reportDocument;

Add the connection string in you web config file.

Add a new class name ReportViewerViewModel in your model folder

public class ReportViewerViewModel
        public string ReportPath { get; set; }

Add a report controller & define action
public class ReportController : Controller
        // GET: /Report/

        public ActionResult EmployeeListReport()
            ReportViewerViewModel model = new ReportViewerViewModel();
            string content = Url.Content("~/Report/ReportViewer/EmployeeListReport.aspx");
            model.ReportPath = content;
            return View("ReportViewer", model);


Add a Reportviewer  viewer & replace the code

    ViewBag.Title = "ReportViewer";
    Layout = "~/Views/Shared/_Layout.cshtml";

@model MvcApplicationCrystalReport.Models.ReportViewerViewModel
<iframe src="@Model.ReportPath"  style="width:100%; height:1000px; border:none;"></iframe>

Now run the solution set debugger in report controller

click report

Your report will not view, you need to add a folder aspnet_client in which there will be crystalreportviewers13 folder of your crystal report set up.

 Now preview you will see your report.

You can download the code sample

Tuesday, November 18, 2014

Posting JSON data via jQuery to ASP .NET MVC 4 controller action not working

The grid data if I want to save data in json call then if the json data cross the limit of JsonDeserializer then it will not work on controller action. 

  function SaveMenuPrivilege() {  
     var postUrl;  
     var paramValue;  
     var gridData = $("#MenuPrivilegeKendoGrid").data("kendoGrid");  
     // set model data   
     for (var i = 0; i < gridData.length; i++) {  
       gridData[i].NewRoleId = $("#RoleId").val();  
     postUrl = '@Url.Content("~/Admin/MenuPrivilege/SaveMenuPrivilege")';  
     paramValue = JSON.stringify({ MenuPrivilegeList: gridData }); // you can also set model data using','   
       url: postUrl,  
       type: 'POST',  
       dataType: 'json',  
       data: paramValue,  
       contentType: 'application/json; charset=utf-8',  
       success: function (result) {  
       error: function (objAjaxRequest, strError) {  
         var respText = objAjaxRequest.responseText;  

   public ActionResult SaveMenuPrivilege(MenuViewModel menuViewModel)  

 To resolve this problem you just need to add in your web config appsetting

  <add key="aspnet:MaxJsonDeserializerMembers" value="50000000" />

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link.