Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed



follow us on Twitter

Marketplace Partners
Be a Marketplace Partner

internet.commerce
Be a Commerce Partner


















Mariposa Bot Shipped With Vodafone Smartphone

IT Job Market Heating Up: Report

Bing Makes Strides But Momentum Stalls

internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers


Database Journal | DBA Support | SQLCourse | SQLCourse2







Related Articles
Introducing Reporting Services Charts for Analysis Services
Simple Column Chart for Analysis Services Data

Finance Developer (IL)
Next Step Systems
US-IL-Chicago

Justtechjobs.com Post A Job | Post A Resume

Featured Database Articles

MS SQL

December 30, 2008

Simple Bar Chart for Analysis Services Data

By William Pearson

Procedure: Create a Column Chart within the Report

Add a Chart Control to the Report Canvas

At this point, we will drag the Chart item from the Report Items listed within the Toolbox pane (the position of which is defaulted to the left of the Layout tab). Once the general control is placed on the report canvas, we will adjust it, setting properties as appropriate to meet the report specifications.

1.  Select View from the main menu.

2.  Select Toolbox from the menu, which appears as partially shown in Illustration 7, to place the Toolbox within easy reach (if it already appears, simply disregard this step).

Calling the Toolbox to View (Partial View Menu Shown)
Illustration 7: Calling the Toolbox to View (Partial View Menu Shown)

The toolbox window should appear similar to that depicted in Illustration 8. Mine is pinned to the upper left corner of the design environment, where I find it most convenient. This is, of course, subject to your own choices. (Note also that I dock my Fields and Server Explorer panes in this area to maximize design real estate, as an aside.)

Toolbox, Pinned to the Upper Left Corner of the Design Environment
Illustration 8: The Toolbox, Pinned to the Upper Left Corner of the Design Environment

3.  Click the Chart item (at the bottom of the Toolbox pane).

The cursor becomes a small chart icon in combination with crosshairs when held above the report canvas. This indicates that we can click to “anchor” the point, from which we wish to draw the box that the chart will inhabit.

4.  Click on the canvas, below the existing matrix, approximately as shown in Illustration 9.

Placing the Chart Selection onto the Report Campus
Illustration 9: Placing the Chart Selection onto the Report Campus ...

The chart item appears, in its generic manifestation, as depicted in Illustration 10.

Generic Chart Item Appears
Illustration 10: The Generic Chart Item Appears

NOTE: Should you accidentally place or drop the chart item into a position that is not satisfactory, you can simply move the item by clicking inside the chart item, then pointing to the now shaded border of the chart item, to drag it to a new location.

Clicking again on the border will also allow you to expand / contract the chart shape. (The nuances are easy to learn with a little practice.) Double-clicking the chart item will make the “drop regions,” seen above, appear.

5.  Pass the cursor over the left border of the chart item, until it becomes a four-arrow icon.

6.  Click and drag the chart item to the left side of the report canvas.

7.  Pass the cursor over the right border, and over the small square that appears about midway down the right side, until the cursor becomes a simple double-headed arrow.

8.  Click and drag the right border of the chart item, widening the chart (along with the underlying canvas) to approximately the “11” point on the ruler appearing atop the Layout tab.

9.  Click and drag the bottom border of the chart item, widening the chart downward (along with the underlying canvas) to approximately the “7” point on the ruler appearing along the left side of the Layout tab.

The chart item is now in place, and we are ready to specify its “simple Bar chart” nature, as well as to populate it with the primary dataset that is already in place.



Go to page: Prev  1  2  3  4  5  6  7  8  9  Next  

Tools:
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
IE 7 | Firefox 2.0 | Firefox 1.5.x
Receive news via our XML/RSS feed

MS SQL Archives








Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
Inner and outer select mussab 2 March 10th, 04:16 AM
SQL server 2008 in windows 7 pro problem theresatan 2 March 6th, 08:35 PM
code for re-build index and shrink db or file? mib 7 March 5th, 08:50 AM
sql maintenance plan fails database missing tbrownch 3 February 24th, 08:53 AM









The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers