Crystal report generation based on given detail

Question

3.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Dear All,

Now am working at c# windows application. Here i have one combobox and

one button in my form. In my combobox have 3 items Table1,Table2,Table3. In my

database have one table ALLTABLE(column of this table is

TableName,CustomerName,Datetime), am save all the 3 tables data at ALLTABLE. Now i

wanna to get Table2 report only from ALLTABLE . So i select Table2 at combobox and

press button. is this my problem. Am did report for whole table but this is my

experience for this type of problem. All replies are welcome.

Thanks & Regards

Dhinesh Kumar.V

Posted 21-Aug-12 20:30pm

Dhinesh kumar.V

Add a Solution

Comments

ssd_coolguy 22-Aug-12 2:45am

if i correctly understand your problem then...
you just need to pass the parameter to your report..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sourav Sarkar-SS · Answer 1 · 2012-08-22T11:06:00

I think this will help you.

C#

private void frm_Load(object sender, EventArgs e)
        {
          
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "Your Connection String Here";
            con.Open();
            SqlDataAdapter da3 = new SqlDataAdapter("Select * from ALLTABLE where TableName='"+combobox1.Text+"'", con);
            DataSet ds3 = new DataSet();
            da3.Fill(ds3, "TableName");
            CrystalReportName abc = new CrystalReportName();
            abc.SetDataSource(ds3.Tables[0]);
            crystalReportViewer1.ReportSource = abc;
            crystalReportViewer1.Refresh();
            con.Close();
        }

any problem revert back