SQL Query Bar Chart and Data Table
Web Part Templates > SQL Query Bar Chart and Data Table

This Web Part selects sales by country from SQL and displays the results in a YUI Data Table and a Bar Chart. To use this, paste the source into the RSSBus Web Part source editor and edit the connection string and query values to refer to your own database.


Categories: Database, Charts and Maps

How do I use this Web Part?

It's as easy as copy & paste! Copy the SQL Query Bar Chart and Data Table Web Part source to your clipboard, paste that source into the RSSBus Web Part source editor, and click 'Apply'. Click on the details tab for more information.

Prerequisites

RSSBus Web Part Templates require RSSBus for SharePoint™ to be installed into your SharePoint Portal (MOSS) or SharePoint Services (WSS) Site. Some templates may also require additional connectors.

RSSBus SharePoint Web Part™

Getting Started with RSSBus for SharePoint™

Maybe the best way to get an idea of what the RSSBus SharePoint Web Part™ does and how it functions is to watch a quick video that describes the main features.

Trying to modify this template for a specific task?

We have qualified professionals standing by that can quickly go from your idea to a ready-to-run RSSBus Web Part Template. Contact us now: support@rssbus.com

Web Part Usage

  • Click the "Copy to Clipboard" button which is located in the "Download" tab.
  • If you haven't already, add a new RSSBus Web Part to your SharePoint page.
  • In SharePoint, on your new RSSBus Web Part properties pane, click the "Source Editor" button to open the editor.
  • Paste the clipboard contents into the RSSBus Web Part Source Editor and click "Apply".
  • The following inputs will be listed in the RSSBus Web Part properties pane, where you can set their values appropriately and click "Apply" again.

Web Part Inputs

Name Description Required
yaxistitle The y axis title. no
xaxistitle The x axis title. no
charttitle The chart title. no

Additional Requirements

This Web Part requires write access to the wpresources\charts\ folder. The formatted chart will be written to the charts folder and embeded inside the Web Part via the img tag.

Full Size Preview

Click here to see a full size preview of this Web Part.

Web Part Download

This Web Part requires the installation of the pre-requisite items listed below. If you already have these items installed, then you can download the SQL Query Bar Chart and Data Table Web Part to a file or copy the Web Part mark-up directly to your clipboard.

Want to learn how easy it is to create Web Parts like this one with the RSSBus SharePoint Web Part? You can view the Web Part source to review the mark-up that enables this Web Part.

Prerequisites

RSSBus Web Part Templates require RSSBus for SharePoint™ to be installed into your SharePoint Portal (MOSS) or SharePoint Services (WSS) Site. Some templates also require additional connectors.

RSSBus SharePoint Web Part™

Videos & Technical Resources

Find our more about how the RSSBus SharePoint Web Part can help you quickly and easily integrate your SharePoint sites with internal and external data sources including databases, applications, and services:

The Case For Simple Services
Discover RSSBus Simple Services™ and learn how to enhance current services architectures with highly flexible data services.

RSSBus SharePoint Web Part™ - Formatting with HTML
This video shows how to use RSSBus SharePoint Web Part to connect and retrieve records from a Microsoft SQL database, and format the Web Part output as an HTML table.

RSSBus SharePoint Web Part™ - SalesForce Web Service Integration
Integrate sales leads and customer data from SalesForce.com into your SharePoint site in under two minutes.

RSSBus SharePoint Web Part™ - Service Enablement
Use SharePoint Server as a Simple Web Services Platform. Extend SharePoint with Simple Services and use SharePoint to manage service accessibility.

RSSBus QuickStart Guide
A hands-on introduction to the concepts and usage of RSSBus Desktop and RSSBus Server.

RSSBus SharePoint Web Part - User Guide
A guide to calling Simple Services and feeds using the RSSBus SharePoint Web Part.