VB.Net and Crystal Reports

[matthew]

I am a newbie at connecting different dbs with Crystal Reports. I have an Access db that I want to query and use those results to query into a Progress db to generate a report. Could I do this strictly in Crystal Reports using VB code or would it require a standalone VB app? What would the best course of action be? I am using VB.NET 2003 and Crystal Reports 8.5 and am connecting to both dbs via ODBC.

Thanks so much for your help!

[AlexB1234]

ODBC is a solid database interface. These days Microsoft pushes OLEDB. YOu can use both with .NET. You can do the Windows app or a Web page (ASP.NET). I've got an ASP.NET sit that uses Crystal. The website is nice because you don't have to push a bunch of stuff out to users. Also I like to pass a Dataview to crystal rather than letting crystal query the db. Might just be a personal preference, but it's worked fine for me. The downside to the web app is that you've got to push down a PDF of the report for printing.

Good luck making your decision.