Blog

Creating Reports with SQL Server Reporting Services

By Carina C. Terms used in Reporting Services: ·         Data Source ·         Data Set: query related to a data source ·         Data Region: object that displays data Types of Data Regions: ·         Table: Tabular report ·         Matrix ·         List: free form enlisted data ·         Graphics Creating Reports in Reporting Services Reporting Services offers the following ways to create a Report: ·         Add New Report Wizard (Templates) ·         Add/Add New Item. Creates a blank report ·         Import Reports. It allows the importation of reports from an Access database Report using Tables Data View 1.       Select <New Dataset…> 2.       Assign a na...

How to send a Scheduled HTML report directly from SQL Server

By Gabriel Palma   The situation A customer asked recently for a quick daily report of about-to-expire items, he wanted something simple that could be sent via email to the people already registered in the database. Acquiring the information was very simple (as simple as writing a query). The problem was getting those results inside an email and sending it automatically every day. We came up with a scheduled SQL Server job running daily, getting and shipping the results without passing through .Net code.   The steps Step 1. Write the query to retrieve the raw data.   I used AdventureWorks database for the following example. Here I’ll get a report of work orders with due date ...