public bool SaveData(AvrPivotSettings settings) { List <IAvrPivotGridField> fields = settings.Fields.Cast <IAvrPivotGridField>().ToList(); AvrPivotGridHelper.PrepareLayoutSearchFieldsBeforePost(fields, LayoutDataSet.LayoutSearchField, settings.QueryId, settings.LayoutId); var db = new WebLayoutDB(); db.SetQueryID(settings.QueryId); LayoutRow.idfsDefaultGroupDate = settings.DefaultGroupInterval; LayoutRow.blnShowColsTotals = settings.ShowColumnTotals; LayoutRow.blnShowRowsTotals = settings.ShowRowTotals; LayoutRow.blnShowColGrandTotals = settings.ShowColumnGrandTotals; LayoutRow.blnShowRowGrandTotals = settings.ShowRowGrandTotals; LayoutRow.blnShowForSingleTotals = settings.ShowTotalsForSingleValues; LayoutRow.blnShowMissedValuesInPivotGrid = settings.ShowMissedValues; LayoutRow.blnApplyPivotGridFilter = settings.ApplyFilter; LayoutRow.blnCompactPivotGrid = settings.CompactLayout; LayoutRow.blnFreezeRowHeaders = settings.FreezeRowHeaders; LayoutRow.blnUseArchivedData = settings.UseArchiveData; LayoutRow.strPivotGridSettings = settings.FilterCriteriaString; LayoutRow.blnShowDataInPivotGrid = settings.ShowDataInPivot; return(db.PostDetail(m_DataSet, (int)PostType.FinalPosting)); }