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.
Visual Basic.NET

Avatar of undefined
Last Comment

8/22/2022 - Mon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck