The Report Template Builder eliminates the need to request customized report generation from another tool vendor, or to manually conduct data manipulation. Data objects need only to be dragged-and-dropped from the Specific Metrics tab to generate a final report.

For all of TEMS Discovery's supported metrics, prescriptives may be defined and the results presented in a chart with all Microsoft Office Excel supported types. With a single operation, it is possible to generate the final report from TEMS Discovery report templates.

 

The Report Template Builder has the following components:

 

 

The report template can be in any of the following Excel files types:

 

Cross-referencing among different sheets is supported in each format, but VBA macros are supported only as follows:

 

A TEMS Discovery report template is actually a Microsoft Office Excel file with TEMS Discovery formatted information. TEMS Discovery can read and write Excel files and replace TEMS Discovery formatted information with the final values.

To define a report template, you can:

More information about defining a report template:

All TEMS Discovery supported metrics and user-defined events and metrics are listed in the Metric List tree view. You can drag-and-drop any of the metrics (except for Layer 3 message information elements) into the Report Editor.

When you drop an item into the Report Editor, the Report Options dialog will pop up.

 

Once an information element is dropped into the Report Editor, the dialog shown below will pop up. You can select the desired report type and descriptive, and even apply a threshold or range to the data of target metric. Once you have selected the settings, a well-formatted string and additional information will be placed in the target cell.

 

 

 

If you choose to report data in Chart, you can also define plot bands by providing the start value, end value, and step value.

 

You can define a threshold or a range to filter data points, so that only the data points satisfying the threshold/range are computed for what is described. You can select a logical operator and a corresponding operand (numerical value or text) to form a logical expression. Up to two logical expressions are supported and these two logical expressions will be joined. The settings in this section apply to the selected metric itself.

Under the metric list, there are some special metric groups like WCDMA PSC Scanning - UARFCN #=? and WCDMA PSC Scanning - UARFCN =?. If you drag-and-drop a metric under the group name ended with "#=?" to the Report Template Builder, you can then specify an index so that only data in the specified index will be reported. Also, if you drag-and-drop a metric under the group name ended with "=?" to the Report Template Builder, you can specific a key so that only the data of the specified key (e.g., UARFCN) will be reported.

 

You can also select one or multiple condition filters. Only the data points at the times or locations meeting the criteria defined in the condition filters will be included for reporting. To define a condition filter, see Report Template Builder.

You can choose to embed the condition filter definition into the template so that the report template will be self-contained and can be exported for sharing without exporting the associated condition definition.

 

You can choose to enable or disable UDR data filtering for the data you select. If the Enable UDR Filtering option is selected, by enabling the Consider data only in cluster region index # checkbox and selecting an index, you can create a report template containing flags for a cluster region index. Before generating a report for a specific set of data, you can then associate a set of specific UDRs with the region index. See Generate Report From Report Template for detail. To be more flexible, you can even choose to filter the data based on the attributes of each polygon.

 

You can attach certain attributes to mobile data (see Device Attribute Assignment) so that mobile data can be identified by its attributes. For example, consider that you have data from two operators, Blue and Green. You can import this data into the same dataset, and set attributes to Blue and Green, respectively. In the report template, you can define the report with data of the Blue attribute, Green attribute, or both.

Check the checkbox in front of each attribute to include that attribute in the definition.

When generating the final report, the attributes will be used to identify what data is to be considered for reporting. See Generate Report From Report Template.

You can also check the Enable delta between different device attributes option to generate the delta between the data of two different attribute sets. A plot band must be defined so that the delta can be presented in a chart.

 

Time Series Chart option allows users to define measurement per time charts. Defining Time Series Chart is similar to defining a regular chart without the need to select Descriptives and related options (fixed selection of measurement values over time is used). Time Series Chart option allows adding multiple series/measurements to a single chart by drag-and-dropping additional measurements to existing report element. All of the standard Report Builder filtering options supported.

Time Chart Options tab allows users to change Y-axis assignment (applicable to report elements having multiple series/measurements assigned), customize series symbol and line color, chart background coloring and legend background coloring and font color and type.

Resize option is available from right click context menu to change previously defined chart element dimensions. Remove Correlation/Time Series Chart option is available too from right click context menu to remove selected chart element from Report Builder design area.

Defining Trend chart is similar to defining a regular chart, except that you can select periodicity — Hourly, Daily, Weekly, and Monthly — for the trend report.

 

As an example, you can drag-and-drop the IE cdma2000 > CDMA Top Pilot Scanning > Peak Ec/Io >Top 1 from the Metric List into the Report Editor, and select Chart > Linear Average from the pop-up menu. When moving the mouse, an area will be dynamically highlighted in light grey. This area defines the chart location and size. After you move the mouse to the bottom-right corner of the desired chart area, left-click and the definition will be generated in the Report Editor. Some of the definitions are automatically filled in, but you can manually edit some of the fields to adjust the display of chart to your preference.

The first column in the highlighted area is the title of the definition, and the series definitions start from the second column. Each column represents one series of the chart.

The following information is used to define a series:

 

The report template shown above will result in a final report similar the one shown below. The H and I columns of the spreadsheet are generated by TEMS Discovery and are used by Microsoft Office Excel to generate the chart. Do not delete or hide this data.

 

For example, if you want to create a chart to visualize the linear average of the Peak Ec/Io of each serving sector, this metric can be correlated with Common > Cell ID - cdma2000 > Sector ID > Sort By: Signal Strength > Top 1. Drag-and-drop that metric from the Metric List into the Correlation cell, as shown below.

 

The final report will be similar to the following:

 

For the example shown above, you can even elect to sort the Peak Ec/Io in Ascending or Descending order so that the chart can be better visualized. If you further define a # of Bands (for example, 5), only the stronger or weaker 5 serving sectors will be shown in the chart.

Of course, you can elect to correlate with any other metrics, and, by combining those charting options, you can produce a rich report just by dragging-and-dropping data.

 

You can define more than one series in a single chart by dragging-and-dropping another IE into the column immediately after the previous series. Other than defining the chart area (the highlighted area in light grey), all operations are the same as for defining the first series.

For example, refer to the following report template, which defines three series. For Chart Layout #, Plot By, Chart Title, and Correlation, only the first series requires definition. The other series will apply the same settings.

The report template shown above will result in a final report similar to the one shown here:

 

The chart type for different series can be set to different types. This way, one series can be plotted as the xlColumn type and the other can be plotted as the xlLine type. However, the mixed chart type can only be defined to a 2D chart type. If you define a mixed 3D chart type, or one to the 2D type and another to the 3-D type, all the series will be plotted to the chart type of the first series.

In some circumstances, you may want to manually define a list of X-values and Y-values one by one. Each value could be computed by a Microsoft Office Excel formula, constant value, or cross-referred value; or computed by TEMS Discovery through a Single Value report type. TEMS Discovery provides a way to define a chart skeleton and, when generating the final report, TEMS Discovery will create the chart based on the definition.

To define a chart skeleton, right-click the Report Editor and select Chart Skeleton from the context menu. As when a chart is defined, an area will be dynamically highlighted in light grey while moving the mouse. At the right-bottom corner of the desired chart area, left-click, and the following definition will be generated in the Report Editor.

 

For this skeleton, you need to at least manually define the starting cell label of X values and Y values, along with the # of Bands. Cross referencing is allowed, but the format of the reference should be as such: 'Sheet Name'!M24. Be sure to place an exclamation mark (!) after the sheet name. The following is an example of a well-defined chart skeleton.

 

The report template shown above will result in a final report similar to the one shown here:

 

Multi-dimension Statistic Data report type allows user to run numerous statistical calculations for selected metrics and drill down per device attributes, date and time, UDRs or even other metrics added as dimension. For each of selected measurements, user may select one of more statistical operations such as Average, Count, k-thPercentile, Minimum, Maximum, StdDev, StdDevp, Sum, Var and Varp.

 

 

You may choose to describe a metric in a tabular format. Drag-and-drop a metric and select Statistic Data in the Report Options. The definition that will be generated is shown below.

 

 

Cell B2 (the cell that the metric is dropped into) defines the metric information, Cell B3 defines what to compute, and, by default, Cell B4 defines where the starting cell is to place the range. If you don't want the range to be listed, clear the cell. You can list other metrics side-by-side by defining another Statistic Data report in the C column; however, all of the metrics must have the same plot band definition.

Following is the final report generated:

 

Simply generating statistic data per its own plot band is not enough. More desirable information is the correlation between two metrics. In Figure 1, you can drag-and-drop another metric to Cell B5 and define it as the correlation metric. For example, you can drag-and-drop Common > Cell ID - cdma2000 > Sector ID > Sort By: Signal Strength > Top 1 into Cell B5, as shown below.

 

Be aware that if you define other metrics side-by-side, all of these metrics must have the same correlation defined. In this example, Cell C5 must be the same as Cell B5. The final report generated from the above example is shown below:

The above example lists the linear average of Ec/Io and Io of each sector’s coverage. To correlate with Cell ID - <technology> under the Common tree node, scanner data and its corresponding cell configuration must all be imported to the same project.

 

You may use the Tabular report type to create a tabular list of multiple metrics. You need to reserve at least three columns to the left for Time, Latitude, and Longitude.

 

 

You may include one or more correlation charts in your report template.

 

One or more of the following options can be included in a correlation chart:

 

Following is the sample output expected for a final report:

To create a report like this, do the following:

 

The final template may look something like this. The content above the chart space is automatically filled by TEMS Discovery and will not appear in the final report output. Experienced users may further edit the contents of those cells to alter the final output.

 

Map View report type can be used to generate maps in measurement report. Following previously described method you may drag-and-drop selected metric into the Report Editor, select Map View report type, specify various map and filtering options and then define map element size as in case of Chart report type. User may include more than one measurement into single map view report element by dragging-and-dropping additional IEs into map area created off of the first IE. All of the Map View options are based on selections made with the first information element except for Data point icon size (pixel), Hide data points, Draw data label with font and Custom Metric/Event Name text box option all located in Option #2 tab.

Map View options included on ‘Option #1’ tab:

• ‘Include cell sites with icon size(pixel)’ check box includes one or multiple cell configurations with specified cell site size.

• ‘Draw cell site icon on top of dataset route’ check box if selected will draw cell sites on top of dataset route, otherwise cell sites will occupy layer below measurements.

• ‘Use specific (non-default) cell configuration selection’ option, if turned on, will allow user to select non-default cell configuration by one of the following selection methods:

o ‘All’ sub-option will include all cell configurations defined in the selected project

o ‘Mapping index’ sub-option will select cell configuration with a given index (defined under Project Properties - Cell Configuration)

o ‘Dataset name matching’ sub-option will attempt to select cell configuration with the name matching the one of the selected dataset

• ‘Include GIS with map source’ option will include map backdrop as specified in the drop down list including [Local Default GIS] as configured in Project Properties - GIS Settings, or one of the online map options.

• ‘Draw GIS in grayscale’ check box if selected will render map backdrop in grayscale.

• ‘Always draw data in indoor mode’ option will use indoor mode representation for projects including indoor data regardless if geo-rectified.

• ‘Draw Legend on’ option will include legend in the map by choosing one of the following selections:

o ‘Left’ will place legend on the left side of specified report element area. ‘Legend inside map’ check box determines if legend is separated from map area.

o ‘Right’ will place legend on the left side of specified report element area. ‘Legend inside map’ check box determines if legend is separated from map area.

o ‘Independent columns’ will place legend information outside and to the right of specified report element area in the form of independent Excel columns with legend information matching report element area height.

o ‘Independent Image’ will place legend image outside and to the right of specified report element area with its height matching the one of report element area and width adjusted in size to include all legend information.

o ‘Sort ranges by relative percentage’ option will sort legend plotband ranges in descending order of data samples.

• ‘Render metrics with offset (pixels)’ check box if selected will add offset between measurements if more than one is added to the map with specified pixel size and relative angle.

• ‘Remove Map view area if no data’, if selected, will cease to generate map output if no measurement data samples are available.

• ‘Unique ID for MS Word Template’ option may be used to define Map View report element reference to be used for generating reporting output in MS Word or Power Point file format.

 

 

Map View options included on ‘Option #2’ tab:

• ‘Draw all data with no UDR filtering’ check box if selected will disable UDR filtering that may have been specified under ‘Additional Options’ tab.

• ‘Overwrite default print area with boundary of’ set of options allows user to overwrite default print area set in Project Properties - UDR Configuration for a given Map View reporting element, with option to use Cluster UDR, Polygonregion or Drive route (i.e. measurement data points) for print area selection.

• ‘Data point icon size (pixel)’ list box allows user to specify data point size in pixels.

• ‘Hide data points’ check box allows user to omit data points from the output. This option is typically used when one metric data points are labelled with another metric. In case when data points are hidden with ‘Draw data label with font’ check box unselected, respective measurement will be omitted from map legend.

• ‘Map resolution multiplier’ list box allows user to multiply original map resolution 2 or 3 times.

• ‘Map display scale’ combo box allows user to set specific map display scale from the range of values from 40m to 2km. Default ‘Auto’ map scale will be set to include all measurement data points.

• ‘Display scale value’ check box if selected will display map scale in the bottom left corner of map element.

• ‘Draw data label with font’ check box if selected will include data labels with specified font type and size.

• ‘Grid backdrop with raster (m):’ option will add grid backdrop to Map View reporting element output with specified raster. Grid backdrop is placed in the layer below all measurements and above online map or GIS layer with color and weight of grid lines being fully configurable. Grid raster is indicated at the bottom right corner of Map View reporting output.

• ‘Custom Metric/Event Name’ text box will add custom metric/event name to map element legend (providing ‘Draw Legend on’ option is selected). ‘Remove Generic Metric/Event Name’ check box if selected will remove generic metric/event name, i.e. generic name will be replaced by custom one.

 

Map View options included on ‘Option #3’ tab:

• ‘Serving Sites Bounding Rectangle’ check box, if selected, will adjust map print area (zoom level) to include serving sites along with measurement data points. Resulting zoom level will still be limited by available discrete zoom levels if online map backdrop is used (e.g. GoogleMap, BingMap). Metric added last to ‘Map View’ report element (the key metric) will be used to determine RAT and measurement device type (UE or scanner) of sector matching proxy metric. Carrier 1/Serving Beam 1 and Top #1 measurements will be used in sector matching for UE and scanner key metric respectively with option applicable exclusively to key metrics defined with GSM, WCDMA, LTE or NR radio technology. New option will not be applicable for GSM scanner key metric as sector matching is not supported in that case. ‘Size Change (%)’ number will allow users to increase effective resulting bounding rectangle size (by specified relative percentage point) for additional buffer around serving sites. ‘Sector matching fallback to BCCH’ global system parameter will be applicable to GSM sector matching (serving site determination).

• ‘Data Route Bounding Rectangle’ check box, if selected, will define inclusion map zoom rectangle to include all data points that can be further fine-tuned by the relative percentage specified under ‘Size Change (%)’ list box. Zero size change will maintain auto zoom, positive values will reduce zoom (zoom out) while negative will increase zoom (zoon in). Size change is uniformly applied in all directions.

• 'Site bounding cut off rectangle' check box, if selected, will define exclusion map zoom rectangle to cut off any area outside 'Site bounding cut off rectangle’ while lays inside 'Data Route Bounding Rectangle'. Similarly, 'Site bounding cut off rectangle' may be fine-tuned by its own ‘Size Change (%)’ list box.

• Note that in case when online map (e.g. GoogleMap, BingMap) is used zooming rectangle adjustment is tied to online map fixed zoom levels and may be relatively coarse.

 

Map View options included on ‘Option #4’ tab:

• ‘Automated sector coloring’ check box will enable use of automated sector coloring options in reporting output.

• User may decide between standard [1] ‘Sector Id coloring’, [2] ‘Fixed sector coloring’ and [3] ‘SSV Sector Id coloring’ options.

• [1] ‘Sector Id coloring’

• [2] ‘SSV Sector Id coloring’

o Special type of Sector id coloring allowing user to make custom SSV sector color selection and apply it to Sector id metric (data point) coloring.

o SSV sectors are either identified automatically or by populating Cell_Number cell configuration parameter:

• [3] ‘Fixed sector coloring‘

o ‘Fixed sector coloring‘ option may be used to apply custom sector color for up to 6 logical sectors in all RAT layers. Sector color is defined by selecting corresponding sector button, S1 to S6. ‘Other’ color selection may be used as a wildcard for exceptional sites (e.g. out of cluster sites).

o ‘Fixed sector coloring‘ option requires that cell configuration sector naming adhere to the naming convention below:

o ‘Serving/Measured sectors only’ sub-option may be selected to limit sector coloring to serving (applicable to UE measurements only) or measured (Top Nth) sectors identified in selected dataset.

o ‘Smart Coloring’ sub-option may be used to prevent color collisions in automated sector coloring by dynamically assigning limited set of colors (i.e. “smart colors”) to highest ranked serving/measured sectors in lieu of using fixed plotband color assignment. “Smart colors” matching user-defined SSV sector colors not used for non-SSV sector coloring.

• ‘Render solid pie’ check box is applicable to all automated sector coloring options except when ‘Serving/Measured sectors only’ sub-option is enabled in which case serving/measured sectors are always rendered solid and non-serving/non-measured in outline.

• ‘Serving/Measured network layer labels only’ option allows users to restrict label display to serving/measured network sub-layers. Label displaying restrictions are applied on top of existing RAT labeling controls specified under ‘Overwrite cell configuration view settings’ configuration area.

Map View options included on ‘Option #5’ tab:

o ‘Pie Border Color’ and ‘Pie Border Weight’ options allow customization of selected cell configuration sector border color and line weight. The settings are irrelevant if ASC ‘Render solid pie’ or project level 'Render solid pie’ settings are enabled will the latter applicable if ASC is disabled. Pie border color customization is irrelevant too if ‘Fixed sector coloring’ or ‘SSV Sector Id coloring’ ASC options are enabled. Pie border color and weight customization will only be applied to non-serving/non-measured network layers if standard ASC is enabled (‘Serving/Measured sectors only’ sub-option disabled). Pie border color and weight customization will only be applied to non-serving/non-measured sectors if ‘Serving/Measured sectors only’ ASC sub-option is enabled.

o Use of ‘Smart Labeling’ option is determined via respective check box; Turning off the option will display labels regardless of their overlapping.

o Font button may be used to customize label font, style and size applicable to all RAT layers.

o ‘Site Label Position (%)’ list box may be used to modify site label relative position; Default label position is set at the bottom right with respect to site symbol center at the distance required to avoid overlap with carrier labels (0%); User may bring site label closer or farther using position adjustment in -100% (site symbol center) to 100%
(2x original label distance) range.

o Pie radius/width and site, carrier or sector Id labeling with custom coloring is available per RAT.

o RAT layer ordering is based on sector radii (smaller placed on top of larger sectors) and cell configuration name (alphabetical) if same sector radius size is defined.

o Report element cell configuration viewing settings are applied regardless of if single or multiple cell configurations are selected.

 

 

New Image report element may be added to report template by using Add Image option of Report Template Builder Right-Click Menu.

 

User will need to specify image file name reference used in locating image file during report generation. Selection of ‘Lock Aspect Ratio’ check box will maintain original image aspect ratio, otherwise image will be resized to fit into user-specified report element dimensions. Manual or ADP report generation process will attempt to locate image file with specified image name reference within a subset of image repository associated with current:

• dataset, if selected data scope is limited to a single dataset,

• project, if selected data scope includes multiple datasets.

First matching name image will be returned if one is found, blank/empty output will be generated otherwise.

 

In cases where you need to generate a report with repetitive information (e.g., for each cluster UDR), you can define the report type and descriptive in a block of cells in the report template as usual, and then provide repetition options in the first cell immediately under the definition block. TEMS Discovery can then automatically repeat the report generation of the definition block for each available cluster UDR in the data source.

To access the following dialog, right-click at the first cell immediately under the definition block on which you intend to repeat, and select Repetition in Report from the context menu.

 

 

A report can be generated from a report template in the following ways:

 

 

From Project List

 

 

Before the report can be generated from the template, the following Report Generation dialog will open:

 

 

After all options have been selected, select a report template and click Generate Report. The final report can also be saved to a file.

If an Excel template has a paied Word template, in another word, has the Word template with the same file name, an indicator “*Paired Word template exists” will be display in the header of the tree view after Excel template selected.

The final report generated will be in the same Excel format as the report template. If you select a report template with the extension xls, the final report will have an extension of xls, and the same to extension xlsx. In addition, if the paired Word template exists, a final Word report will be generated in the same target folder.

 

Microsoft Excel supports many kinds of charts to help you display data in ways that are meaningful to your audience. You can easily select the type you want from a list of standard or custom chart types.

Following is an overview of some standard chart types and their subtypes. For more detailed information, please refer to Microsoft's online resources.

A column chart shows data changes over a period of time or illustrates comparisons among items. Column charts have the following chart sub-types:

A bar chart illustrates comparisons among individual items. Bar charts have the following chart sub-types:

A line chart shows trends in data at equal intervals. Line charts have the following chart sub-types:

A pie chart shows the size of items that make up a data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.), proportional to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element in the data. Pie charts have the following chart sub-types:

An xy (scatter) chart shows the relationships among the numeric values in several data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.), or plots two groups of numbers as one series of xy coordinates. Scatter charts are commonly used for scientific data and have the following chart sub-types:

 

An area chart emphasizes the magnitude of change over time. Area charts have the following chart sub-types:

 

Like a pie chart, a doughnut chart shows the relationship of parts to a whole; however, it can contain more than one data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.). Doughnut charts have the following chart sub-types:

 

A radar chart compares the aggregate values of a number of data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.). Radar charts have the following chart sub-types:

 

A bubble chart is a type of xy (scatter) chart. It compares sets of three values and can be displayed with a 3-D visual effect. The size of the bubble, or data marker (data marker: A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a chart constitute a data series.) indicates the value of a third variable. To arrange your data for a bubble chart, place the x values in one row or column, and enter corresponding y values and bubble sizes in the adjacent rows or columns. For example, you would organize your data as shown in the following picture.

 

The following bubble chart shows that Company A has the most products and the greatest market share, but not the highest sales.

 

This chart type is most often used for stock price data, but can also be used for scientific data (for example, to indicate temperature changes). You must organize your data in the correct order to create stock charts. Stock charts have the following chart sub-types:

 

These chart types use cylinder, cone, or pyramid data markers to lend a dramatic effect to column, bar, and 3-D column charts. Much like column and bar charts, cylinder, cone, and pyramid charts have the following chart sub-types:

 

Report Template Builder Repository (RTBR) option allows users to directly generate report element definition from populated system views with a mouse click and add them later to user-defined report template. RTBR option is applicable to standard Map, Histogram, Time-series Chart, Table and Correlation system views, translating to Map, Chart, Time Series Chart, Tabular and Correlation Chart report type elements respectively. Users may select individual (multiple at a time) sub-views for export to RTBR.

 

Report element definition created this way is added to Report Template Builder ‘Repository’ tab including user selected metric/event definition and applicable system view settings. New RTBR item is created for each converted sub-view named by system view type followed by date and time tag, with user-selected information element names listed. Users may delete individual repository items or clean up the entire repository at once. Refresh button is available for updating repository listing after adding new report element items to it.

 

 

 

Repository items can be dragged-and-dropped into report editor area for their addition to user-defined report template. Repository items will include all pre-selected information elements in its definition. Repository items will include applicable system view settings (e.g. Map View cell configuration selection, map source selection, indoor mode status, etc., or Time Series Chart line symbol and color settings, chart background and legend settings, etc.). Users may modify applicable report type settings and enable relevant filtering before element is saved into report template.

Correlation sub-view selected for export needs to have both X and Y axis metrics populated. Map system view exported to report repository will include cell configuration selection only if:

• Default cell configuration is added to Map sub-view,

• Non-default cell configuration with defined index is added to Map sub-view, in which case, ‘Use specific (non-default) cell configuration selection’ check box will be selected with ‘Mapping index’ radio button and corresponding index value.

• Multiple cell configurations are added to Map sub-view, in which case, ‘Use specific (non-default) cell configuration selection’ check box will be selected with ‘All’ radio button.