How to export rdlc report to PDF without using ReportViewer

Question

3.50/5 (2 votes)

See more:

I tried hard and search on google but I am unable to export rdls report to pdf/ excel direclty.An exception occured
Please help me.

I have created report from wizard.Report.rdlc
now i am using the code as

C#

byte[] bytes = null;
	string strDeviceInfo = "";
	string strMimeType = "";
	string strEncoding = "";
	string strExtension = "";
	string[] strStreams = null;
	Warning[] warnings = null;
	
    try
    {
        ReportDataSource rds = new ReportDataSource("f_MANPOWERREQUISITION");
        ReportViewer rptViewer1 = new ReportViewer();
        rptViewer1.ProcessingMode = ProcessingMode.Local;
        rptViewer1.LocalReport.ReportPath = Server.MapPath("Report.rdlc");
        bytes = rptViewer1.LocalReport.Render(strFormat, strDeviceInfo, out strMimeType, out  strEncoding, out strExtension, out strStreams, out warnings);
        Response.Buffer = true;
        Response.Clear();
        Response.ContentType = strMimeType;
        Response.AddHeader("content-disposition", "attachment; filename=" + strNomFichier + "." + strFormat);
        Response.BinaryWrite(bytes); // create the file
        Response.Flush();
    }// send it to the client to download
    catch (Exception ex)
    {
    }

Inner Exception:A data source instance has not been supplied for the data source \"DataSet2_f_MANPOWERREQUISITION\".

Posted 3-Nov-11 23:25pm

uspatel

Updated 4-Nov-11 0:37am

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aadhar Joshi · Answer 1 · 2012-09-03T19:56:00

This can help out..
Try once..
=======================================================

C#

private void CreatePDF(string fileName)
{
    // Variables
    Warning[] warnings;
    string[] streamIds;
    string mimeType = string.Empty;
    string encoding = string.Empty;
    string extension = string.Empty;


    // Setup the report viewer object and get the array of bytes
    ReportViewer viewer = new ReportViewer();
    viewer.ProcessingMode = ProcessingMode.Local;
    viewer.LocalReport.ReportPath = "YourReportHere.rdlc";


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


    // Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
    Response.Buffer = true;
    Response.Clear();
    Response.ContentType = mimeType;
    Response.AddHeader("content-disposition", "attachment; filename=" + fileName + "." + extension);
    Response.BinaryWrite(bytes); // create the file
    Response.Flush(); // send it to the client to download
}

sucram · Answer 2 · 2011-11-04T05:39:00

What is happening her is that you can not bind the table adapter to the report.

You need to bind a data table to the report.

Try something along the lines of the following:

C#

DataSet2TableAdapters.f_MANPOWERREQUISITIONTableAdapter  ta = new DataSet2TableAdapters.f_MANPOWERREQUISITIONTableAdapter  ();

DataSet2_f_MANPOWERREQUISITION.TheTableInYourDataSet  dt = new DataSet2_f_MANPOWERREQUISITION.TheTableInYourDataSet();

ta.Fill(dt);
 
ReportDataSource rds = new ReportDataSource("DataSet2_f_MANPOWERREQUISITION",dt);

If "DataSet2_f_MANPOWERREQUISITION" gives you an error open the RDLC in N++ or a similar Text Editor and search for "<dataset name=" nad replace " dataset2_f_manpowerrequisition=" with the DatSet name in your RDLC</xml>">

sucram · Answer 3 · 2011-11-04T00:58:00

Solution 1

The error that you receive explicitly tells you what is going wrong.

The name that you are using to create the reportDatasource does not match with the name in the DataSet definition in your rdlc.

I also do not see the actual data being asigned to the DataSource.

Try using

ReportDataSource rds = new ReportDataSource("DataSet2_f_MANPOWERREQUISITION","could be a data table or something with the data tha needs in the report");

Posted 4-Nov-11 0:58am

sucram

Comments

uspatel 4-Nov-11 7:18am

Thanks for reply.
A DataSet DataSet2 created when i create Report.rdlc.
when i tried to provide 2nd argument as
ReportDataSource rds = new ReportDataSource("DataSet2_f_MANPOWERREQUISITION",DataSet2TableAdapters.f_MANPOWERREQUISITIONTableAdapter)

It shows an error as

Error 1 'DataSet2TableAdapters.f_MANPOWERREQUISITIONTableAdapter' is a 'type', which is not valid in the given context C:\Documents and Settings\shubhamanand\My Documents\Visual Studio 2008\WebSites\WebSite10\Default.aspx.cs 40 112 C:\...\WebSite10\

Muhammad-Nauman-3 · Answer 4 · 2015-05-10T20:38:00

Solution 5

can you please tell me what header you used fro response
???

Posted 10-May-15 20:38pm

Muhammad-Nauman-3

Comments

Deepu S Nair 11-May-15 2:48am

Don't post your comment as soution.

How to export rdlc report to PDF without using ReportViewer

4 solutions

Solution 3

Solution 2

Solution 1

Solution 5

Add your solution here

Preview 0