How to make access of crystal report used by Admin

Hi Team

I have some examples of how to use crytsal reports in asp.net as either word or excel. I want an examples where these reports be used by Admin as either excel or word not by any person logged. Please share any samples or examples that can used to my mvc app.

Hi Gcobani Mkontwana,

Yes, Excel can be set from Render methos like:

byte[] bytes = reportViewer.LocalReport.Render("EXCEL", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);

For your reference, I have uploaded code.

Hope, this will help you!

----------------------------------------------------------------------

Hi Gcobani Mkontwana,

Here, there are 2 questions:

How to use crytsal reports in asp.net as either word or excel?
Reports can be used by Admin as either excel or word not by any person logged?

So, let me answer both questions one by one:

1.How to use crytsal reports in asp.net as either word or excel?

Recently, I had written an article about "How to print rdlc report directly to printer in MVC". Which will help you regarding above first question.

For more detail: https://www.c-sharpcorner.com/article/print-rdlc-report-directly-to-printer-in-mvc/

2.Reports can be used by Admin as either excel or word not by any person logged?

For this, you have to first set session variable like UserRole in controller method like (HomeController.cs):

public ActionResult Index()
{
Session["UserRole"] = "Admin";
return View();
}

And after that you have to use that session variable to show or hide button to generate a report as like (home/index.cshtml):

@{
if (HttpContext.Current.Session["UserRole"] != null && HttpContext.Current.Session["UserRole"].ToString() == "Admin")
{
<button onclick="funExportToPDF()">Export to PDFbutton>
}
}

Hope, this will help you!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankajkumar Patel6y ago
Accepted answer
Hi Gcobani Mkontwana,
Yes, Excel can be set from Render methos like:
byte[] bytes = reportViewer.LocalReport.Render("EXCEL", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);
For your reference, I have uploaded code.

Hope, this will help you!
----------------------------------------------------------------------

Hi Gcobani Mkontwana,

Here, there are 2 questions:
How to use crytsal reports in asp.net as either word or excel?
Reports can be used by Admin as either excel or word not by any person logged?
So, let me answer both questions one by one:

1.How to use crytsal reports in asp.net as either word or excel?

Recently, I had written an article about "How to print rdlc report directly to printer in MVC". Which will help you regarding above first question.

For more detail: https://www.c-sharpcorner.com/article/print-rdlc-report-directly-to-printer-in-mvc/

2.Reports can be used by Admin as either excel or word not by any person logged?

For this, you have to first set session variable like UserRole in controller method like (HomeController.cs):
public ActionResult Index()
{
    Session["UserRole"] = "Admin";
    return View();
}
And after that you have to use that session variable to show or hide button to generate a report as like (home/index.cshtml):
@{
    if (HttpContext.Current.Session["UserRole"] != null && HttpContext.Current.Session["UserRole"].ToString() == "Admin")
    {
        <button onclick="funExportToPDF()">Export to PDFbutton>
    }
}
Hope, this will help you!
+1
Guest User6y ago
Hi Patel

Thanks mate if got issue, will ping
0
Guest User6y ago
Pankaj

Its great article and admire that kind of work, tell me something important. The extension used pdf, can i used the same withe excel? please advice mate, thanks.
0