Solved

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

Posted on 2013-12-16
9
1,079 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 101

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 66

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

707 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