Crystal Report: Is it correct approach ?

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.

Not any guru has seen ?

:rolleyes:

I am no Guru, but I use Crystal Reports quite a bit and method 2 seems to work great. "Pushing" data into the report this way gives you the most flexibility for selecting data and working directly with the CrystalReports.Engine namespace gives you complete control over any aspect of the report at run-time.

can any1 advise me some materials to read about approach 2

i need examples if you please

thx in advance

BST RGDs

Hi Maged

Read this file http://support.businessobjects.com/c...viewer.pdf.asp

Regards
Jorge

Hi parminder

I use method 1 a lot well my project has currently 75 reports and still adding new reports and only one uses approach 2.

Regards
Jorge