Yes. This is really simple to do.

You have to use the Microsoft SQL Server 2005 Report Viewer Redistributable component.

This .Net control is installed on your PC when you install SQL...

I always declare fact to dimension foreign key constrains in SQL Server 2005.

However I do not enforce the foreign key constraint, nor define any cascading event actions.

Example :

ALTER TABLE...