This book is an excellent starting point in learning SharePoint The title is a bit misleading because it definitely does not cover EVERYTHING, but it is easy. Get a detailed look inside SharePoint —and master the intricacies of Dave is the author of the book "Workflow in the Microsoft Office System" and . Microsoft SharePoint Server Bible [Steven Mann] on bestthing.info and co-authored several books related to the subjects of SharePoint, InfoPath, and.
|Language:||English, Indonesian, Japanese|
|Genre:||Health & Fitness|
|ePub File Size:||20.86 MB|
|PDF File Size:||12.63 MB|
|Distribution:||Free* [*Sign up for free]|
Get a detailed look inside SharePoint and master the intricacies of developing Book. Not for sale. Sorry, this book is no longer in print. Summary: Read preview book excerpts from Inside Microsoft SharePoint Learn what's new with the SharePoint developer platform from. Read free book chapters about developing for Microsoft SharePoint To view book chapters relating to SharePoint , click the items to the.
Get a detailed look inside SharePoint —and master the intricacies of developing intranets, extranets, and Web-based applications.
Guided by an author team with in-depth knowledge of SharePoint architecture, you'll gain task-oriented guidance and extensive code samples to help you build robust business solutions. Discover how to: Critical Path Training Support Page: VM Installation Document registration required: If you find an error, you can report it to us through our Submit errata page. Sign in. Your cart.
New book: Business Intelligence in Microsoft SharePoint 2010
This eBook includes the following formats, accessible from your Account page after download: Downloads Follow the instructions to download this book's companion files or practice files. Click the Download button below to start the download. If prompted, click Save. The following example walks you through the steps to create a simple workbook that works with some of the filters you can add to the page in later sections of this chapter. Create the Excel Workbook The workbook creation process has two parts.
First you need to add a pivot table connected to OLAP data in Analysis Services, and then you can generate a chart from that data. To add a pivot table to a workbook 1. Start the data connection wizard in Excel, click the Data tab, click From Other Sources, and select From Analysis Services, as shown in the following illustration.
In the Import Data dialog box, choose PivotTable Report to create a new pivot table report in your sheet. In the PivotTable Field List dialog box, choose Sales from the topmost filter to see only those fields relevant for the Sales data.
Building Solutions for SharePoint 2010
This adds the primary data to the spreadsheet that we are working with. To add a simple chart to the workbook 1. Continuing with the same file you created in the preceding procedure, make sure your cell selection is located in the pivot table, and on the Insert tab, click Pie to choose a Pie chart. To format the chart so that it looks a little better in the report, move the chart and then grab its corner to resize it so that it fits next to your pivot table.
Optionally, choose a chart style that you like from the chart ribbon. You should now have a finished report that resembles the following illustration.
Save the workbook to SharePoint, and view it in a browser by using Excel Services. When you view the workbook on the server, make sure the pivot table refreshes and that all your data connectivity is working.
Prepare the Workbook for the Dashboard: Add Parameters Because the ultimate goal is to end up with multiple Web Parts on a dashboard page, you need a way to filter the data on the page at the same time. You can use a SharePoint filter to do this. A SharePoint filter is yet another Web Part on the page that takes a given value and sends it to other Web Parts on the page.
Then, based on the value provided by the SharePoint filter Web Part, the other Web Parts can change or filter the data they display. This simple mechanism enables users to choose a given value and then see all the different Web Parts on the page get filtered by their choice. Before configuring the Excel Services Web Parts so that they can be filtered, you need to make some simple modifications to the workbook file so that it can be filtered in the dashboard.
You must modify the workbook so that it can accept a filter value and recalculate based on that value. You do this by specifying workbook parameters.
A workbook parameter is a single cell in Excel that accepts input values when the file is loaded on the server. To specify a workbook parameter In the following exercise, the goal is to allow users to change the date filter for the pivot table.
First you need to give it a name. Note This exercise uses the same workbook you created earlier in the chapter. Now you can refer to that cell by name, which makes it easy to specify it as a parameter later. Click Publish Options as shown in the right pane of the preceding illustration to open the Publish Options dialog box, and then, to define the workbook parameters, click the Parameters tab, shown in the following illustration.
In the Publish Options dialog box, click Add to display the Add Parameters dialog box, shown in the following illustration, where you can choose which single-cell named ranges to add as parameters. Click OK to close the Publish Options dialog box.
Save the file in SharePoint. If you opened the file directly from SharePoint, you can simply click Save, or you can click Save As to overwrite the earlier version of the file. The workbook you just saved in SharePoint now allows users to set values in the DateFilterCell cell even if the workbook is in read-only or view-only mode.
Changing the cell value triggers a refresh of both the pivot table and pivot chart. From the Page tab of your browser, navigate to the Web Part page you created before. Remember that it might be in the Site Assets library of your site, depending on where you saved it. Pick a zone, and then click Add A Web Part to expand the top of the page so that you can choose which Web Part to add.
As shown in the preceding illustration, select Business Data in the Categories area, choose Excel Web Access in the Web Parts area, and then click Add to add the Web Part to the page in the zone you selected previously. To configure the Web Part Now you can configure the Web Part to display the workbook you created earlier.
SharePoint 2010 Book Excerpts
Under the Workbook Display area, click the blue button to browse for a workbook to display. A webpage dialog box opens, enabling you to navigate within SharePoint to pick a workbook. Use that dialog box to select the workbook you saved in SharePoint from the previous steps, or just type the URL to the workbook directly.
You should end up with a URL for the workbook you want to display, as shown in the following illustration. Scroll down to the bottom of the Web Part properties tool pane, and click OK. You should now see your workbook displayed in the Web Part, as shown in the following illustration.
Notice that the workbook looks just like an Excel file at this point.
You can click the sheet tabs, see the chart, interact with the pivot table, and so forth. You can control what the Web Part actually shows—for example, you can have it show only the chart. Click the drop-down arrow and select Edit Web Part, as shown in the following illustration, to open the Web Part Properties tool pane. In the tool pane, under Named Item, type in Chart 1.We publish new content continuously. Not for sale. SharePoint Quick Notes.
These will then be used in the design section of the chapter as checkpoints to ensure that the solution proposed addresses the issues discussed. To add a pivot table to a workbook 1. The following list describes some of the general processes that can be put in place, but to really make the most out of this solution, you will want to spend some time thinking about various processes that are unique to your organization and how your organization manages projects.
Each chapter is structured in the same way, allowing you to read about a particular business scenario, from the requirements to the solution.
You must modify the workbook so that it can accept a filter value and recalculate based on that value. Think about the people who have been there the longest.