I am wondering if someone can 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?