New to Creating Report from an SQL Database

[melessqr]

Hello, and thanks for any help you might be able to give me.

I'm new to Crystal Reports and have been tasked with creating a report in a VB application using an SQL database.

I'm making this report that involves multiple tables from the SQL Database, and includes several sub reports. The main body of the report needs to reference data from several different tables, and each sub report will be referencing data from one (distinct) table per subreport.

I think what I'm wanting to do is create multiple TTX files (one for each table) and pass the ADO recordset for each table to the report.

I'm really stuck on the mechanics of how to both create the TTX files off the SQL database so that I can format the report body and sub reports, and how to pass the ADO recordsets to the report from the VB app.

Any help, guidance, reference material would be greatly appreciated.

Kenneth W. Scott
(n00b)

 

[shokti]

if you are using ado connection, you can pass your recordset from vb to your crystal report, use setprivatedata method of your crystal report component.
use the sqloledb provider in your connection string.

 

[synapsevampire]

Here's some reference material:

http://www.kather.net/VisualBasicSource/CrystalReports/Crystal_Reports_and_Visual_Basic.doc

http://www.vbcity.com/forums/topic.asp?tid=94

-k

 

[shokti]

if you will use setprivatedata, do it like this:
craxReport.Database.Tables.Item(i).SetPrivateData 3, rsData

where i is your table's index in the Report & rsData is your adodb.recordset to pass. dont change 3, its a default value. craxReport is a craxdrt report.

if you will use setdatasource, do it like this:

craxReport.Database.SetDataSource rsData , 3, i

just use which you think is better.