c# - Modifying SSRS directly in the Database does not reflect in ReportViewer -


i working on web based ssrs editor. have succeeded in developing parser access ssrs schema catalog table database , converts html.

from here user can modify report , submit change, again parser receives html , converts desire results.

but when visiting report in reportviewer, still showing old report.

and when downloading report report manage url showing changes have made application.

i doubt whether microsoft storing rdl in physical format.

please help..

finally got solution. before directly updating content column in catalog table, , though changes updated in db, not reflecting on actual live report.

after searching found this. how deploy report through code , done.

class sample { static void main(string[] args) {     reportingservice2010 rs = new reportingservice2010();     rs.url = "http://<server name>" +         "/_vti_bin/reportserver/reportservice2010.asmx";     rs.credentials =          system.net.credentialcache.defaultcredentials;      byte[] definition = null;     warning[] warnings = null;     string name = "myreport.rdl";      try     {         filestream stream = file.openread("myreport.rdl");         definition = new byte[stream.length];         stream.read(definition, 0, (int)stream.length);         stream.close();     }     catch (ioexception e)     {         console.writeline(e.message);     }      try     {         string parent = "http://<server name>/docs/documents/";         catalogitem report = rs.createcatalogitem("report", name, parent,                     false, definition, null, out warnings);          if (warnings != null)         {             foreach (warning warning in warnings)             {                 console.writeline(warning.message);             }         }          else             console.writeline("report: {0} created " +                               " no warnings", name);     }     catch (soapexception e)     {         console.writeline(e.detail.innerxml.tostring());     } } } 

Comments

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

java - How to filter a backspace keyboard input -

java - Show Soft Keyboard when EditText Appears -