Databases Reference
In-Depth Information
To see an example of how extended properties can be used in your reports
you will now enhance the report in the previous section by using the extended
property FORMAT_STRING that is returned by Analysis Services for the
measure Total Profit. Switch to the Layout mode in Report Designer and se-
lect the cell showing the Total Profit in the report. Select the property Format
for this cell and set its value as an expression. In the Expression dialog enter
the value =Fields!Total_Profit!FORMAT_STRING. Save the report and switch
to the preview mode. You will see a report where the profit values are format-
ted based on the format string that is retrieved from Analysis Services as
shown in
Figure 17-32
. Using the extended properties you will be able to re-
trieve and use the member properties for dimension members and cell prop-
erties for cells that are not part of the predefined reporting services proper-
ties.
Figure 17-32
Custom Aggregates
When you create reports that contain groups, then most likely you have sub-
totals for the group members. For example, if you have sales for various
years and products then you might want to view the sales for each year which
needs to be aggregated. Reporting Services provides you a set of aggrega-
Search WWH ::
Custom Search