Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Report - Interactive Sort on Calculated Field

Author  Topic 

emzzz
Starting Member

15 Posts

Posted - 2008-02-27 : 10:05:04
Hello,

I have a report that calculates a field and therefore it does not exist in the dataset.

Can I perform an interactive sort on the textbox that contains this calculation?

Many thanks.

emzzz
Starting Member

15 Posts

Posted - 2008-02-27 : 10:29:39
This is how I have solved the problem.

Add a new field to the dataset in the DataSet View.

Amend the calculated field to be what you would like; this field will also accept custom code.

Reference the new field in the report and use the new field name for the interactive sort.
Go to Top of Page
   

- Advertisement -