How to display all records of a customer in RDLC report by customer ID

Question

0.00/5 (No votes)

See more:

Hello everyone
My name is Sarfaraz and I am presently working on a project which is almost complete except that I need to print some reports based on a criteria.
I want to display all the records of a customer from purchases table by entering his customer No in a text box and after clicking a button should display a report based on that account number.
I have designed a report and i tried something like

<br />
Imports Microsoft.Reporting.WinForms<br />
    Private Sub btnload_Click(sender As Object, e As EventArgs) Handles btnload.Click<br />
        setFilterparameters()<br />
    End Sub<br />
    Private Sub setFilterparameters()<br />
        Me.purchasesTableAdapter.Fill(Me.DSPurchases.purchases)<br />
        Dim account As New ReportParameter("account", acno.Text)<br />
        ReportViewer1.LocalReport.SetParameters(New ReportParameter() {account})<br />
        ReportViewer1.RefreshReport()<br />
<br />
    End Sub<br />

But it actually display account number of all the records what i have typed in the textbox and display all the records on the report.
Please help in this regard.
Thank you

Posted 4-Jan-15 3:57am

sarfarazbhat

Add a Solution

Comments

DamithSL 4-Jan-15 10:08am

have you added account parameter in your rdlc report and have you use it to filter data in your data source?

sarfarazbhat 4-Jan-15 10:42am

Yes from the report Data i added a parameter with data type integer because account number is a number in access and then assign it to the ac_no in rdlc report and in the data set there is a query fill,getdata which displays all the records if i try like


SELECT        bill_no AS Expr1, ac_no AS Expr2, items AS Expr3, length AS Expr4, breadth AS Expr5, amount AS Expr6, dated AS Expr7, bill_no, ac_no, items, length, breadth, 
                         amount, dated
FROM            purchases
WHERE        (ac_no = ?)

still the code is not working.
Any idea sir
Thank you

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)