Cross table (Siasun)

--Instructions from the Siasun

// Create cross-table

createcrosstable (table,cross,where,left,top,mid,leftas,topnullas,midas,sumas,topsep,leftsort,topsort:string);

1.07 Examples:

Createcrossdataset (' XSDD1 ', DataSet, ', ' Dwbh,ywy ', ' ywrq ', ' je,hsje ', ' Customer, salesman ', ' empty ', ' | amount, | tax-included amount ', ' je,hsje ', ' total | ', ', ‘‘);

Createcrossdataset (table:string; Cross:tdataset; where,left,top,mid,leftas,topnullas,midas,sumas,topsep,leftsort,topsort:string);//Create a cross-data set

Createsumdataset (Dataset,sumdataset:tdataset; groupfields,sumfields:string);//Create a summary data set

Crossondataset (Dataset,cross:tdataset; where,left,top,mid,leftas,topnullas,midas,sumas,topsep,leftsort,topsort:string);//Create a cross-dataset on the current dataset

Example: I put the open script

In

Begin

Crossondataset (Parentdataset,dataset, ' ', ' year; month; area; responsible for HR; general recruitment; Department; position; rank ', ' source ', ' notification number, number of preliminary interviews, number of second interviews, number of recruits, interview efficiency ', ', ', ' Number of Notifications |, number of candidates |, number of recruits |, interview efficiency | ', ', ', ', ' Source number ';

Crossondataset (Parentdataset,dataset, ' ', ' year; month; area; responsible for HR; general recruitment; Department; position; rank ', ' source ', ' notification number, number of preliminary interviews, number of second interviews, number of recruits, interview efficiency ', ', ', ' | Number of people to be notified, | Number of preliminary interviews, number of candidates, number of recruits, interview efficiency ', ' ', ' ', ' ' Source number ';

Totalondataset (Parentdataset,dataset, ' year; month; area; responsible for HR; general recruitment; Department; position; rank; source ', ' notification number, number of preliminary interviews, number of second interviews, number of recruits, interview efficiency ');

End.

Cross table (Siasun)