FieldResponse field = null;
                    string columnName = Consts.ReportFields.GetSysNameFieldByViewName(groupResponse.Parent.ViewName);
                    if (!string.IsNullOrEmpty(columnName))
                        field = _fieldResponseCachedProvider.GetFieldByColumnNameOrTag(columnName);

                    if (field != null && !string.IsNullOrEmpty(field.ColumnName))
                    {
                        leftJoinStrBuilder.Append($@") As {viewInfo.AliasName}
                        On {viewInfo.AliasName}.{reportQueryBuilderExtension.JoinColumnName} = {field.ViewName}.{field.ColumnName}");
                    }
                    else
                    {
                        leftJoinStrBuilder.Append($@") As {viewInfo.AliasName}
                        On {viewInfo.AliasName}.{reportQueryBuilderExtension.JoinColumnName} = {reportViewName}.{rootView.ColumnName}");
                    }