Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server Reporting Services (SSRS) Interview Questions > How to do reporting using SQL Server ,VB.net and A...

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)


 

Interview Question :: How to do reporting using SQL Server ,VB.net and ASP.net


I want to generate reports from the SQL Server 2000 databade combining different tables. I dont want to use Crystal reports or any other reporting services. I want to use reporting services of SQL server 2000
Answers to "How to do reporting using SQL Server ,VB.net and ASP.net"
RE: How to do reporting using SQL Server ,VB.net and ASP.net?

Just use the report wizard in SQL Server Reporting Services to create a report which gets its data from SQL server, this is fairly straightforward

.

Next, deploy the report to your report server (requires IIS).

You can then use either the web service (Reporting Services SOAP API) in a winform application to display your report, or from an ASP.NET you can put your report in a page as another piece of HTML, you can also call the webservice from ASP.NET.



[When you install SQL Server Reporting Services, there are various components. The 'report server' element has to sit on a box with IIS installed. It uses SQL Server to store the report files (RDL files) that you created in Visual Studio 2003 with the 'report designer' (shows under 'business intelligence' projects once installed)



If you do this in Visual Studio 2005 with SQL Server 2005 it is a whole lot easier with better functionality.
 
Vote for this answer ::  
RE: How to do reporting using SQL Server ,VB.net and ASP.net?

So, what's your question? If you want to use SQL Reporting Services, go ahead.
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License