private bool addRpt(string rptFile, string rptPath, 
    string rptTitle, string dbType, string dbServer, 
    string dbName, string dbUser, string dbPW)
{
  bool result = true;
  Debug.WriteLine("addRpt");
  try
  {
    _errMsg = string.Empty;
    int folderID = getFolderIDFromPath(rptPath);

    if (folderID > -1)
    {
      InfoObjects infoObjects = 
        _infoStore.NewInfoObjectCollection();
      PluginManager pluginManager = 
        _infoStore.PluginManager;
      PluginInfo pluginInfo = pluginManager.GetPluginInfo
        ("CrystalEnterprise.Report");
      InfoObject infoObj = infoObjects.Add(pluginInfo);
      Report newRpt = (Report)infoObj;
      try
      {
        newRpt.Files.Add(rptFile);
        newRpt.Properties.Add("SI_PARENTID", folderID);
        newRpt.KeepSavedData = true;
        newRpt.NeedsLogon = false;
        newRpt.EnableThumbnail = false;
        newRpt.Title = rptTitle;

        for (int i = 1; i <= newRpt.ReportLogons.Count; 
             i++)
        {
          newRpt.ReportLogons.UseOriginalDataSource = 
            false;
          newRpt.ReportLogons.CustomServerName = 
            dbServer;
          newRpt.ReportLogons.CustomDatabaseName = 
            dbName;
          newRpt.ReportLogons.CustomUserName = dbUser;
          newRpt.ReportLogons.CustomPassword = dbPW;
          newRpt.ReportLogons.PromptOnDemandViewing = 
            false;
        }
           
        _infoStore.Commit(infoObjects);
        Debug.WriteLine(rptTitle + " Published");
      }
      finally
      {
        infoObjects.Dispose();
        pluginManager.Dispose();
        pluginInfo.Dispose();
        infoObj.Dispose();
        newRpt.Dispose();
      }
    }
  }
  catch (Exception ex)

  {
    Debug.WriteLine("Unable to Add Report.  Error=" + 
        ex.Message);
    result = false;
  }
  return result;
}

//Get the ID of the folder where we're going to publish the instance
private int getFolderIDFromPath(string folderPath)
{
  Debug.WriteLine("getFolderIDFromPath");
  int parentID = -1;
  try
  {
    string path = folderPath;
    int index = path.IndexOf('\\');
    if (index == 0)
    {
      path = path.Substring(1);  //strip off leading '\'
      index = path.IndexOf('\\');
    }
    string folderName;
    parentID = 0;
    while ((index > 0) && (parentID >= 0))
    {
      folderName = path.Substring(0, index).Trim();
      parentID = getIDFromName(folderName, parentID);
      path = path.Substring(index + 1);
      index = path.IndexOf('\\');
    }
    if (path != "")
    {
      parentID = getIDFromName(path.Trim(), parentID);
    }
  }
  catch (Exception ex)
  {
    Debug.WriteLine("Unable to get folder ID.  Error=" + 
      ex.Message);
  }
  return parentID;
}

//get an id based on the name of the object and the id of its parent.
private int getIDFromName(string objectName, int parentID)
{
  //we're not going to trap the error here - we'll propagate it up to the calling method
  int result = -1;
  //get the ID of the Object
  string query = "Select SI_ID"
    + " From CI_INFOOBJECTS "
    + " Where SI_NAME='" + objectName + "'"
    + "   and SI_PARENTID=" + parentID.ToString();

  using (InfoObjects infoObjects = _infoStore.Query(query))
  {
    if (infoObjects.Count > 0)
      result = infoObjects[1].ID;
  }
  return result;
}