AnalyticReporting.CreateNewTimeSheetAccordingToPlanner Method

public void CreateNewTimeSheetAccordingToPlanner( 
   IWorkbook Workbook, 
   string NameOfNewSheet, 
   List<string> FilteringFields, 
   string FieldToBreakdown, 
   string FieldForCurve = "", 
   bool ReadCurveFromPlannerDataSheet = True, 
   string FieldInWBSDataToCheckToTakeRowIntoAccount = "", 
   object ValueFieldInWBSDataMustHave = Nothing 
)

This language is not supported or no code example is available.

Parameters

Workbook

IWorkbook

A workbook which is the data source you want to add the sheet to.

NameOfNewSheet

string

The name of the new sheet. The function will add a leading NR_ when naming the sheet.

FilteringFields

List<string>

A list of strings containing the column IDs of the text fields you want to add in the rightmost columns of the sheet. Can be used by the reporting engine to filter rows. These fields must exist in the WBSData sheet of the data source. The list can be empty if you need no filtering.

FieldToBreakdown

string

The column ID of the field you want to breakdown according to the Gantt diagram. This field must exist in the WBSData sheet of the data source.

FieldForCurve

string

Optional. The mnemonic of the column where the distribution curve can be read. When omitted, LINEAR is used. This field can be in the NR_Planner data sheet or in the WBSData sheet.

ReadCurveFromPlannerDataSheet

bool

When true the curve is read from a column in the NR_Planner data sheet. When false, the curve is read from a column in the WBSData sheet.

FieldInWBSDataToCheckToTakeRowIntoAccount

string

Optional. If you want only some rows from the WBSData sheet, you can filter on a column. Only rows of this column having the value ValueFieldInWBSDataMustHave will be taken into account.

ValueFieldInWBSDataMustHave

object

Optional. If you use FieldInWBSDataToCheckToTakeRowIntoAccount, you must provide the value here. Only rows having this value will be created in the new sheet.

.NET Framework