Report not display in Report Viewer

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

SQL-Server

, +

i try to show ssrsc reports in asp.net web page using report viewer

code

C#

protected void Button1_Click(object sender, EventArgs e)
{

    ReportViewer2.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
    ReportViewer2.ServerReport.ReportServerUrl = new Uri("http://lenovo-pc/ReportServer");
    ReportViewer2.ServerReport.ReportPath = "/Report Project1/Report1";
    ReportViewer2.ServerReport.Refresh();
}

image
http://i.stack.imgur.com/DMChr.png[^]

where is the probelm... and why report not display?

Posted 2-Feb-14 2:17am

Diya Ayesa

Updated 2-Feb-14 3:07am

Nelek

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)

JoCodes · Answer 1 · 2014-02-02T06:45:00

Solution 1

Try

http://stackoverflow.com/questions/10938219/sql-server-2008-reporting-services-failed-login-for-user[^]

Posted 2-Feb-14 6:45am

JoCodes

Comments

Diya Ayesa 2-Feb-14 13:20pm

now it shows me error "An error has occurred during report processing.

Cannot create a connection to data source 'DataSource1'"

JoCodes 2-Feb-14 13:23pm

specify the SQL account credentials in the datasource

Diya Ayesa 2-Feb-14 13:41pm

i specify but not work.... check this image ...http://i61.tinypic.com/1i0bgg.png

Krunal Rohit · Answer 2 · 2014-02-02T07:16:00

Solution 2

It seems that you'r having an issue with the SqlDataSource.
I may be wrong but see if you've provided proper user credentials to the connection string of you database,

Posted 2-Feb-14 7:16am

Krunal Rohit

Comments

Diya Ayesa 2-Feb-14 13:40pm

please have a look this image ....http://i61.tinypic.com/1i0bgg.png

Krunal Rohit 2-Feb-14 13:44pm

okay,
try the following connection string
data source=LENOVO-PC\SQLEXPRESS;Initial Catalog=DMSFYPP; User ID=username;Password=pswd

here the values of User ID and Password must be of your Database Engine's credentials.
Give it a try, if it's not working let me know.!

Diya Ayesa 2-Feb-14 13:52pm

in my sql server 2008 r2 there is not a username and password my sql is in windows authentication mode

Krunal Rohit 2-Feb-14 13:53pm

provide that in connection string.

Diya Ayesa 2-Feb-14 13:56pm

in server name there is LENOVO-PC\SQLEXPRESS and i already provide this in connection string

Diya Ayesa 2-Feb-14 13:56pm

what i provide?

Krunal Rohit 2-Feb-14 13:57pm

your windows user name and passwor in connection string

Diya Ayesa 2-Feb-14 14:04pm

k i provide this...Data Source=LENOVO-PC\SQLEXPRESS;Initial Catalog=DMSFYPP; User ID=lenovo-pc\Administrator;Password=34234234 but error occur always same...

Krunal Rohit 2-Feb-14 14:05pm

Data Source=LENOVO-PC\SQLEXPRESS;Initial Catalog=DMSFYPP; User ID=Administrator;Password=34234234

Diya Ayesa 2-Feb-14 14:09pm

this shows me same errro :(
An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
Login failed for user 'lenovo-pc\Administrator'.

Diya Ayesa 2-Feb-14 14:12pm

look when i click on button and want to show report it show me like this
http://i59.tinypic.com/30lyrli.png

Krunal Rohit 2-Feb-14 14:20pm

http://msdn.microsoft.com/en-us/library/ms156450.aspx

Krunal Rohit 2-Feb-14 14:17pm

See I'm not able to figure it out, take a look here
http://www.c-sharpcorner.com/UploadFile/deepak.sharma00/how-to-generate-report-from-sql-server-database-using-report/

Diya Ayesa 2-Feb-14 14:23pm

this is not bids reports