SQL Server Reporting Services 2008 Tutorial in 5 Minutes

Some facts:

  • SQL Server Reporting Services were great in the past. SSRS 2008 are better.
  • MSDN is great. MSDN has lots of details. Sometimes it’s too much if you are under pressure.
  • Google usually gets me the information I want faster. Especially when I need to get something done quickly.

All in all this post is for those of you that need to learn how to use SQL Server Reporting Services fast or need to solve the above mentioned problem fast, without knowing too much about the details. I read a lot of and like these introductory posts and so now I’m writing another one, here goes.

I assume you have SQL Server Reporting Services already setup (by your grand one-and-only unmissable sys-admins or by yourself, but in the latter case you probably are not the target audience for this) and you have access to the all required tools. Talking about tools, there are three you should know of:

– RSConfigTool – (Start menu > SQL Server 2008 > Configuration > Reporting Services Configuration): What do I need it for: Troubleshooting, Finding Urls, Configuration Report Server. Having problems trying to connect. See Additional Tip #1.

– Report Manager – (http://<yourserver>/reports): What do I need it for: Managing your reports (you won’t actually see anything on a clean install yet)

– Business Intelligence Studio – (Start menu > SQL Server 2008 > SQL Server Business Intelligence Development Studio): What do I need it for: Creating and editing your reports

and of course you will need SQL Server Management Studio for managing the data the report is based upon.

(side note: This tutorial is based on the 2008 version, can’t say how many differences there are between this and the older versions.)

1. Create your views

There are ways to aggregate your data in the report itself, but it’s easier and cleaner to use SQL views to provide the data for the report and use Reporting Services only for the report. So go to SSMS and create your view.

2. Create a new BIDS (Business Intelligence Development Studio) solution based on the “Report Server Project” Template. Add a new report by clicking on the Report node in the Solution Explorer. Next we need to connect to a data source. Give it a name, click edit and connect to your database.

datasource

3. Click next and the Query Designer appears. Here you enter the T-SQL statement for your data. Ideally it’s just a “SELECT * FROM yourView” (or select each column distinctly). You can test it using ‘Run Query’. You can also choose to use data from a stored procedure if you like, just select the appropriate option.

reportdesigner1

4. Design your report. You can add elements to the report surface, by right clicking on the center surface and select them from the insert menu. The most important are Header, Footer and Table. In the Header and Footer you can add Textboxes with text or by right-clicking on them and choosing expressoin you can choose some variable input. For example page number, report name etc. In the table you can drag columns from the “Report Data” (on the left showing the data source you just added). When you are finished, you might have something like this. Click preview to get a glimpse at what your boss might get.

reportdesigner2

reportpreview

5. Now let’s deploy it to the report server. First we must set the report server url. Right-click on the solution in the Solution Explorer and click on Properties. You will see the following dialog. Change the TargetReportFolder value to something you wish and provide the TargetServerURL as http://yourserver/reportserver (not just /report!). Press save. Now right-click on the solution again and select Deploy.

reportproperties

6. When it finishes open the url http://yourserver/report (not /reportserver!). You will see something like this. Go ahead and click on Test.Reports (or whatever you specified as TargetReportFolder) and then click on your test report. You will be greeted with the web version of your report.

webreport

7. Now your Boss will not want to go the web page to get that report, so let’s look at sending it to him per email automatically. First we need to change the security settings for connecting to the data source. In the report page, click on Properties > Data Sources. Change the “Connect using” to “Credentials stored securely in the report server” and specify an account that has access to the data. Also check “Use as Windows credentials…”.

security

8. Now you can go to Subscriptions. Click on email. Don’t have email as an option? See Additional Tip #2. Enter the recipient information as you wish and select a schedule for the sending. If you press save and encounter an error that ‘SQL Server Agent is not running’ either figure it out yourself what the problem could be or read Additional Tip #3 :). Once you have finished, lean back and let SSRS make your boss happy and in turn make you happy.

So we have seen the absolute basics of report creation. A quick and dirty introduction. This should cover your first encounters with SSRS. Hope it helps someone!

Stop reading here unless you are Troubleshooting…

Additional Tip #1:

I try connecting with SSMS (Management Studio) and it won’t connect. Maybe you renamed the server? Open RSConfigTool, go to Database > Change Database > Choose an existing report server database. Just choose the existing one, and let it run through it’s config. That should repair everything and you should be able to connect using SSMS again.

Additional Tip #2:

You don’t have email in the options for delivery in the subscriptions dialog? Probably it’s not configured. Thankfully that is very easy. You start the RSConfigTool. Connect and go to the Email tab. There you just specify a sender address and the SMTP server you would like to use. Click apply and voila. The server will automatically restart and the now the email option appears.

Additional Tip #3:

Saving the subscription results in an error message saying SQL Server Agent is not running. This is a DB or sysadmin issue, but just fire up SQL Server Configuration Manager (in the Start Menu under SQL Server 2008 > Configuration) then click on SQL Server Services, right-click on the SQL Server Agent > Properties. Go to the service tab, change Start Mode to Automatic and press OK. On the next reboot it will start automatically, but you still need to start it once for now. Right-click on the ‘SQL Server Agent’ and press Start.

 

Reference : http://alexduggleby.com/2008/07/18/sql-server-reporting-services-2008-tutorial-in-5-minutes-or-how-to-send-my-boss-a-report-from-a-view-quickly/

Introduction to Oracle Reports

Oracle Reports is Oracle’s award-winning, high-fidelity enterprise reporting tool. It enables businesses to give immediate access to information to all levels within and outside of the organization in an unrivaled scalable and secure environment.

Using Oracle Reports, you can rapidly develop and deploy sophisticated Web and paper reports against any data source (including an Oracle database, JDBC, XML, and text files). Leveraging Java EE technologies such as JSP and XML, you can publish your reports in a variety of formats (including HTML, XML, PDF, Enhanced Spreadsheet, Spreadsheetdata, delimited text, delimiteddata, PostScript, and RTF) to any destination (including e-mail, Web browser, WebDav, FTP, Oracle Portal, and file system) in a scalable, efficient manner.

Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Reports Services (a component of Oracle Fusion Middleware).

Oracle Reports Developer includes the following component:

Oracle Reports Services is the focus of this manual. It executes, distributes, and publishes your reports for enterprise wide reporting. Using Oracle Reports Services to deploy your reports results in gains of flexibility, time savings, and processing capacity. It includes the following components:

For more resources for information about Oracle Reports, refer to “Related Documentation” in the Preface.

1.1.1 Oracle Reports Builder

As its name implies, Oracle Reports Builder (rwbuilder) is the report-building component of Oracle Reports. Report developers use the Oracle Reports Builder design-time user interface to create and maintain report definitions, using:

  • user-friendly wizards that guide you through the report design process
  • pluggable data sources (PDSs), such as JDBC and XML, that provide access to data from any source for your reports
  • a query builder with a graphical representation of the SQL statement to obtain report data
  • default report templates and layout styles that can be customized if needed
  • a live editor that enables you to modify paper report layouts in WYSIWYG mode
  • the ability to add dynamic report output to an HTML page by embedding custom JSP tags within an HTML document
  • an integrated graph builder to graphically represent report data
  • the ability to generate code to customize how reports will run
  • tools that dynamically generate Web pages based on your data
  • standard report output formats such as HTML, HTMLCSS, XML, PDF, RTF, spreadsheet, PCL, PostScript, and ASCII
  • client-side parameter validation using JavaScript
  • the ability to execute dynamic SQL statements within PL/SQL procedures
  • support for Oracle database objects
  • event-based reporting (report execution based on database events)
  • seamless integration of Oracle Reports with Oracle Portal for administering report security and publishing report output to portlets

For more information, refer to the Oracle Reports online Help (select Help > Contents in Oracle Reports Builder), and the Oracle Reports Building Reports manual.

1.1.2 Oracle Reports Bridge

Oracle Reports Bridge (rwbridge) provides functionality for discovering a Reports Server across farms. For more information, see Section 2.3.4.1.2, “Server Discovery Across Subnets”.

1.1.3 Oracle Reports Client

Oracle Reports Client (rwclient) provides a command-line interface to send a report to a remote Reports Server (rwserver).

1.1.4 Oracle Reports Runtime

rwrun (Reports Runtime) runs a report by starting its own in-process server (not to be confused with the default in-process Reports Server), which runs in the same JVM as the rwrun process. The configuration file for this in-process server is rwbuilder.conf and trace files are saved in the rep_machinename-rwbuilder directory.

Note:

It is recommended that you use rwrun for testing purposes only. Use rwservlet and rwclient in your production environment to take full advantage of the power of Oracle Reports Services.

1.1.5 Oracle Reports Servlet

Oracle Reports Servlet (rwservlet) is a component of Oracle Reports Services that translates and delivers information between either a Web Server or a Java EE Container (for example, Oracle WebLogic Server) and the Reports Server, enabling you to run a report dynamically from your Web browser.

1.1.6 Oracle Reports Server

Oracle Reports Server (rwserver) is a component of Oracle Fusion Middleware that provides reporting services to execute, distribute, and publish your reports for enterprise-wide reporting. This component processes client requests, including user authentication, scheduling, caching, and report distribution. Use Oracle Reports clients such as Oracle Reports Servlet (rwservlet), Reports JSP, and Oracle Reports Client (rwclient) to send a report to Oracle Reports Server (generally referred to as Reports Server).

Reference : http://docs.oracle.com/cd/E15523_01/bi.1111/b32121/pbr_intro001.htm#CEGIFHGJ

What is Google Map Maker?

Google Map Maker allows you to add and update geographic information for millions of users to see in Google Maps and Google Earth. By sharing information about the places you know, like businesses in your town or places in your school campus, you can ensure the map accurately reflects the world around you. Your updates will be reviewed and once approved, will appear online for people from all over the world to see.

You can make edits using Google Map Maker over 188 countries and regions around the world. Start mapping today!

What is map maker satellite view

With Google Map Maker, you can:

  • Add places of interest such as your local restaurants, cafés, schools and more.
  • Edit and update details for existing places.
  • Help avid hikers by mapping trails, be it for a casual walk or an adventurous trip!
  • Get driving directions and also help in making them more accurate.
  • See what your peers are mapping in specific areas.

Getting to know Map Maker

Here’s the basic layout of the Map Maker interface:

 

Names of top contributers in view port

 

 

 

 

 

  1. Viewport: The viewport displays the map that you’re working on. This is where you can add, edit and review features. You can use the navigation controls to zoom in and out or move around the map, and switch between Map and Satellite views. To view stats for top contributors to an area, hover your mouse pointer over the contributors’ names in the right bottom corner of the viewport.
  2. Street View: An orange pegman Orange Pegman indicates that Street View is available; a grey pegmanGrey Pegman indicates that it’s not available. The lower right corner of the viewport has a Street View preview.
  3. Top menu bar: After you’ve signed in, click the gear-shaped icon in the upper-right corner to display links to your Profile and Settings pages. You can also find links to Labs features, the Discussion Forum and the Help Center.
  4. Toolbar: The toolbar is enabled when you zoom in to a particular area. Use it to add features such asPlacesShapes and Lines. You can also use it to find and edit features.
  5. Left panel: Displays information about updates, edits and directions related to the current action you’re performing. Learn more about the left panel workspace.
  6. Searching tools: The search box, along with Browse and Advanced Search will help you find businesses, schools and other places of interest. Learn more about searching.
  7. Location bar: Displays your current location based on the area represented by the viewport. You may need to zoom in to view this information.
  8. Getting Started tool: Click  for guided instructions on how to add, edit, find features and more on Map Maker.

Reference : http://support.google.com/mapmaker/bin/static.py?hl=en&page=guide.cs&guide=30028&topic=1094318&answer=157176