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.
ASKER CERTIFIED SOLUTION
bprojoe

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