Link to home
Start Free TrialLog in
Avatar of npbaker1

asked on

Problem using a dataset as a datasource for crystal reports

I can not figure out how to use my dataset as a datasource for my crystal report instead of the database.  When I add a Crystal Report to my project it brings me to a wizard where I can select what kind of report I want from which select use report wizard and standard and click OK.  I then get to a screen that says choose the data you want to report on and gives me a treeview with Project Data, Current Connections, Create New Connection and a couple others.  I expand Project Data and within that I have ADO.NET Datasets and .NET Objects.  I expand ADO.NET ds and I see the dataset that I have added to my project.  I expand that and it shows me the tables in my dataset.  For testing purposes right now I am using Northwind as the db and I have put the suppliers table into my dataset.  I select the suppliers table and click the > button and click next.  I then am at a screen where I can select which columns from the table I want in my report.  I select all of them and then click finish.  Now when I go to preview the report the data that it shows is not data in the dataset.  I see a list of color names under Company Name under Contact Name I see days of the week.  None of that is anywhere in either the ds or the db.  Now when I put a crystal report viewer on my form and set its source to be a variable declared as new crystalreport1 I see no data whatsoever.  I have no clue what it is doing.
Avatar of bprojoe

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial