i have sql server report server (ssrs) hosts bunch of reports. when click on provided url, can navigate report, drilling down path, , can run report passing required parameters. stored procedures used report hosted in database uses windows authentication.
however, when try call same report application, cannot see anything.
here code use. upon clicking on button, execute code:
var reportviewer = new reportviewer(); // set processing mode reportviewer.processingmode = processingmode.remote; // set report server , report path reportviewer.serverreport.reportserverurl = new uri("http://myssrsserver/reportserver"); reportviewer.serverreport.reportpath = "/reports/myreport"; // set credentials reportviewer.serverreport.reportservercredentials.impersonationuser = windowsidentity.getcurrent(); // create report parameters , set them in report var param1 = new reportparameter("first_param", "some string"); var param2 = new reportparameter("second_param", "some other string"); reportviewer.serverreport.setparameters(new reportparameter[] { param1, param2 }); using (var reportform = new reportform(reportviewer)) { reportform.showdialog(); } the reportform regular form has member of type reportviewer. in class constructor assign member:
public reportform(reportviewer reportviewer) { initializecomponent(); try { this.reportviewer = reportviewer; reportviewer.setdisplaymode(displaymode.printlayout); reportviewer.dock = dockstyle.fill; reportviewer.zoommode = zoommode.percent; reportviewer.zoompercent = 100; reportviewer.refreshreport(); } catch (exception exception) { messagebox.show(exception.message); } } as said, can see report being correctly executed server, not application. content of reportform empty, not exceptions being thrown.
any idea doing wrong?
tia, e
turns out constructing reportviewer object outside form report displayed , passing inside constructor of form in order assign inner reportviewer object not idea. don't know what's happening behind scene, perhaps bindings between reportviewr instance , gui control show report broken.
