数据调整一下:
AutoId dDate cTTourName cTravelName
1.000 2003-4-16 fgef 4444
2.000 2003-3-16 fge 4444
3.000 2003-4-16 fgef 4444
4.000 2003-3-16 fge 4444
cZName iUnit cTicketName iSum iPsn cTTicketName
rr 4.000 gfds 176.000 44.000 fdsa
rr 15.000 gfds 275.000 55.000 fdsa
rr 14.000 gfds 176.000 44.000 fdsa
rr 5.000 gfds 275.000 55.000 fdsa
AutoId dDate cTTourName cTravelName
1.000 2003-4-16 fgef 4444
2.000 2003-3-16 fge 4444
3.000 2003-4-16 fgef 4444
4.000 2003-3-16 fge 4444
cZName iUnit cTicketName iSum iPsn cTTicketName
rr 4.000 gfds 176.000 44.000 fdsa
rr 15.000 gfds 275.000 55.000 fdsa
rr 14.000 gfds 176.000 44.000 fdsa
rr 5.000 gfds 275.000 55.000 fdsa
源始数据:
AutoId dDate cTTourName cTravelName
1.000 2003-4-16 fgef 4444
2.000 2003-3-16 fge 4444
3.000 2003-4-16 fgef 4444
4.000 2003-3-16 fge 4444
cZName iUnit cTicketName iSum iPsn cTTicketName
rr 4.000 gds 176.000 44.000 fdsa
rr 5.000 gfds 275.000 155.000 fdsa
rr 4.000 gds 176.000 144.000 fdsa
rr 5.000 gfds 275.000 55.000 fdsa汇总后的数据:
AutoId dDate cTTourName cTravelName
1.000 2003-4-16 fgef 4444
3.000 2003-4-16 fgef 4444
NULL NULL NULL NULL --小计
2.000 2003-3-16 fge 4444
4.000 2003-3-16 fge 4444
NULL NULL NULL NULL --小计
NULL NULL NULL NULL --合计cZName iUnit cTicketName iSum iPsn cTTicketName
rr 4.000 gds 176.000 44.000 fdsa
rr 14.000 gds 176.000 44.000 fdsa
NULL NULL NULL 352.000 88.00 NULL --小计
rr 15.000 gfds 275.000 55.000 fdsa
rr 5.000 gfds 275.000 55.000 fdsa
NULL NULL NULL 550.000 110.00 NULL --小计
NULL NULL NULL 902.000 198.00 NULL --合计