C#

string LocalPath = "";

           if (DownloadReport(reportViewer1.ServerReport.ReportPath, out LocalPath))
           {
               string newPath = "";
               if (LoopThroughDatasetsXML(LocalPath, out newPath))
               {
                   CreateReports(cbMOE.Text + "_New", newPath, reportViewer1.ServerReport.ReportPath);
               }
           }

private bool DownloadReport(string reportPath, out string LocalFolder)
        {
            bool ret = true;
            ReportingService2010.ReportingService2010 rs = new ReportingService2010.ReportingService2010();
            rs.Url = "http://" + m_dbSettings.serverName + "/" + m_dbSettings.reportDbName + "/ReportService2010.asmx";
            rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
                    
            byte[] reportDefinition = null;
            XmlDocument doc = new XmlDocument();

            try
            {
                reportDefinition = rs.GetItemDefinition(reportPath); // Get the report from the server
                MemoryStream stream = new MemoryStream(reportDefinition);

                //start building the path to save the report to the users computer
                reportPath = reportPath.Replace(@"/", @"\");
                
                LocalFolder = Directory.GetCurrentDirectory();                

                LocalFolder = LocalFolder + @"\TrialData\DataAccess\Reports" + reportPath + ".rdl";
                string Folder = Path.GetDirectoryName(LocalFolder);

                //if the folder doesn't exist, create it
                if (!Directory.Exists(Folder))
                {
                    Directory.CreateDirectory(Folder);
                }

                doc.Load(stream);//convert the document to an xml file
                doc.Save(LocalFolder);//save the document
            }
            catch (Exception ex)
            {
                ret = false;
                MessageBox.Show("Problem saving reports. " + ex.Message);
                throw ex;
            }
            return ret;
        }

        /*
         * DRW 9/20/16
         * Loop through datasets in downloaded rdl and replace stored procedure with _New stored procedure
         * Build List<SP> of dataset names and original stored procedure names
         * Save rdl as original name with _New at the end
         */
        private bool LoopThroughDatasetsXML(string reportPath, out string NewFilename)
        {
            bool ret = true;
            NewFilename = "";
            List<SP> sp = new List<SP>();
            XDocument doc = XDocument.Load(reportPath);
            XNamespace ns = doc.Root.Name.Namespace;

            try
            {
                foreach (XElement xe in doc.Descendants(ns + "DataSet"))
                {
                    SP p = new SP();
                    string commandtext = xe.Element(ns + "Query").Element(ns + "CommandText").Value;
                    xe.Element(ns + "Query").Element(ns + "CommandText").Value = commandtext + "_New";
                    XAttribute a = xe.Attribute("Name");
                    p.SPName = commandtext;
                    p.DatasetName = a.Value;
                    sp.Add(p);
                }
            }
            catch (Exception ex)
            {
                ret = false;
                MessageBox.Show("Problem looping through rdl and updating to _New Stored Procedures.\n\n" + ex.Message);

            }
            if (ret)
            {
                try
                {
                    if (sp.Count > 0)
                    {
                        //set new filename
                        NewFilename = reportPath.Substring(0, reportPath.Length - 4) + "_New.rdl";
                        doc.Save(NewFilename);//save the document
                    }
                }
                catch (Exception ex)
                {
                   ret = false;
                MessageBox.Show("Problem saving modified rdl.\n\n" + ex.Message);                   
                }
            }
            return ret;            
        }

        /*
         * Upload a report from the users computer to the report server.
         * definitionpath is the full path to the report file on the users computer.
         * parentFolder is the parent folder of the report on the report server. The folder that the report will be uploaded to. 
         */
        private void CreateReports(string reportName, string definitionPath, string parentFolder)
        {
            ReportingService2010.ReportingService2010 rsc = new ReportingService2010.ReportingService2010();
            rsc.Credentials = System.Net.CredentialCache.DefaultCredentials;

            rsc.Url = "http://" + m_dbSettings.serverName + "/" + m_dbSettings.reportDbName + "/ReportService2010.asmx";
            Byte[] definition = null;
            ReportingService2010.Warning[] warnings = null;

            try
            { //read the report from the hard drive
                FileStream stream = File.OpenRead(definitionPath);
                definition = new Byte[stream.Length];
                stream.Read(definition, 0, (int)stream.Length);
                stream.Close();
            }

            catch (IOException e)
            {
                MessageBox.Show(e.Message);
            }

            try
            { //upload the report to the server - True means overwrite existing report on the server  
                /*
                 * DRW 1-26-2016 Remove .rdl from filename before uploading to server
                 */
                parentFolder = parentFolder.Replace(cbMOE.Text, "");//strip report name from server report path
                parentFolder = parentFolder.Substring(0, parentFolder.Length - 1); // strip off trailing slash
                reportName = reportName.Replace(".rdl", ""); //strip .rdl from filename
                rsc.CreateCatalogItem("Report", reportName, parentFolder, true, definition, null, out warnings);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Problem uploading report. " + ex.Message);
            }
        }

Member 11166318 wrote:

in asp.net

foreach( DataTable table in _ds.Tables ) {
   this.comboBox1.Items.Add( table.TableName );
}