asp.net - Crystal Reports and strongly typed datasets yields empty report -
i converting asp.net app vs 2003 vs 2005 starting point. app uses crystal reports , binds using ado.net typed dataset (xsd). had change of crystal code work newer version of crystal. now, when run page, report generates, none of fields fill in. have seen lots of people having same problem no real solutions out there. decided create fresh project same thing remove conversation vs 2003 2005 possible cause of problem. sample program has button runs query, fills dataset , assigns report. report displays headers only. code below. have no idea try next.
dataset1 ds = new dataset1(); sqlconnection conn = new sqlconnection(configurationmanager.connectionstrings["myconnectionstring"].connectionstring); sqldataadapter da = new sqldataadapter("select * mytable", conn); da.fill(ds); reportdocument rep = new reportdocument(); rep.load(server.mappath("crystalreport.rpt")); rep.setdatasource(ds); crystalreportviewer1.reportsource = rep; crystalreportviewer1.refreshreport();
i created dataset1.xsd based on same mytable table. no errors or indication wrong except fields in report don't populate.
it take debugging know sure why it's not working you. have looked @ resulting dataset in debugging session, , seen if fills correctly?
here's example of method work from.
sqlconnection cnn; string connectionstring = null; string sql = null; connectionstring = "data source=servername;initial catalog=databasename;user id=username;password=password;"; cnn = new sqlconnection(connectionstring); cnn.open(); sql = "select * mytable"; sqldataadapter dscmd = new sqldataadapter(sql, cnn); dataset1 ds = new dataset1(); dscmd.fill(ds, "mytable"); cnn.close(); crystalreport1 objrpt = new crystalreport1(); objrpt.setdatasource(ds.tables[1]); crystalreportviewer1.reportsource = objrpt; crystalreportviewer1.refresh();
Comments
Post a Comment