Solved

Need to develop a report based on sql query in Visual studio 2013 Ultimate...

Posted on 2013-12-16
9
1,050 Views
Last Modified: 2014-02-19
Hi,

I would like to create a new report in visual studio 2013 ultimate(asp.net c#). What are the built in tools available in Visual Studio 2013 ultimate?

Can you please guide me along with steps how to create a custom report in VS studio ultimate using SQL Query. My back-end is SQL Server 2005.

Thank you.
0
Comment
Question by:rperlalys
9 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39723894
The only tool I am aware of that comes with Visual Studio is the Data Reporting tool from MS.

You can use SQL Services Reporting that comes with SQL Server 2005.

You can also use Crystal Reports for .Net which is a separate download from SAP/Crystal.  You can download it from here

     http://help.sap.com/bocrvs

mlmcc
0
 
LVL 40

Accepted Solution

by:
Vadim Rapp earned 200 total points
ID: 39723943
Walkthrough: Creating a ReportViewer Report

I personally would stay away from Crystal Reports. Very far away.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39723950
SQL Server Reporting Services (SSRS) is the reporting tool of choice in Visual Studio / SQL Server Data Tools, so explain what you mean by '(asp.net c#)'.
0
 

Author Comment

by:rperlalys
ID: 39732828
Hi jimhorn,

asp.net and c# are the technologies what I am using for developing my website. Just I gave as an additional information.

Can you advise me along with steps on to use SSRS for reporting purpose?


Thank you.
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 300 total points
ID: 39753345
Can you advise me along with steps on to use SSRS for reporting purpose?

The link posted by vadimrapp1 leads to a walkthrough on getting started with "ReportViewer reports".  The ReportViewer is a .NET control available for both Forms and ASP.NET applications.  This control takes care of the report rendering.  This is called "client reporting" (hence the .rdlc extension as opposed to .rdl) and can be useful when you don't have access to a report server.  It also allows you to create reports through .NET code.

More supporting info:
Creating Client Report Definition (.rdlc) Files
Got ReportViewer: interesting FAQ + samples

The above is one method of using SSRS reports.  Another is the one where you do actually have access to a report server.  In such a case it is advisable to install the Business Intelligence Development Studio that ships with SQL Server which is the development IDE for SSRS reports.  In your case, assuming you only have SQL 2005 and no newer version (newer is more interesting, more possibilities and nicer dev experience), this will give you Visual Studio 2005 with the BI (SSRS, SSIS, SSAS) project templates.

Another tool that can be used to create SSRS reports (with .rdl extension) is Report Builder.  Latest version (should be backwards compatible AFAIK): Microsoft® SQL Server® 2012 Report Builder

This tutorial should help you get started with SSRS server reports: Tutorial: Creating a Basic Report
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question