posted 8/11/2010 by MarkGStacey - Views: [2861]
I posted the following connect item , please vote for it!
https://connect.microsoft.com/SQLServer/feedback/details/585399/dataset-report-part-calculated-fields
When creating a dataset, a new calculated field can be created using an expression, especially useful for such techniques as dynamic measure selection, or dynamic graining of charts (i.e. letting the user select the X-Axis /Y-Axis from a drop-down) using a switch. These techniques are only necessary when using MDX queriesThese calculated fields are not available when the dataset is published as a shared report part, and need to be added manually to each report using the shared dataset.In addition, when using this technique, changing the shared dataset often breaks the reports with calculated fields, which need to be removed and re-added.Making calculated fields available as part of the shared dataset would improve the usability and function of this feature immensely.