Ad-hoc Report

The Ad-hoc Report group has these options:


Button	Description
Convert to Formula Report	Convert an Ad-hoc report to a formula report, using a conversion formula selected from the adjacent Conversion formula list.
Recalculate Report	Recalculate the report.
Transpose Report	Exchange the rows of a report with its columns.
Slice-dimensions	Open the Select Slice-dimensions dialog.
Suppression	Select Suppress Zero and Empty Rows, Suppress Zero and Empty Columns, Suppress Empty Rows or Suppress Empty Columns. You can specify default suppression options for Ad-hoc reports in the Options dialog. See Options.
Presentation	For Microsoft Analysis Services data sources only, select one of these ways to present the values: Result: Returns the absolute values of a report. Percent of Rows: Displays the values as a percent of the row sum. Percent of Columns: Returns the values as a percent of the column sum. Percent of Table: Returns the values as a percent of the sum of all table values. Index of Expected Values: Returns the cell values according to a statistically expected value. This value E(x,y) is the product of the row sum (x) and the column sum (y), divided by the total sum of the table.
Chart Settings	Select one of these chart options: Table: Shows only the data. Chart and Table: Displays a chart above the data. Table and Chart: Displays a chart underneath the data. Change Chart Type: Enabled if the Ad-hoc report contains a chart. You can also right-click a chart to access this option.
Conditional Formatting	Microsoft Excel's conditional formatting options enable you to format data in a variety of ways, according to a variety of predefined rules. For example, you can use different colors and gradients to highlight groups or ranges of values, or assign a variety of icons to data values. You can edit the predefined rules, or create your own.