Modify the FoodMart
this section, we will copy the existing FoodMart Sales report, and then
open it in Reporting Services' Report Designer, where we will begin the
modifications that the information consumers have requested.
a Data Connection for the FoodMart Sales Report
Our next step is to set
up a Data Connection. As we have noted numerous times throughout our
series, Reporting Services can connect with, and create the DataSets it
needs from virtually any ODBC or OLE DB-compliant data source (in
addition to the obvious MSSQL Server and MSAS data stores). .NET-based API's
add the potential for other data sources, assuming that you have a legacy, or
otherwise "alternative," scenario on your hands.
Let's set up a Connection
to support the DataSet within our practice example.
the Shared Data Sources folder underneath the new RS012 project
tree in the Solution Explorer.
New Data Source from the context menu that appears, as depicted in Illustration
Illustration 6: Select
Add New Data Source from the Context Menu
Link Properties dialog appears, defaulted to the Connection tab.
Click the Provider
tab, to select it.
OLE DB Provider for OLAP Services 8.0 from the Provider list box, as
shown in Illustration 7.
Selecting Microsoft OLE DB Provider
for OLAP Services 8.0 - Providers Tab
to move to the Connection tab.
In the Data
Source box, type the name of the server upon which MSAS resides (mine is MOTHER1
in the illustration that follows).
Type in the
server name again in the Location box.
appropriate authentication information to access the MSAS environment on the
server you have selected.
using Windows NT Integrated Security, as this is not a production
environment. For a production environment, selections here require careful
2000 in the list of data sources that appear when we click the down-arrow
selector button at the next box (and thus receive confirmation that our server
/ authentication information is adequate to display the sources) at the top of
the Data tab.
The completed Data Link Properties - Connection
tab appears as depicted in Illustration 8.
Illustration 8: Data
Link Properties - Connection Tab
Click the Test
Connection button to confirm connectivity.
Data Link message box appears, indicating a successful test, as shown in Illustration
Illustration 9: Testing
Positive for Connectivity ...
to close the message box.
to accept the settings we have made, and to close the Data Link Properties
established the data source, we are now ready to create a copy of the FoodMart
Sales sample report, which we will then modify to meet the expressed
requirements of the information consumers.