Re: OWC11 - display other properties on the PivotTable

Hi Elena,

There are a couple of ways to access Item Properties in the OWC Pivot
Table

- As I mentioned, if you right-click on a Field (on rows or columns),
the Context Menu includes an option; "Show Properties in Report", which
is only enabled if that Field has any (custom) Properties.

- The Commands and Options... Menu can be used.

This is an excerpt from the OWC Pivot Table Help:
>>
About item properties

You can display additional information about items by displaying the
custom properties of a row or column field.

For example, if the database administrator has made available two custom
properties, Manager and Phone Number, for the Store field, you can
choose to display the property values for each item in the Store field,
either in the PivotTable list or as ScreenTips.

The following illustration shows how the Employees report will look with
the custom properties Education and Yearly Income displayed in the
report.

The users of a PivotTable list cannot create custom properties. However,
they can show or hide properties, and choose whether the properties are
displayed in the report or as ScreenTips.

The following illustration shows the Education property displayed in the
report and the Yearly Income property displayed in the ScreenTip.

The users of the PivotTable list can also format the property captions
and values, and specify the order in which the properties are displayed
in the report or ScreenTip.

Non-OLAP data sources do not support custom properties.
>>


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Product dimension with SKU and Product Name?
    ... Subject: Re: OWC11 - display other properties on the PivotTable ... There are a couple of ways to access Item Properties in the OWC Pivot ... custom properties of a row or column field. ... The following illustration shows how the Employees report will look with ...
    (microsoft.public.sqlserver.olap)
  • Re: Displaying Multiple photos on report
    ... Would like to print a report for an ID with all of the associated photos ... I use the MS help for displaying images and that is fine, ... Can't find an appropriate Event item to get this to display the correct ... associated with images in OLE Objects. ...
    (microsoft.public.access.reports)
  • Re: Dynamic Reporting based on Parameterized Crosstab Query
    ... The tek-tips solution does display the actual date on the report. ... on the first 3 rowwise fields of the crosstab query. ...
    (microsoft.public.access.reports)
  • Re: PLEASE HELP: Refresh columns displayed in a report from a quer
    ... I have basically put about 10 extra columns in the report, ... column display is driven by user selection on the form, BUT is there a way to ... are operating at run time, not design time, so CreateReport ... ' Create new text box control and size to fit data. ...
    (microsoft.public.access.reports)
  • solution for sections do not fit vertically on the page datareport error message
    ... In order to avoid the case where a data report viewing is constrained ... you will need to execute api commands ... knwoledge they change the printer to the screen display. ...
    (microsoft.public.vb.winapi)