Basic CR9.2 problem

[naruponk]

Hi all,

I have a doubt about Crystal report 9.2.
How can i assign a report from coding just like I want the report to show a data that ID>100 how can i retrieve it?

another way to explain is ....
like this
rs.open "Select * from tblA"
' then how set crystal report to show data from rs


Thank you

[SkiNLaB]

You will need to set up a Data Definition File (ddf) for your report. Which will list what fields your recordset will contain, Then you can design your report from that ddf, by setting the report's datasource to that file.

Then in VB, you can pass the data for the report like so

cReport.Database.SetDataSource rst


For a detailed run through see here, it talks about using MySQL, but its methods are database independant.

http://vbmysql.com/articles/crystal-...alvbmysql.html

If you have any more questions, I'll be glad to help

[naruponk]

Thanks SkiNLaB,

but i really dont know how to set up ddf file
can you tell me a little more?

thanks

[SkiNLaB]

http://vbmysql.com/articles/crystal-...sql.html#part2