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.

  1. create new page reportviewer.aspx hosts reportviewer control recieves name of .rdl file query string.
  2. in first .aspx page, every link display, point navigateurl property reportviewer.aspx page , pass name of .rdl file querystring.

hope helps

thanks, prawin


Comments