Standard method of creating reports (RESOLVED)

[divined]

Hello everybody

I`ve been using Crystal Reports for my application reporting needs for some time. I`d like to ask how you guys start creating a new report using the RDC for example.

Lets say that I have a table named Typos and I would like its fields to be displayed on a simple report using the RDC component. What I do is create a System DSN ODBC datasource to the MySQL database. Then I can populate the designer object with the required fields, using the System DSN Connector.

In my code now I use ADO and an ADODB.Recordset object to populate the RDC object.

CrystalReport_list.SetDataSource rs 3, 1

The problem now is that in every machine I distribute the application to, I also need to create a System DSN Connector. Can I get around this? I mean, how can I place the required field on the RDC designer at design time, without requiring a System DSN Connector. Can this be done?

[Hack]

The problem now is that in every machine I distribute the application to, I also need to create a System DSN Connector. Can I get around this? I mean, how can I place the required field on the RDC designer at design time, without requiring a System DSN Connector. Can this be done?

I've used Crystal with both Oracle and SQL Server applications and for each I had to have a System DSN on my end users machine, so no, I don't think you can get around this.

The good thing is that you only have to do it once. Once you have that DSN, you need not worry about future applications and Crystal.

[divined]

What struck me as odd though is that the embedded reports seemed to have kept the user name of the System DSN Connector I`d used on the development machine! Thus, I have had to define the same user for the System DSN Connector on every target machine. Was this so in your case?