troubleshooting Question

Problem using a dataset as a datasource for crystal reports

Avatar of npbaker1
npbaker1 asked on
Visual Basic.NET
1 Comment1 Solution497 ViewsLast Modified:
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.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros