Click here to Skip to main content
12,948,566 members (61,735 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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()
While adoRdr.Read()
    sTest = adoRdr(Surname)
    sTest2 = adoRdr(Forename)
    sTest3 = adoRdr(Department)
End While

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.
Posted 11-Jan-13 5:38am
Updated 11-Jan-13 5:43am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

If I understood the question correctly, you can store the result in a datatable, make the necessary modifications and then use the datatable as a data source for Crystal.

For example, have a look at:
- Creating Crystal Reports using C# with Datasets[^]
- Crystal Report with DataSet and DataTable using C#[^]
- Crystal Reports Without Database[^]
Maciej Los 11-Jan-13 13:02pm
Mika Wendelius 11-Jan-13 13:20pm
Thanks :-D

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,419
CHill60 3,275
Maciej Los 2,778
Jochen Arndt 1,935
ppolymorphe 1,795

Advertise | Privacy | Mobile
Web02 | 2.8.170524.1 | Last Updated 11 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100