pivotGridControl1.DataSource = DLL.SQL.SELECT(string.Format("SELECT * FROM MIZANMALZEME WHERE (Cast(Tarih as smalldatetime) between '" + TE_bASLANGICTARIHI.DateTime.ToString("yyyy-MM-dd") + "' and '" + TE_BITISTARIHI.DateTime.ToString("yyyy-MM-dd") + "')   AND  Isyeri_No IN (" + ISYERI_NRLERI + ")"));
            pivotGridControl1.RetrieveFields();
            pivotGridControl1.RestoreLayoutFromRegistry(@"Software\RAPOR\FRM_FINANSAL_RAPOR_212+" + pivotGridControl1.Name);

            PIVOTBESTFIT();

      private void PIVOTBESTFIT()
        {
            try
            {
                pivotGridControl1.BestFit();
                int i = 0;
                foreach (PivotGridField item in pivotGridControl1.Fields)
                {
                    item.BestFit();
                }
            }
            catch { }
        }