Skip to main content

How to show CrystalReport as and Download it in MVC

As there is no way till now to show crystal report in a view(MVC). You can simply convert the report document as pdf using following code:

 public void ShowReport()
        {
            List<ToDos> lstTodos = new List<ToDos>();
            lstTodos = db.ToDos.ToList();
            ReportDocument rd = new ReportDocument();
            rd.Load(Path.Combine(Server.MapPath("CrystalReport1.rpt")));
            rd.SetDataSource(lstTodos);
            Stream stream;
            stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

            byte[] binarydata;
            binarydata = new Byte[stream.Length];
            stream.Read(binarydata, 0, (int)stream.Length);

            string base64String = "";
            try
            {
                base64String =
                  System.Convert.ToBase64String(binarydata,
                                         0,
                                         binarydata.Length);
            }
            catch (System.ArgumentNullException)
            {
                System.Console.WriteLine("Binary data array is null.");

            }

            string pdfurl = "data:application/pdf;base64," + base64String;

            ViewBag.Url = pdfurl;

        }

And after converting it as PDF use HTML object tag to show pdf document as shown below(using ViewBag.Url):

@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<object data="@ViewBag.Url"
        type="application/pdf" style=" height: 991px;margin-left: -32%;margin-top: 5%;width: 98%;"></object>

Comments

Popular posts from this blog

FTP(File Transfer Protocol ) configuration and testing in Windows Server 2008 R2

First of all you have to know  what the FTP is " File Transfer Protocol ( FTP ) is a standard network protocol used to transfer files from one host or to another host over a TCP -based network". FTP Installation & Configuration: Step 1: Install the Web Server role with the IIS Management Console and FTP Server role services: Step 2: Add a new FTP Site Step 3: Setup the site with the default bindings and choose Allow SSL to avoid deploying a certificate:     Step 4: Configure user permissions and basic or anonymous permission. If your server is connected to your domain you can specify domain users, otherwise they must be local user accounts: Note: Finally you’ll have to configure your server’s firewall rules to allow access.Disregard any existing FTP firewall rules; although they should be enabled, they don’t actually allow access! Run Allow a Program Through Windows Firewall and grant access to C:\Windows\System32\svchost.exe T...

update your package-lock.json according to what you have specified in the package.json file

  The objective of the   npm update   command is to update your   package-lock.json   according to what you have specified in the   package.json   file. This is the normal behavior. If you want to update your package.json file, you can use  npm-check-updates :  npm install -g npm-check-updates . You can then use these commands: ncu  Checks for updates from the package.json file ncu -u  Update the package.json file npm update --save  Update your package-lock.json file from the package.json file