Share Your Source Code or Article

 Do you have source code, articles, tutorials, web links, and books to share? You can write your own content here. You can even have your own blog.

Submit now...

Database Programming Made Easy

This tutorial will teach you step by step on how to connect and manipulate database. If you'd like to suggest a tutorial please write a comment at the bottom of this article.

Read more...

Hire Us to Do Your Work

Do you want a customized system? Do you want to setup your own website to do business? Then we are here to help you in your programming needs.

Read more...

Navigation

Recent Reviews

Recent Blog

more

Recent Tutorial

more

New forum topics

more

Popular Tags

more tags

Search

Home » Blogs » hlaminswe's blog
Load Crystal Sup Report in VS2008
hlaminswe's picture
Submitted by hlaminswe on Wed, 07/07/2010 - 14:07
in


Suppose you have namespace MoonSun.Solution.Report, and report rpt_StaffMovement that has 4 subreports name
1. NewStaff
2. Resignation
3. Termination
4. Transfer

You can use the following code
parameter DataSet dsStaffMovement has four tables

  1. public static void View_StaffMovement(DataSet dsStaffMovement)
  2.         {
  3.             try
  4.             {
  5.                MoonSun.Solution.Report.Rpt.rpt_StaffMovement rptDoc = new MoonSun.Solution.Report.Rpt.rpt_StaffMovement();
  6.                 rptDoc.OpenSubreport("NewStaff").Database.Tables[0].SetDataSource(dsStaffMovement.Tables[0]);
  7.                 rptDoc.OpenSubreport("Resignation").Database.Tables[0].SetDataSource(dsStaffMovement.Tables[1]);
  8.                 rptDoc.OpenSubreport("Termination").Database.Tables[0].SetDataSource(dsStaffMovement.Tables[2]);
  9.                 rptDoc.OpenSubreport("Transfer").Database.Tables[0].SetDataSource(dsStaffMovement.Tables[3]);
  10.  
  11.                 frm_RptDesign frmRptDesign = new frm_RptDesign();
  12.                 frmRptDesign.crView.ReportSource = rptDoc;
  13.  
  14.                 frmRptDesign.crView.Zoom(75);
  15.                 frmRptDesign.Show();
  16.             }
  17.             catch (Exception e)
  18.             {
  19.                 MessageBox.Show(e.Message.ToString() + "," + e.StackTrace.ToString());
  20.             }
  21.         }



Post new comment

  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <java>, <java5>, <javascript>, <mysql>, <php>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • You may use [inline:xx] tags to display uploaded files or images inline.

  • Links to specified hosts will have a rel="nofollow" added to them.

  • You may insert videos with [video:URL]

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

Relevant Content

Feed subscription

What is RSS

Enter your email address:

Delivered by FeedBurner

Popular

All time:

Recent comments

Poll

Top 10 Programming Languages Poll:

Technology & Computers - Top Blogs Philippines

Step by Step Java Tutorial

In this tutorial you will learn how to program with Java. It has a rich of information to be educated well with Java.

Read more...

Do You Have Question?

 Do you have any question related to computer programming? Visit our forum and post new topic on the category you like. Be gentle when asking a question.

Ask now...

Point of Sale

Point of Sale is very useful especially for supermarkets or restaurants. I have included a barcode scanner in this program. Please check it out.

Read more...