I am running a vb program that from a view will produce a list of records. I want these records displayed ont a Crystal Report.
How is this done as my crystal report will not be connected to anything?
Here is an example of a query I want the data onto a crystal report
adoCmd.Connection = adoConnection
adoCmd.CommandType = CommandType.Text
adoCmd.CommandText = "SELECT * FROM viewOfNames where department = "Accounts""
adoRdr = adoCmd.ExecuteReader()
sTest = adoRdr(Surname)
sTest2 = adoRdr(Forename)
sTest3 = adoRdr(Department)
The connection is where the view is. I could just use the view but I will be doing all sorts of data manipulation before putting the final results onto crystal reports.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)