Report Viewer Problem In ASP.NET 2.0

Hi i have a problem using Report Viewer With SQL Reporting Services 2005.

The problem is report toolbar is display but NO DATA is displayed and the report commes out as EMPTY :(. Even the parameters are passed successfully because i can see them in the text-boxes on the report parameters tool bar. But Report is Empty :(.

I have the following code.

ReportViewer1.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer"); ;

string reportPath = @."/MMM_MSRS/WebFormEvents";

ReportViewer1.ServerReport.ReportPath = reportPath

string cmp_id = "3803";

string vcli_id = "23649";

string cnct_id = "1";

Microsoft.Reporting.WebForms.ReportParameter[] Param = new Microsoft.Reporting.WebForms.ReportParameter[3];

Param[0] = new Microsoft.Reporting.WebForms.ReportParameter("cmp_id", cmp_id);

Param[1] = new Microsoft.Reporting.WebForms.ReportParameter("vcli_id", vcli_id);

Param[2] = new Microsoft.Reporting.WebForms.ReportParameter("cnct_id", cnct_id);

ReportViewer1.ServerReport.SetParameters(Param);

ReportViewer1.ServerReport.Refresh();

ReportViewer1.DataBind();

i think there might be problem in u r recordset.

you check u r resultset under the data tab of report designer. just pass the same parameters what you are passing in the report designer of the data tab(not on preview). check whether you are getting the results.

report services installation problem

Hello, i am having a installation problem that is giving this error:

SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.

the sql server 2005 only installed after i disabled report services from setup.

any ideas about solving this problem?

Hi,

When installing Reporting Services 2005, you can do an "install only" (not configure). Doing so, the installation process will just copy the needed files but not trying to configure accounts and the rest of stuff. Once the installation is done, you may revert to the Reporting Services Configuration Tool to configure items one at a time, and trying to understand or debug what is going on...

Hope this helps

Jordi Rambla
MVP SQL Server
SolidQualityLearning

|||

Hi ,

I am Also getting same problem while installing SQLServer 2005 on my machine.

I came to notice that SQLServer 2005 will install .Net Framework2.0 will automatically and we need to uninstall Framework 2.0 manually if We have already.So,I have already Net Framework2.0 on my machine.But i am using Framework in my WPF application and project is in ending position.So now i can't uninstall ramework2.0.What i have to do.

Please Help me...

Thanks,

B.Krishna chaitanya.

Report Service 2005 with VS.NET 2003 ASP.NET application

I am very new to reporting services.

Can anyone kindly summarise the ways you can access report services report in a VS.NET 2003 web project? I can only find crystal report components

Thanks in advance

Hi,

the easiest way is to create a proxy class for RS. You don′t have to do this on your own, simply create a web reference to Reporting Services. In the background the WSDL from the ReportServer is consumed and a proxy class generated. Now, you can use every SOAP API that Report Server offers for rendering the reports, more on that can be found in the tutorials of the BOL.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks very much for your reply.

What I need to do is build up a website which can show Reporting Service Reports, ideally I can add the Report Viewer and Report Explorer onto the web page. I have to use web services to realise this (in VS.NET 2003), don't I?

Thanks in advance if anyone can reply.

Report Server direct connect from ASP.NET application

OK, I am not a programmer, but administrate the Report Server and its security. The .NET programmers want to connect direct to Report Server using WEB.CONFIG settings (see below).

<appSettings>
<add key="ConnectionString" value="Server=bpatlqddw\atlqddw01;Database=MP2_NET_STAGE;Integrated Security=False;User ID=MP2_Net;Password=xxxxx;Persist Security Info=false"/>

<add key="LogPath" value="\\bpga030wde01\wwwroot$\MP2_Net\Logs"/>
<add key="Url" value="http://bpga030wde01/MP2_Net/" />

What do I need to do to ensure their dynamic reports can run against my Report Server? What kind of rights do I assign the "MP2_Net" (above) login? All of this is outside the IIS-Report Server security environment? Do I assign rights via SQL Mgr? I cannot find any doco on this process.

What are the .NET programmers trying to do exactly? What is database MP2_NET_Stage? When you install reporting services and point it to a database it creates two databases, ReportServer and ReportServerTemp. Are they needing to access one of these?

|||

ASP.NET application. MP2_NET & MP2_NET_Stage are the maintenance system databases (development at this time). They are using Report Server to build forms used by users, like work orders, PO's, etc. They are programically calling RS engine instead of using reports RDLs on web root.

I guess the question is: Can ASP.NET connect to Report Server using SQL Login instead of Windows Auth. via IIS layer? If so, is the WEB.CONFIG sample in above the way to go, and what are the options in script to accomplish. And, what do I need to do as DBA to get SQL security setup to allow it to work?

(sorry for misspells)