Can someone help me with deciding which reporting method to use - Crystal Reports, Microsoft Data Report, or other.

My applicaiton reports on the database selected by the users.

I have tried setting up Microsoft Data Reports but I have had no luck in setting a variable for the database name in the DataEnvironment Connection 1 properties.

Can a variable be set for in Microsoft Data Reports or do I need to use another reporting method that can handle variables?

Regards