Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-12-16
9
Medium Priority
?
1,125 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 800 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 1200 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 Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

609 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