whats wrong with this code ...... in crystal report

Question

0.00/5 (No votes)

See more:

hi frens, i have a problem while using crystal report
i actually wanted to show the datas dynamically. i only wanted to show the seleted data in crystal report but the report viewer is showing all the datas

i have done something like this

C#

BLLCustomer blc = new BLLCustomer();
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        int custid =Convert.ToInt32(Request.QueryString["customerid"].ToString());
        int addid =Convert.ToInt32( Request.QueryString["addressid"].ToString());

        DataTable dt = blc.getAllByCustomerID(custid);
        ReportDocument rptdc = new ReportDocument();
        rptdc.Load("C:\\Users\\Bishnu\\Documents\\Visual Studio 2008\\WebSites\\Assignment1\\CrystalReport.rpt");
        rptdc.SetDataSource(dt);
        CrystalReportViewer1.Visible = true;
        CrystalReportViewer1.ReportSource = rptdc;
    }
}

in the BLLCustomer, i have the method to get all the fields of customer and i retrieved the customerid and addressid from query string but it is still showing whole of the datas in crystal reporting

please help me by showing my error
with regards bishnu

[edit]Code block added, "Treat my content as plain text..." option disabled - OriginalGriff[/edit]

Posted 24-Dec-11 1:41am

vishnu karki

Updated 24-Dec-11 1:43am

OriginalGriff

v2

Add a Solution

2 solutions

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)

thatraja · Answer 1 · 2011-12-24T02:58:00

Refresh the report.

C#

DataTable dt = blc.getAllByCustomerID(custid);
ReportDocument rptdc = new ReportDocument();
rptdc.Load("C:\\Users\\Bishnu\\Documents\\Visual Studio 2008\\WebSites\\Assignment1\\CrystalReport.rpt");
rptdc.SetDataSource(dt);
CrystalReportViewer1.Visible = true;
CrystalReportViewer1.ReportSource = rptdc;
CrystalReportViewer1.Refresh();//This line

For your information
C# Crystal Reports Tutorial[^]

vishnu karki · Answer 2 · 2011-12-24T01:49:00

Solution 1

i checked that the datatable dt is returning only selected value but the crystal report viewer is not showing only single record rather showing all of them
so what is the main error please help
with regards bishnu karki

Posted 24-Dec-11 1:49am

vishnu karki

Comments

RaviRanjanKr 24-Dec-11 9:26am

A suggestion :- you can use Have a question or Comment button to drop your message and to get Immediate response instead of posting as answer.