c# - Report Viewer export to pdf getting error -

-

i getting error "cannot create data reader dataset 'dataset1'."

i expend lots of time solving issue unable resolved.same code working report generation @ time of pdf generation stuck.

here code please reply.

 protected void btnpdf_click(object sender, eventargs e)         {             string pdf = "pdf";             string reporttype = "reporttype";             warning[] warnings = null;             string[] streamids = null;             string mimetype = string.empty;             string encoding = string.empty;             string extension = string.empty;             string filetype = string.empty;              long _landids = 0;             if (_farmid > 0)             {                 land land = landmanager.getlandbyfarmid(_farmid);                 _landids = land.landid;             }               reportviewer_myreportid.sizetoreportcontent = true;             reportviewer_myreportid.localreport.reportpath = "reports/report/report.rdlc";             reportviewer_myreportid.processingmode = processingmode.remote;              objectdatasource_id.selectparameters.clear();             objectdatasource_id.selectparameters.add(querystringenum.companyid, currentcompanyid.tostring());             objectdatasource_id.selectparameters.add(querystringenum.landid, _landids.tostring());             var days = "-" + rdduration.selectedvalue;             objectdatasource_id.selectparameters.add(querystringenum.days, days.tostring());              reportviewer_myreportid.localreport.refresh();              byte[] bytes = reportviewer_myreportid.localreport.render("pdf", null,              out mimetype, out encoding, out extension, out streamids, out warnings);             filestream fs = new filestream(server.mappath("~/generatedfiles/" + reporttype + "." + "pdf"), filemode.openorcreate);              fs.write(bytes, 0, bytes.length);             fs.close();          }

it work you.make sure dataset name not different.

code reference.

protected void btnpdf_click(object sender, eventargs e)     {         reportviewer viwer = new reportviewer();         objectdatasource ob = new objectdatasource("dataset.yourtableadapter", "getdata");         dataset.yourtableadapter ds = new dataset.yourtableadapter();          string pdf = "pdf";         string reporttype = "reporttype";         warning[] warnings = null;         string[] streamids = null;         string mimetype = string.empty;         string encoding = string.empty;         string extension = string.empty;         string filetype = string.empty;          long _landids = 0;         if (_farmid > 0)         {             land land = landmanager.getlandbyfarmid(_farmid);             _landids = land.landid;         }          viwer.sizetoreportcontent = true;         viwer.localreport.reportpath = "reports/report/report.rdlc";         viwer.processingmode = processingmode.local;         ob.selectparameters.clear();         ob.selectparameters.add(querystringenum.companyid, currentcompanyid.tostring());         ob.selectparameters.add(querystringenum.landid, _landids.tostring());         var days = "-" + rdduration.selectedvalue;         ob.selectparameters.add(querystringenum.days, days.tostring());          reportdatasource rds = new reportdatasource("datasetname", (object) ds.getdata((long?)currentcompanyid.toint64(), (int?)days.toint(), (long?)_landids.toint64()));          viwer.localreport.datasources.add(rds);         viwer.localreport.refresh();          byte[] bytes = viwer.localreport.render("pdf", null,          out mimetype, out encoding, out extension, out streamids, out warnings);         filestream fs = new filestream(server.mappath("~/generatedfiles/" + reporttype + "." + "pdf"), filemode.openorcreate);          fs.write(bytes, 0, bytes.length);         fs.close();        }

Comments

Post a Comment

Popular posts from this blog

javascript - how to protect a flash video from refresh？ -

-
<!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>flash video refresh</title> </head> <body> <div id="playerzone"><embed height="496" width="580" flashvars="flvid=19742822&amp;createtime=2012-4-19 13:46:33" wmode="opaque" allowscriptaccess="always" allowfullscreen="true" quality="high" bgcolor="#000000" name="player" id="player" src="swf/mine.swf" type="application/x-shockwave-flash"></div> <a onclick="return test();" id="test">click me popup div,and hide scrollbar</a> </body> the code upon： for example,when click a#test button,popup div,it's no problem,but want hide scrollbar while div popup. i used $('html').css('overflow','hidden') in
Read more

android - Associate same looper with different threads -

-
Image
in application, want create multiple threads working on single queue. create queue know need call looper.prepare() . i want other threads create should associated looper created first thread, how can achieve this? use 1 of java thread safe queue class java.util.concurrent package instead of looper achieve goal. it's more common practice. share queue between threads , post task queue entry 1 thread can entry thread. blockingqueue can - in 1 thread call take() , block thread until thread put() entry queue. that's all. producer consumer pattern example blockingqueue or concurrentlinkedqueue about blockingqueue
Read more

visual studio 2010 - Connect to informix database windows form application -

-
i trying figure out how connect ibm informix database. have been doing research , have found threads 5 years ago examples not working. i have installed latest sdk ibm informix. i have included ibm.data.informix.dll references in project. i have included using ibm.data.informix; i adding button , on click testing conenction. debug error "sql0035n file "c:\users\adam\documents\visual studio 2010\projects\test\test\msg\en_us\db2nmp.xml" cannot opened." this file not exist , dont see anywhere in program files (x86)\ibm informix client sdk directory. my on click code is private void button1_click(object sender, eventargs e) { const string host = "192.168.obfuscated"; const string servicenum = "1525"; //port? const string server = "serverobfuscated"; const string database = "dbobfuscatedy"; const string user = "myusername"; const string password = &
Read more