troubleshooting Question

Creating a crystal report from a dataset

Avatar of elmbrook
elmbrook asked on
C#
12 Comments3 Solutions772 ViewsLast Modified:
Hi

I have created a blank Crystal report called test.rpt.

I would like to manually add the information from a dataset to the report.

The report is loaded into Crystal Report Viewer.

The below code works in adding the report to the viewer but how would I connect my dataset to it?

I think I am close, just need help with the final display.

Thanks
private void rptBrowser_Load(object sender, EventArgs e)
        {
            // Create new DataSet
            mydb thedb = new mydb();
            SqlDataAdapter myds = null;

            string _sql = "select LogName, Firstname, Lastname from sysUser";

            myds = thedb.myDataAdapter(_sql);


            ReportDocument cryRpt = new ReportDocument();
            cryRpt.Load(myglobal_properties.FP1 + "test.rpt");
            rptView.ReportSource = cryRpt;
            rptView.Refresh();


          
        }

Open in new window

ASKER CERTIFIED SOLUTION
elmbrook

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

Join our community to see this answer!
Unlock 3 Answers and 12 Comments.
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 3 Answers and 12 Comments.
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