Crystal reports programming approach?

[vbmom]

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.

[jayakumar]

hi,

there are two ways of using crystal reports.

1)u can include two or more tables and get the data.if u include tables crystal reports automatically made links to each table depending on the type.
2)u can create a view and access the data.