Hi. I am very new to both VB.NET, Crystal 9, and database programming. This is a general question regarding technique or method.

I wish to retrieve information from multiple tables in a database and report on it in various ways using Crystal reports. I feel that performing multiple queries is wasteful, and the data may be out of synch across the various reports.

Should I be pulling this data into some kind of structure before feeding it to the crystal report? Is it ADO or something else inside Crystal?

How does the real world do this?! Thanks for anyone's help.