Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Overview of this book

Table of Contents (26 chapters)
SAP BusinessObjects Dashboards 4.1 Cookbook
Credits
Foreword
About the Author
Acknowledgments
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Displaying raw data


If you want to display numbers and text without a chart, but just in a table, you can use the Spreadsheet Table component.

Getting ready

Open a new SAP BusinessObjects Dashboards file and enter the data, as shown in the following screenshot, into the spreadsheet:

How to do it...

  1. In the spreadsheet, select cells A4 through E4.

  2. Add a Bottom Border by using the Borders menu in the Font section of the Home tab in the spreadsheet:

  3. Select cells A4 through A7 and add a Right Border.

  4. Drag a Spreadsheet Table component into the canvas.

  5. Bind the Display Data field with the spreadsheet range from A4 to E7.

  6. Go to the Behavior tab and deselect Row in the Row Selectability section.

  7. Go to the Appearance tab and deselect Show Gridlines in the Layout sub-tab.

  8. The dashboard should now look like what is shown in the following screenshot:

How it works...

The Spreadsheet Table component shows a range of cells exactly as they are formatted in the spreadsheet. You can add borders and colors, change fonts...