|
|
|
|
|
Total Hits: 33 | Today: 0
|
Author: John C. Hancock
|
Rating:
|
|
Flexible reporting capabilities are a requirement for most business applications and their integration into Web apps makes them more versatile than ever. With the recent release of SQL Server™ 2000 Reporting Services, you can easily add reporting from diverse data sources. In this article I will introduce report authoring using Visual Studio® and Reporting Services and demonstrate how to integrate reports into your Web applications....
|
|
|
|
Total Hits: 59 | Today: 0
|
Author: James Catchpole
|
Rating:
|
|
Most medium to large sized businesses have a reporting solution that provides timely financial information in a user-friendly format for sales people, managers and customers. Usually, the "solution" is a dedicated reporting employee who manually queries source databases for statistical data....
|
|
|
|
Total Hits: 58 | Today: 0
|
Author: Alok Mehta and Daniel Williams
|
Rating:
|
|
Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of...
|
|
|
|
Total Hits: 24 | Today: 0
|
Author: Dan Burman
|
Rating:
|
|
Part 1 of a three-part series on creating Web applications with Visual Web Developer 2005 Express Edition and SQL Server Express covers setting up a project and creating a SQL Server Express database, and explores the use of the ASP.NET Web Site Administration tool to set up roles, users, and providers. It also covers utilizing security controls such as Login, LoginStatus, LoginView, CreateUserWizard, PasswordRecovery, and ChangePassword....
|
|
|
|
Total Hits: 39 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
Microsoft SQL Server Reporting Services is a complete platform for creating, managing, and delivering reports from a variety of data sources.
Reporting Services offers comprehensive functionality for processing, formatting, and rendering data in a variety of traditional and interactive reporting formats. Applications can take advantage of Reporting Services functionality in many ways, from accessing an existing report within an application or portal page, to embedding report processing an...
|
|
|
|
Total Hits: 25 | Today: 0
|
Author: Stacia Misner
|
Rating:
|
|
This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services Step by Step, by Stacia Misner and Hitachi Consulting. Learn how to monitor reporting services by implementing an execution logging database and reviewing reports that query that database. (...
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: Fang Wang
|
Rating:
|
|
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is frequently requested....
|
|
|
|
Total Hits: 34 | Today: 0
|
Author: Richard Mao, Simba Technologies
|
Rating:
|
|
This paper discusses the integration of SAP NetWeaver Business Intelligence (BI) with Microsoft SQL Server 2005 Reporting Services Service Pack 1 and later. The paper provides an overview of using the data provider and query designer to build high-quality reports on SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you get up and running quickly. For users who are already familiar with SAP NetWeaver, the paper will show how ...
|
|
|
|
Total Hits: 31 | Today: 1
|
Author: Bryan Avery
|
Rating:
|
|
I will take you through how to deploy your own Custom Data Process Extension for SQL Server Reporting Servers 2005, both on the server and for use within your development environment....
|
|
|
|
Total Hits: 38 | Today: 1
|
Author: Ed Hild
|
Rating:
|
|
Imagine you work for a company that has a critical database application that continually records new incoming information. This database could be storing order information, sales contacts, or just about any other kind of data. Now consider that a group of individuals within your company rely on reports about this data—perhaps trend analysis of monthly billing statements—for making key business decisions. These reports are created on a schedule: daily, weekly, or monthly. Sound familiar? Chances ...
|
|
|
|
Total Hits: 110 | Today: 0
|
Author: Giridhar
|
Rating:
|
|
This article features the following:
1. Building of Business Intelligence Report.
2. Deploying the Reports on the Report Server
3. Reporting in ASP.NET....
|
|
|
|
Total Hits: 462 | Today: 0
|
Author: Rickey Whitworth
|
Rating:
|
|
If you are using a sqlDataSource to handle updates, deletes or inserts to an underlying database from a gridview control, then you may run across this message...
|
|
|
|
Total Hits: 208 | Today: 0
|
Author: Wei-Meng Lee
|
Rating:
|
|
Microsoft has finally added reporting capabilities to SQL Server 2000. With the rollout of SQL Server 2000 Reporting Services, you can now generate reports from your database without the need to use third-party reporting tools. In this article, I will walk you through the basics of creating a simple report using the SQL Server 2000 Reporting Services. In the next article, I will discuss how you can integrate reports into your .NET applications....
|
|
|
|
Total Hits: 241 | Today: 1
|
Author: Don Schlichting
|
Rating:
|
|
A pivot is a data mining option typically used to transform large amounts data into a condensed list. Pivot style reports display data in a grid along a vertical and horizontal axis. Financial and managerial reports are the examples usually sited. The pivot style report pictured below displays sales data; with the Year of the sales running along one axis and the Quarter the sales was made running along the other. The sales amount is the sum of all dollars for the particular year and quarter....
|
|
|
|
Total Hits: 207 | Today: 0
|
Author: William Pearson
|
Rating:
|
|
An important consideration, when designing a Business Intelligence system within any environment, is a consideration for "where to put the intelligence" among the various "layers" within the system. I have stated many times in the past, in both articles and presentations, that "multi-layered reporting solutions require multi-layered architects," and nowhere is this truer than within the design and implementation of the Microsoft integrated business intelligence solution. This article provides an...
|
|
|
|
Total Hits: 26 | Today: 0
|
Author: Andy Searls
|
Rating:
|
|
SharePoint lists are stored in a SQL Server database, so you would think that connecting SQL Reporting Services to a SharePoint 2007 list would be trivial, but it’s not. There are a number of pitfalls to be avoided that are not entirely clear and do not provide clear error messages. In this white paper, I’ll outline one approach to attach a report to a list. I’ll include common mistakes and ways to avoid them as well as tips for determining causes of problems you might find along the way....
|
|
|
|
Total Hits: 26 | Today: 0
|
Author: pengyi
|
Rating:
|
|
How to select what fields to display on a report from a multi-value.
Sometime clients want to select which fields need to be displayed in the report. SSRS can provide this function through multi-value parameter and custom code.
1. Add a multi-value parameter including all the fields need to be selected....
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: Alexei Fimine
|
Rating:
|
|
Often we require our data rows / lines to have different colors for various purposes and reasons. The colors may be different purely for improving readability or based on data. While ASP.NET components offer very powerful tools to achieve that SQL Reporting has only limited functionality. However, even with it, one can get fancy.
For the purpose of simplicity I will not get fancy, but only demonstrate how to have your row styles changed in batches of 4. I.e. Row colors will repeat not eac...
|
|
|
|
Total Hits: 326 | Today: 0
|
Author: Deepankar Sarangi
|
Rating:
|
|
In this code snippet, Deepankar examines how to select only specific records from a table commencing in a series (even series i.e. 2nd,4th,6th...records or odd series i.e. 1st,3rd,5th.... records and other simple series) in a single query. He provides a detailed analysis of the relevant SQL statements with the help of relevant screenshots....
|
|
|
|
Total Hits: 55 | Today: 0
|
Author: Tian Ying He, Carolyn Chau
|
Rating:
|
|
This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP. We also highlight a few product limitations, as well as enterprise considerations. It is based on a real-world implementation by Microsoft Business Intelligence Center of Excellence....
|
|
|
|
|
|
