What is the best REPORTING

[sbillows]

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?

[Nathan]

Microsoft has an article on dynamically populating data reports. Take a look at it it may help you with what you are trying to do.

http://support.microsoft.com/support/kb/articles/Q240/0/19.ASP

try that hope it helps.

[sbillows]

Thanks for your help