Multiple Active Data

[redshadow]

Hi All,

I have seen a lot of samples using active data with visual basic, but is it possible to use more than one active data source in crystal using VB or other programming languages? If so, can you please give me at least an example on how this is carried out? Thanks in advance.

 

[synapsevampire]

Consider posting technical information and intent, rather than asking about what most people would prefer not to do because of performance, maintenance and reusability considerations.

Try including:

Crystal version
Database used
Example data
Expected output

Crystal will limit your join types to EQUAL if you have 2 data sources, and it isn't a very good database engine, so it doesn't make sense to use it in this fashion.

Since you're using VB, why not offload all of the processing to the database and then pass the recordset to the report?

A common alternative is to use MS Access to link in the data sources and then expose an Access Query for Crystal to report against.

-k

 

[redshadow]

Hi,

Thanks. This idea just came into my mind. I plan to use it in my study. I will use this with the following platform:
-Crystal Reports 8.0 or 8.5
-SQL Server 2000

Tables

salesperson table

emp_id varchar(10)
lastname varchar(30)
firstname varchar(30)
mi char(1)

client table

client_id varchar(10)
clientname varchar(60)
contactname varchar(60)
contactnumber varchar(20)
address_id char(2)
faxnumber varchar(10)

sales

id varchar(10)
period datetime
client_id varchar(10)
emp_id varchar(10)
amount numeric(20,2)
In this scenario I would like to have an output say:

Employee Name Sales Amount Client

-Sales Amount is the total sales per client made by an employee for a given month period.

I'll also try your suggestion to pass it in MS Access. At least I could have options.