Report with Embedded Graphs

Version Info

Minimum Origin Version Required: Origin 8 SR0

Examples

The following example shows how to embed graphs into report tables.

void Datasheet_SetReportTree_Ex3(string strGraphName = "Graph1")
{
        GraphPage gp(strGraphName);
        if(!gp)
        {
                printf("No graph named %s in project\n", strGraphName);
                return;
        }
        
        int nID = 100; // Each node must have node ID and node ID must be unique   
        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, "Report with Embedded Graph"); //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. Put graph page inside report table
        tr.Report.Table1.ID = nID++;   
        tr.Report.Table1.strVal = gp.GetUID(true);
        tr.Report.Table1.SetAttribute(TREE_Control, ONODETYPE_EMBED_GRAPH);            

        // 3. Prepare worksheet window to report
        WorksheetPage wksPage;
        wksPage.Create("origin", CREATE_EMPTY);   
        wksPage.SetShow();       
        
        DWORD   dwOptions = WP_SHEET_HIERARCHY | CREATE_NO_DEFAULT_TEMPLATE;          
        string  strSheetName = "Report Sheet";
        int nn = wksPage.AddLayer(strSheetName, dwOptions);
        if( nn < 0 )        
                return;            
        
        // 4. Do report
        Worksheet wksOut = wksPage.Layers(nn);
        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;
        }             
        wksPage.Rename("ReportSample");
        wksOut.AutoSize();               
}