How to diplay Million Records inRDLC Report?

0.00/5 (No votes)

See more:

HI,

I have One table in Sqlserver2008R2 ,there are miliion rows and am going to display 15 Lac Reords with Filter Condition (From date to End Date) in RDLC Report.

There are column name is fName, LName, Adress,Create Date .
So Page loading very Slow .How to improve Performance in RDLC Report?

Thanks in advance
Santhoshkumar S
9710884270.

Posted 1-Apr-14 0:09am

24983

Add a Solution

Comments

Richard MacCutchan 1-Apr-14 6:41am

Don't try to extract that many records at one time. As Scotty so eloquently put it, "Captain, I canna change the laws of physics"

24983 1-Apr-14 7:40am

Thanks...But How to manage in this situation.

Plz give me idea

[no name] 1-Apr-14 7:45am

You don't. Get the person that wanted you to do this to share whatever it is that they are taking. Displaying that many records is just plain insane. No one is ever going to look at it. Cut it down to a number that a normal reasonable person could deal with.

24983 1-Apr-14 7:54am

ok thanks... I will try

24983 1-Apr-14 8:04am

I have used Search Condition with start Date and end date and there is also i getting 10 Lac recods.
What can i do?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...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)

Last 24hrs

This month

merano99	60
Richard MacCutchan	50
OriginalGriff	50
Stefanmuis12345	-16
Tassaduq009	-32

Pete O'Hanlon	1,125
OriginalGriff	787
Richard MacCutchan	305
merano99	180
Dave Kreskowiak	130