Extract Month Information

Reporting Design Cookbook Data Design
1

This recipe demonstrates how to extract month information from a composite datasource.

Steps taken:

  1. Create a composite datasource (RPTT7003 (Composite).ds). Drag and drop the tabular datasource (RPT7003.ds) as the beginning of the flow.
  2. Add a “Derivative” element following the tabular datasource. On the “Derivative > Derived” tab, add the following column:Name=numASATDATE, Data Type=Integer, Value=parseInt(ASATDATE.getMonth())+1

Upon rendering, the report will display the month value in the last column.

To download the necessary files for this recipe, refer to the attached ZIP package.
ExtractMonthInformation.zip