Data Report

[Shah]

Hi,

How do i pass the selection criteria ie where clause from VB6 to the data report. Using crystal report i can use the CrystalReport1.SelectionFormula properties.

Any help would be much appreciated.

Regards

[d.paulson]

Your selection is made from the sql query.

select * from inventory where sales > 0 order by itemnumber

[Lakshmi Ram]

Add a data environment file to your project, Set up connection string as usual for Property -> Connection and enter your entire Select Query under the control -> command1, Property ->Connection.
You can add appropriate sqls for command2 grouping, etc...
Now bind this data environment to the data report. The data environment acts as a data source for the data report.

But I suggest you better stick to Seagate Crystal Reports.
Data report is a very ammature product and may be it is just evolving.
1. There is no method provided to close the Data report window that you open at run time. You will have to prompt a message to the user to close the window at the end after previewing the report.

2. If you want to insert a new row of data fields, you cannot insert a line directly as in crystal report. You have to instead shift every existing object down by one row and then insert your new data fields.

3. Data report is not offering even 10% of the wide range of features available in an old version (4.6) of Crystal report.

The later version of Seagate crystal is Ver 7.


Good luck
Lakshmi Ram

SNB