Toolbars

23 Oct 20194 minutes to read

There are three toolbars in the OLAP client to provide the number of options to perform the different operations.

OLAP client toolbar

This toolbar contains menus to invoke the particular operation of OLAP client.

Toolbar table

Icon Name Description Reference Link

Connection option Displays the Connection option dialog to connect to the server or offline cube. Connection option

New Report Create a new session to create a report. New Report

Load Report Load the reports from the saved XML file. Load Report

Save Report Save the current session as an XML file. Save Report

Save As Report Save a copy of the current session as an XML file. Save As Report

Add Report Add a new report to the current report set. Add Report

Remove Report Remove the selected report from the current report set. Remove Report

Rename Report Rename the selected report in the current report set. Rename Report

Report list Displays the reports in the current report set. Report list

Toggle Pivot Toggle the axis of the selected report. -

Show/Hide expanders Show/hide the expanders of the chart and grid control of the selected report. -

Column filter Displays the Filter dialog window to filter the column elements in the selected report. Column Filter

Row Filter Displays the Filer dialog window to filter the row elements in the selected report. Row Filter

Sorting Column Displays the Sorting dialog window to sort the column elements in the selected report. Sorting Column

Sorting Row Displays the Sorting dialog window to sort the row elements in the selected report. Sorting Row

OLAP chart toolbar

By using the menus in the OLAP chart toolbar, user can customize the appearance and style of the chart. User can also change the type of the chart.

The following is the list of options in the OLAP chart toolbar.

List of options in the_ _OLAP chart toolbar

Icon Name Description

Chart appearance Displays the chart appearance dialog window to change the chart appearance.

Show legend Show/hide the legend of the chart.

Chart Color Palette Displays the list of color palettes to change the current color of the chart.

Chart types Displays the list of chart types to change the current chart.

Export Chart Exports the current visual of the chart as image.

Print Prints the current visual of the chart.

Print mode Fixes the area of the chart to be printed.

Export to word Exports the current visual of the chart to Word.

Export to PDF Exports the current visual of the chart to PDF.

OLAP grid toolbar

By using the menus in the OLAP grid toolbar, users can customize the appearance and style of the grid.

The following are the options in the OLAP grid toolbar.

List of options in the_ _OLAP grid toolbar

Icon Name Description

Grid Style Displays the Grid Style dialog to change the current style of the grid.

Show header tooltip Show/hide the header cell tooltip.

Show value cell tooltip Show/hide the value cell tooltip.

Freeze headers Freeze the header cells of the grid.

Grid layout Lists different types of grid layout to change the current layout.

Export to Excel Export the grid to Excel.

Export to word Export the grid to Word.

Export to PDF Export the grid to PDF.

Show/hide toolbar options

It allows you to show/hide the OLAP client toolbar options in an application.

Properties

  • ShowConnectOptionButton: Gets or sets a value indicating whether to show/hide a connection option.
  • ShowNewReportButton: Gets or sets a value indicating whether to show/hide a new report option.
  • ShowAddReportButton: Gets or sets a value indicating whether to show/hide an add report option.
  • ShowLoadReportButton: Gets or sets a value indicating whether to show/hide a load report option.
  • ShowSaveReportButton: Gets or sets a value indicating whether to show/hide a save report option.
  • ShowSaveAsReportButton: Gets or sets a value indicating whether to show/hide a SaveAs report option.
  • ShowRemoveReportButton: Gets or sets a value indicating whether to show/hide a remove report option.
  • ShowRenameReportButton: Gets or sets a value indicating whether to show/hide a rename report option.
  • ShowToggleButton: Gets or sets a value indicating whether to show/hide a toggle report option.
  • ShowExpandersButton: Gets or sets a value indicating whether to show/hide an expanders option.
  • ShowFilterColumnButton: Gets or sets a value indicating whether to show/hide a filter column option.
  • ShowFilterRowButton: Gets or sets a value indicating whether to show/hide a filter row option.
  • ShowSortingColumnButton: Gets or sets a value indicating whether to show/hide a sorting column option.
  • ShowSortingRowButton: Gets or sets a value indicating whether to show/hide a sorting row option.
  • ShowReportList: Gets or sets a value indicating whether to show/hide a report list option.
  • ShowMdxButton: Gets or sets a value indicating whether to show/hide an MDX query dialog option.
  • IsVirtualKpiEnabled: Gets or sets a value indicating whether to show/hide a virtual KPI option.
  • IsCalculatedMembersEnabled: Gets or sets a value indicating whether to show/hide a calculated members option.

Adding or removing an OLAP client toolbar options in an application.

//Disable the Connection Option from current view of the OLAP Client Toolbar.



this.olapClient1.OlapClientToolBar.ShowConnectOptionButton = false;



// When set as true, then it shows from the toolbar.
'Disable the Connection Option from current view of the OLAP Client Toolbar.



 Me.olapClient1.OlapClientToolBar.ShowConnectOptionButton = False



'When set as True, then it shows from the toolbar.

{Installation Drive}:\Users<user name>\AppData\Local\Syncfusion\EssentialStudio<version number>\BI\WPF\OlapClient.Wpf\Samples\Appearance\OlapClientCustomizationDemo