My report.rdlc is showing only one record(i.e. Top record in dt). Plz help

Question

1.00/5 (1 vote)

See more:

Hi,
I am trying to get records whose dates are between two date on report.rdlc using report viewer.
On button click data Table contains 5 records but my Report.rdlc is showing only top most record from data table.
I want to display all records from table in report.rdlc.
I am using C# 4.0 windows application and MSSQL 2008.
Plz help.
Thanks you.

Posted 3-Mar-14 19:40pm

Member 10641030

Updated 12-Sep-21 11:44am

Add a Solution

Comments

george4986 4-Mar-14 1:49am

post ur code here

2 solutions

Solution 3

Problem solved.
I have used Table to display the fields.
Due to Some Frustration there is always confusion.

Posted 4-Mar-14 2:35am

Member 10641030

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)

george4986 · Accepted Answer · 2014-03-03T19:59:00

Solution 1

try this

supposing ur datatable column in rdlc is coln_date

on ur Rdlc Design section

right click corresponding tabledetails cell

select 'Expression'

on the above box remove the First function

ie

C#

=First(Fields!coln_date.Value)

TO

C#

=Fields!coln_date.Value

Posted 3-Mar-14 19:59pm

george4986

Comments

Member 10641030 4-Mar-14 2:28am

Thanks for the answer.
My old code is

=First(Fields!Name.Value, "AD")

i have changed to

=Fields!Name.Value

but it is showing only top most record from data table.
Plz help.

george4986 4-Mar-14 2:31am

if u are running rdlc from application.startuppath
copy modified rdlc there and run again

Member 10641030 4-Mar-14 2:37am

private void btnprint_Click(object sender, EventArgs e)
{
DateTime from = Convert.ToDateTime(dtpFrom.Text);
DateTime to = Convert.ToDateTime(dtpTo.Text);
string str = "Select * from Sales where Date BETWEEN '" + from + "' and '" + to + "'";
SqlDataAdapter da = new SqlDataAdapter(str, con);
DataTable dt = new DataTable();
da.Fill(dt);
Microsoft.Reporting.WinForms.ReportDataSource rds = new Microsoft.Reporting.WinForms.ReportDataSource("AD", dt);
reportViewer1.LocalReport.ReportEmbeddedResource = "AutoZone.Report.rdlc";
rds.Name = "AD";
rds.Value = dt;
reportViewer1.LocalReport.DataSources.Add(rds);
reportViewer1.RefreshReport();
}
here is my code on button click.
what i have to change.
Thanks.

george4986 4-Mar-14 3:07am

whats the content of dt?

Member 10641030 4-Mar-14 3:17am

dt having
Name, Number, Address.
when i debug, it shows dt has 3 rows.
but rdlc is showing only top most row data.

george4986 4-Mar-14 3:39am

copy ur .rdlc file to some other location(backup existing)
from solution explorer
1)right click rdlc file
2)select open with
3)click xml editor then click OK button
4)inside table tag check value tag
5) if it has first function remove first function
6) save and run
7)make sure u take backup before doing this
gud luck

Member 10641030 4-Mar-14 5:29am

sorry but no change in result.
facing same problem.

george4986 4-Mar-14 5:45am

try
reportViewer1.Reset();
before following line
Microsoft.Reporting.WinForms.ReportDataSource rds = new Microsoft.Reporting.WinForms.ReportDataSource("AD", dt);

Member 10641030 4-Mar-14 5:52am

Thanks....
But no effect...
every time there are multiple rows in data table...
but the field in report.rdlc showing only one record data.

Is there anything related to "Repeat with" property of rdlc.

george4986 4-Mar-14 6:02am

no,did u tried creating new rdlc?

Member 10641030 4-Mar-14 6:10am

Thanks...
yes, i have tried with new rdlc.
same issue.

I have also tried with crystal report. It shows all records in crystal report,but when i create .exe and install it on other machine, the form containing crystal report viewer is not loading on MDI form.

george4986 4-Mar-14 6:37am

following above steps usually solves the issue ,don't know whats happen with ur rdlc