Can this be done?

Is anyone aware of a utility, product or method to change a report definition at run-time? For example, I'd like to create a report and then perhaps remove columns, or change column order at run-time etc, based on user preference.

Thanks - Amos.

Out of the box you could use Report Builder to do this. There are some limitations in terms of layout and programmability, but it provides a very easy drag and drop experience for ad-hoc reporting.|||

John,

Thanks for the response. However, I am using the Report Viewer component to do strictly client side reporting using datasets. So, I don't think Report Builder will work, since, I think it only connects to a Report Services server (correct?).

Amos.

|||Yes, report builder requires the server.