透视数据集的过滤**

tanglei932

我想在表格文档中显示透视数据集中每个月的最后一天的数据，
里面有年，月，日字段，是行字段，
TSqlDataSet(DataSetBroker1.dataSet).SQLFilter:=' year='''+jiansuo.Year+''' and month='''+jiansuo.Month+'''';
          TSqlDataSet(DataSetBroker1.dataSet).SQLFiltered:= true;
          TSqlDataSet(DataSetBroker1.dataSet).SQLFilter:=' year='''+jiansuo.Year+''' and month='''+jiansuo.Month+'''';
          TSqlDataSet(DataSetBroker1.dataSet).SQLFiltered:= true;          DataSetBroker1.dataSet.Open;
          DataSetBroker1.dataSet.Last;
          TSqlDataSet(DataSetBroker1.dataSet).SQLFilter:=' year='''+jiansuo.Year+''' and month='''+jiansuo.Month+''' and dates='''+DataSetBroker1.DataSet.FieldByName('dates').AsString+'''';
          TSqlDataSet(DataSetBroker1.dataSet).SQLFiltered:= true;

DataSetBroker1是透视数据集，提示'dates'字段未定义

zfang

http://bbs.justep.com/forum.php?mod=viewthread&tid=6653