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
Post a Comment