To all Gurus,

I am using Crystal Reports for VS.net and doing programming in VB.net
I found two ways for reporting for me:

Method 1: Design report using open database and view it at runtime.

Method 2: Design report using DataSet schema: in this method I planning to
i) Create temp DataSet schema say DataSet1
ii) Design the report and save report say Report1.rpt
iii) Remove temp dataset DataSet1 from project
iv) At run time pass a DataSet (created on the fly) to report for data

I want to use Method 2. The reason is it will give me more data collection power. Like in DataSet (on the fly at run time) I can crate DataTable using SQL-query having power like nested query, union of query.

Is Method 2 is correct approach ?

Thanks again to all masters.