using System;
using System.Data;
using System.Data.OleDb;
using System.IO;
 
namespace FX.SalesLogix.Utility
{
    public class ReportExtractor
    {
        public ReportExtractor(string ConnectionString)
        {
            this.ConnectionString = ConnectionString;
        }
 
        public string ConnectionString { get; set; }
 
        public void GetReport(string PluginID, string DestinationFile)
        {
            using (OleDbConnection conn = new OleDbConnection(this.ConnectionString))
            {
                conn.Open();
                using (OleDbCommand cmd = new OleDbCommand("SELECT DATA FROM PLUGIN WHERE PLUGINID = ?", conn))
                {
                    cmd.Parameters.Add(new OleDbParameter("PLUGINID", PluginID));
 
                    // Get the plugin byte array
                    byte[] data = (byte[])cmd.ExecuteScalar();

                    // Look for the two consecutive null bytes
                    int idx = 0;
                    for (int i = 0; i < data.Length; i++)
                    {
                        if ((int)data[ i ] == 0 && (int)data[i + 1] == 0)
                        {
                            idx = i + 2;
                            break;
                        }
                    }
 
                    // Get everything after the two consecutive bytes
                    byte[] rpt = new byte[data.Length];
                    Array.Copy(data, idx, rpt, 0, data.Length - idx);
 
                    // Write out to an RPT file 
                    using (FileStream f = new FileStream(DestinationFile, FileMode.CreateNew))
                    {
                        f.Write(rpt, 0, rpt.Length);
                        f.Close();
                    }
                }
            }
        }
    }
}

// Extract report to C:MyReportFile.rpt
ReportExtractor rptextractor = new ReportExtractor(MyConnectionString);
rptextractor.GetReport("pDEMOA0000HQ", @"C:MyReportFile.rpt");