3.9.6.1.1 Simple Report with One Table

Version Info

Minimum Origin Version Required: Origin 8 SR0

Examples

This is a simple sample to show how to report only one table.

// Run Datasheet_SetReportTree_Ex1 1, will transpose the rows and columns of table
void Datasheet_SetReportTree_Ex1(bool bTransposeTable = false)
{
	int nID = 100; // Each node must have node ID and node ID must be unique except the case described in [Note1] below
	int nTableFormat = GETNBRANCH_OPEN | GETNBRANCH_HIDE_COL_HEADINGS| GETNBRANCH_HIDE_ROW_HEADINGS | GETNBRANCH_FIT_COL_WIDTH | GETNBRANCH_FIT_ROW_HEIGHT;
	
	// 1. Create report tree
	Tree tr;
	tr.Report.ID = nID++;
	tr.Report.SetAttribute(STR_LABEL_ATTRIB, "Sample Report Tree"); //Table title
	// TREE_Table attribute is critical in getting the report to work so must be present in every table level. 
	// Can set this attribute as 0 without any format, but many bits GETNBRANCH_* defined in oc_const.h to set table display format.
	tr.Report.SetAttribute(TREE_Table, nTableFormat); 
	
	// 2. Create report table
	tr.Report.Table.ID = nID++;
	tr.Report.Table.SetAttribute(STR_LABEL_ATTRIB, "This is a simple table"); // Table title. If not set this, will show as empty here
	int nSubTableFormat = nTableFormat;
	if(bTransposeTable)
		nSubTableFormat |= GETNBRANCH_TRANSPOSE; // transpose this table
	tr.Report.Table.SetAttribute(TREE_Table, nSubTableFormat); 
	
    // 3 ~ 6 is to add rows and columns to this table. But row and column is not real row and column 
    // since we can transpose table, introduce row and column here in order to easy to understand 
    
	// 3. Add one row to this table
	tr.Report.Table.R1.ID = nID++;
	tr.Report.Table.R1.SetAttribute(STR_LABEL_ATTRIB, "Row 1"); //Row label
	
	// 4. Add two columns to this table
	int nColIDBase = 10000;
	tr.Report.Table.R1.C1.ID = nColIDBase + 1;
	tr.Report.Table.R1.C1.SetAttribute(STR_LABEL_ATTRIB, "Column 1"); // Column label
	tr.Report.Table.R1.C1.dVal = 5;
	
	tr.Report.Table.R1.C2.ID = nColIDBase + 2;
	tr.Report.Table.R1.C2.SetAttribute(STR_LABEL_ATTRIB, "Column 2"); // Column label
	tr.Report.Table.R1.C2.dVal = 10;	
	
	// 5. Add the second row to this table
	tr.Report.Table.R2.ID = nID++;
	tr.Report.Table.R2.SetAttribute(STR_LABEL_ATTRIB, "Row 2"); //Row label
	
	// 6. Fill in values for the two cells in the second row
	tr.Report.Table.R2.C1.ID = nColIDBase + 1; // [Note1] For the same column the differnet row, the node ID should keep same. For example, the ID of node tr.Report.Table.R2.C1 is same as the ID of tr.Report.Table.R1.C1.
	tr.Report.Table.R2.C1.dVal = 15;
	
	tr.Report.Table.R2.C2.ID = nColIDBase + 2;
	tr.Report.Table.R2.C2.dVal = 20;
	
	
	// 7. Prepare worksheet window to report
	WorksheetPage wksPage;
	wksPage.Create();	
	
	DWORD 	dwOptions = WP_SHEET_HIERARCHY | CREATE_NO_DEFAULT_TEMPLATE;		
	string	strSheetName = "Report Sheet";
	int nn = wksPage.AddLayer(strSheetName, dwOptions);
	if( nn < 0 )	
		return;	
	
	Worksheet wksOut = wksPage.Layers(nn);
	wksPage.Layers(0).Delete();	//delete the first default layer	
	
	// 8. Do report
	if( wksOut.SetReportTree(tr.Report) < 0 ) // Returns last row number on successful exit and -1 on failure.
	{
		printf("Fail to set report tree.\n");
		return;
	}		
	wksOut.AutoSize();		
}