IAnalyticReporting.CreateNewTimeSheetAccordingToPlanner Method

Sub CreateNewTimeSheetAccordingToPlanner( _ 
   ByVal workbook As IWorkbook, _ 
   ByVal newSheetName As String, _ 
   ByVal filteringFields As List(Of String), _ 
   ByVal fieldToBreakdown As String, _ 
   Optional ByVal fieldForCurve As String = "", _ 
   Optional ByVal readCurveFromPlannerDataSheet As Boolean = True, _ 
   Optional ByVal fieldInWbsDataForFiltering As String = "", _ 
   Optional ByVal fieldInWbsDataRequiredValue As Object = Nothing _ 
)

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

void CreateNewTimeSheetAccordingToPlanner( 
   IWorkbook workbook, 
   string newSheetName, 
   List<string> filteringFields, 
   string fieldToBreakdown, 
   string fieldForCurve = "", 
   bool readCurveFromPlannerDataSheet = True, 
   string fieldInWbsDataForFiltering = "", 
   object fieldInWbsDataRequiredValue = Nothing 
)

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

Parameters

workbook

IWorkbook

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

newSheetName

string

The name of the new sheet. The method 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 mnemonic 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.

fieldInWbsDataForFiltering

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 of fieldInWbsDataRequiredValue will be taken into account.

fieldInWbsDataRequiredValue

object

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

.NET Framework