Asp.Net, VB, SQL Server Reporting Services..dynamically generated reports from directory to be viewed on report viewer on click? -
i have aspx webform in it's vb code reads files .rdl directory , lists them button or hyper link etc. "reports on local host report server"
protected sub page_load(sender object, e eventargs) handles me.load dim filelocation directoryinfo = _ new directoryinfo("c:\inetpub\wwwroot\reports") dim fi fileinfo() = filelocation.getfiles("*.rdl") each name fileinfo in fi ' dim integer dim listed new linkbutton ' listed.attributes("cssclass") = "a" ' listed.attributes("class") = "a" listed.attributes("id") = "listed" listed.text = (name.name) mine.controls.add(listed) 'mine.innerhtml = "" 'i = + 1 next end sub
and has reportviewer. when report clicked, how can send name/value viewer , redirect it?
thank much
edit: got make click redirect viewer string , have viewer use string,but how ever variation ive tried still errors
the path of item 'salesreport.rdl' not valid. full path must less 260 characters long; other restrictions apply. if report server in native mode, path must start slash. (rsinvaliditempath)
this viewer code
protected sub page_load(byval sender object, byval e system.eventargs) handles me.load if not page.ispostback ' retrieve parameter route "reports/{reportname}" dim reportname = picks.selecty 'page.title = reportname reportviewer1.processingmode = processingmode.remote dim serverreport serverreport serverreport = reportviewer1.serverreport serverreport.reportserverurl = new uri("http://localhost/reportserver/") serverreport.reportpath = reportname ' reportname ' ' add parameters here 'dim param new reportparameter("name", "value") 'serverreport.setparameters(param) serverreport.refresh() end if end sub
you try following.
- create new page reportviewer.aspx hosts reportviewer control recieves name of .rdl file query string.
- in first .aspx page, every link display, point navigateurl property reportviewer.aspx page , pass name of .rdl file querystring.
hope helps
thanks, prawin
Comments
Post a Comment