You can sort a group in either ascending or descending order. Choose the option Get Info. Right-click in an empty area on the right side of. This knowledge base article explains how to pass the dossier’s filter selected elements to answer the prompt of a target report service document using URL API. Go to the Report -> Data->Intelligent Cube Options->Point grid to. Define the sort to be performed by DATE in the Criteria column: Save and close the report. For example, if you want to send reports via email, and your recipients use an email client such as Microsoft Outlook, you can create a. 4. This chapter describes how to create these types of objects. We then created a report in either web or developer with our new banding metric along with any desired attributes or metrics we want in our documents detailed section (we chose profit and customers from tutorial for our example)Creating and Managing Devices. It is used to format data from multiple reports in a single display of presentation quality. Design and Administration Guide: A Platform for. See the Dashboards and Widgets Creation Guide for steps to create selectors. Right-click the header of the attribute whose elements you want to use to. To execute a report or document, a user must have Execute access to all objects on the report/document. Microstrategy. Resources Documentation MicroStrategy provides both manuals and online help; these two information sources. The Select Bursting Criteria options are displayed. Report designers can read detailed information with examples on how to create report objects and design reports, in the Advanced Reporting Guide. The Dashboards and Widgets Guide contains instructions for designing and creating MicroStrategy Report Services dashboards, a type of document that is optimized for viewing online and for user interactivity. MicroStrategy Report Services Document Creation Guide. Reports . A MicroStrategy Report Services document contains objects representing data coming from one or more reports, as well as positioning and formatting information. MicroStrategy Product Manuals, MicroStrategy. What You Can Do in It. To access the MicroStrategy Installation Wizard. A portable document contains all the design of the document without the data, allowing you to copy documents between projects, even when the projects do not have the. The following steps would allow users to create an information window that is triggered by clicking on a neutral “button”. )The grid height made be changed to 0. A MicroStrategy Report Services document displays your organization's data in a high-quality, Pixel Perfect display. 5. Click the Enterprise Reporting Documents folder. 3. A device specifies the format of a MicroStrategy report or document and the transmission process to send the report or document to users who subscribe to that report or document. To view a document in Presentation Mode, do one of the following: . For information on MultiSource, see the Project Design Guide. 2. How to Create a Print Button for Flash View Mode within a Report Services Document using the. In MicroStrategy Web, open the document to import layouts into, in Design Mode or. 1, Microstrategy Intelligence Server 8. Version 10 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version shown i Universal, MicroStrategy Office, MicroStrategy Data Mining Services, MicroStrategy Narrowcast Server, MicroStrategy Health Center, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Developer, MicroStrategy Web Professional, MicroStrategy Architect, MicroStrategy SDK, MicroStrategy Document Creation Help. You can also select multiple reports at the same time to create a multi-layout document (see Creating a document from a report for instructions and Creating multi. STEPS TO REPRODUCE: Create a report services document. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk. In the Subscription Editor, click Burst…. Place the second grid right below the first. From Design Mode or Editable Mode, click the Presentation Mode icon . To access the Template Editor, execute the following: From the File menu, go to New and choose Template. Web To Create A Bubble Grid Widget, See. For instructions, see the Report Services Document Creation Guide . When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. ; Enter the XQuery statement required to connect to the third-party. Click any report you wish to execute. This particular workflow is a template that is delivered out-of-the-box with System Manager. 4. MicroStrategy Report Services Document Creation Guide プロジェクト デザイン ガイド: MicroStrategy Project Design Guide MicroStrategy 関数リファレンス: MicroStrategy Functions Reference MicroStrategy Mobile 分析ガイド: MicroStrategy Mobile Analysis Guide MicroStrategy Mobile デザインおよび管理 ガイド. Dashboard AnalysisGuide, which provides abasic understanding of how to manipulate the data in a document or RS dashboard to analyze business information. CONTENTS OverviewandAdditionalResources vii Aboutthisbook viii 1. 1. Create a Risk Management Framework; Phase 2. This document provides the steps to accomplish the same. Report Services documents are an excellent source of summarized data from related areas of analysis. x report. It is used to format data from multiple reports in a single. Connection to databases, Excel files, and text files is described in Connect to Databases, Excel Files, and Text Files. For example, you can use a Report Services document or dashboard from the MicroStrategy Tutorial project in your own project. (A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. The text field for new notes closes, and all the existing notes become active. Add Region and Category to the rows and Revenue to the metrics. Upgrading Platform Analytics. The metadata also stores the definitions of all objects created with MicroStrategy Developer and Web such as templates, reports, metrics, facts, and so on. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document. EN. A Report Services document of this type is a visually intuitive display of data that summarizes key business indicators for a quick status check. You can use MicroStrategy Web to create a Grid/Graph that contains. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document designers understand how end users will use. 1 and was defined to display in Flash Mode. 1. On the Freeform Sources tab, select Create Freeform SQL report. It discusses the features and workflows RSDs inherit with this. Notice only half the metric displays without wrapping. Visual Insight dossiers are interactive displays that you can use to quickly and easily explore your business data. Lookup table for the Cache Creation indicator. Edit the Item Order Form report. Create a Report Services Document 2. 0 Reviews. 3. To burst a file subscription across multiple files. EDW Analysis & Design. MicroStrategy allows to pass selector values across Report Services documents using Edit Links. ; Click OK. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. . x, with the Intelligence Server running on Linux, the image in the. In a document, you can display a report by adding a Grid/Graph to the document. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Note: You can also set-up Cover Pages by using APIs. Create a dossier using the base report created in Step 1. You can create an indented grouping of related data on a grid report or a Report Services document by organizing the data into a standard outline style. exe -w C:filename. Locate and run the Setup. Run this to Interactive mode and notice that all three metrics appear with Revenue and Profit on the Y1 axis and Random Number on the Y2 Axis. 3. MicroStrategy Office, MicroStrategy. x and 10. High-quality, Pixel Perfect documents allow you to display your business data in a user-friendly way that is. When subtotals are enabled on a Microstrategy Desktop report, attributes in a page-by are defaulted to display "Total" as the last option in the drop-down box. Refer to the Advanced Reporting Guide for more information on Transaction Services reports. The following auto text codes allow you to add document variable information to your document. Report Services documents are an excellent source of summarized data from related areas of analysis. 2. In Design Mode or Editable Mode, right-click on column in grid that should be a selector. Click the three dots toggle on the top right of the above text box, select Create Links. About HTML documents. Add data to the report and leverage formatting capabilities in the modern Library interface. Documents and dashboards can appear in almost as many ways as you can imagine and are generally formatted to suit your business needs, in a single display of presentation quality. Type over the existing text or add new text. Create a Report Services Document 2. Samples of each type of application object are located in the Public Objects folder in the Tutorial project. Displays or hides the. Select the 01 Blank Dashboard template. If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. A MicroStrategy Report Services document contains datasets from one or more reports. It is necessary to disable the report cache or add the following code to refresh the Report services document. Create a selector on metrics, targeting the graph in step 3. See the Basic Reporting Guide for steps to creating reports. Click on Browsing Options and `Display hidden objects. Report and document objects: Reports (and documents, if you own MicroStrategy Report Services) are built from application objects. View the report as a grid and the graph. 1, Microstrategy Intelligence Server 8. Save the dossier. However, In this instance only two datasets will be utilized, in order to create a separate worksheet for each dataset. At this stage, all metrics are available in both S1 and S2, but the order is different. Save the report as R1. For steps to enable a bubble grid widget as a selector, see. Use the Blank Document template to create a traditional document. evt. Follow the steps below in order to create a new report template that can be used when creating new reports in MicroStrategy Developer or Web: 1) In MicroStrategy Developer, log onto the desired project. documentID. You can also access the Item Order Form document in the Tutorial project to review each component of the document, and refer to the Report Services Document Creation Guide for steps to create a document. . For details on these types of reports, see the MDX Cube Reporting Guide and the Advanced Reporting. In a document, you can display a report by adding a Grid/Graph to the document. When user selects nothing, both text box will be hidden so nothing displayed. Samples of each type of application object are located in the Public Objects folder in the Tutorial project. Dossiers automatically adjust to look great on any screen. First up, Report Services Documents (or just “documents”) continue to remain an essential part of the MicroStrategy portfolio. Dashboards, which are a type of document, provide a lot of interactive. The retail store sells electronics, books, movies, and music. 3. 2. Create a grid report in MicroStrategy Web 9. Document Creation Guide for MicroStrategy 10. Design and Administration Guide: A Platform for. Create a new document. BOOKOVERVIEWAND ADDITIONALRESOURCES Thisguideistheprimaryresourceforyoutousetolearnaboutdesigningandcreating MicroStrategydashboards. 4. MicroStrategy Report Services, the enterprise reporting engine of the MicroStrategy BI platform, enables the creation and viewing of pixel perfect, highly formatted documents, scorecards, and dynamic dashboards. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 1The Report Services Document Creation Guide contains instructions to design and create Report Services documents, building on information in the Basic Reporting. Execute the report and notice how users are unable to see the date range filter for this report: Add the report as a dataset to a new Report Services Document . MicroStrategy Web 9. Click OK. This data is positioned and formatted, resulting in a single display of presentation quality. To add a dataset. 4. 5. Excel: This allows the user to export the document to Microsoft Excel in . All articles. The data from the report is used to populate the Grid/Graph. Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. For steps to enable a bubble grid widget as a selector, see. 3. For documents, links are functional in Interactive Mode and Editable Mode in MicroStrategy Web. Out-of-the-box S3 connector was unable to fulfill those requirements (file type, authentication method, merging. 1m - MicroStrategy Product Manuals 2011-12-20 Learn Power BI - Derek Wilson 2020-10-15. Document Creation Guide This guide is the primary resource for you to use to learn about designing and creating MicroStrategy Report Services documents using. Avoid Duplicated Datasets. vii Creating an attribute based on existing objects: Derived attributes. MicroStrategy Mobile overview. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. For information on connecting to databases, see Connect to Databases. Certain situations may prevent users from using this feature, such as: 1. MicroStrategy Report Services Document Creation Guide For more information on the Height can shrink and Height can grow options, see the Document Creation Guide. Turn on Dossier Cache. In MicroStrategy Web, edit or execute a report. If the document is already open in Design Mode, click the Editable Mode icon . To print a MicroStrategy Web report: 1. 4 • You can add multiple layers on a Google map widget by inserting datasets into the document. There are various applications of MicroStrategy. It is used to format data from multiple reports in a single display of presentation quality. As with any MicroStrategy report, corrections will be reflected in the report on the following day. Once data flows into the interface, the dashboard will come to life. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. When 'Save Options' appear, choose the first option, as shown. You can also select multiple reports at the same time to create a multi-layout document (see Creating a document from a report for instructions and Creating multi-layout. Version 9. 9-10. 3. This document describes how to show a grid in a Report Services Document in several columns in MicroStrategy 9. RWBean. 1. 2. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks Learn how to use MicroStrategy OLAP Services to enhance your data analysis and reporting capabilities. The following code snippet will execute the Report Services Document, loop through the elements in the page by and export each available element to PDF public static void executeDocument() throws Exception { //Create connection with the Intelligence Server: iSession = createSession("localhost", "MicroStrategy Tutorial", "administrator. Limit the Use of Derived Attributes or Metrics. You can access document features such as inserting a Grid/Graph or formatting a text field using the toolbar options in the Document Editor. Go to Widget properties and match each. 1 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version showAs document designers create documents, they specify the data that appears and control the layout, formatting, grouping, and subtotaling of data. For steps, see Starting MicroStrategy Web. This section describes the ways in which you can design and create a MicroStrategy Report Services document. As seen below, in order to create a MicroStrategy Report Services document, choose a new 'Document. A MicroStrategy Report Services document displays your organization's data in a format that is similar to a PowerPoint presentation, where several grid and graph reports can be viewed at the same time, along with images and text. To add a Freeform SQL report as a shortcut-to-a-report qualification in a standard report, open the standard report in MicroStrategy Developer. You can: View the results of the document. Documents and dashboards allow you to display your business data in a user. A MicroStrategy report job can submit one or more queries to SQL DW. Put the attributes Business line, Category in the grid along with the metric sales. In general, report creation in MicroStrategy is. For information on integrating MDX cube sources into MicroStrategy, see theMDX Cube Reporting Guide. Execute the grid, and change the results to display in Outline mode, as shown below: Save the report and exit to the folders. A multi-layout document contains multiple documents, each in its own layout, creating a "book" of documents. The Dashboards and Widgets Guide contains instructions for designing and creating MicroStrategy Report Services dashboards, a type of document that is optimized for viewing online and for user interactivity. Preview Feature: Create and edit reports with your favorite features including the Advanced Properties panel, View Filters, SQL View, and many more. For issues related to Workstation connecting to the Intelligence Server, ensure that the Workstation version is the same/or compatible with the Intelligence Server environment. Uncheck the option “Enable report drilling” and select OK. Client: Confidential, November 2006 –August 2008 Location: IndiaIn-Memory Analytics Guide for MicroStrategy 10 OLAP Services Guide for MicroStrategy 9. Browse and incorporate these templates into your own data dashboards. You can modify the appearance of an HTML document, just like any other HTML page, to include text, images, hyperlinks, tables, and one or more report objects. Toolbar Options. 5. Computing & Internet · 2015What is report service document in MicroStrategy? A MicroStrategy Report Services document displays your organization’s data in a high-quality, Pixel Perfect display. This section covers design information thatis specific for reports and documents that are intended to beused on a BlackBerry. Documents allow you to showcase your business data in a user-friendly, boardroom-quality way that is suitable for presentation to management. These. ) In the example shown below, the rectangles on the bottom use gradient colors,. This procedure assumes that the Transaction Services report that you want to link to the Grid/Graph, text fields, or transaction table has already been created. xlsx as an example data set. Web the dashboards and widgets guide contains instructions for designing and creating microstrategy report services dashboards, a type of document that is optimized for. Creation Guide for MicroStrategy 9. Report Services document • 2: Visual Insight dossier: IS_DRILL_IND. x Report Services Document Creation Guide Book 2 Adding Script and Data to Documents. A MicroStrategy Report Services document displays your organization's data in a format that is similar to a PowerPoint presentation, where several grid and graph reports can be viewed at the same time, along with images and text. Display Mode. Go to the Data menu and notice that the Prompt Ordering option does not appear, as shown below:Hee-Wei Tan (Inactive) · May 1, 2017 ·. All rights reserved. Displays or hides the All Objects panel. Measuring the Performance of Public Services 2012-02-02 Michael Pidd Shows how the principles,. x-10. The document is displayed in Presentation Mode by default. Open Workstation in smart mode. Execute R2 and right-click on the Year attribute. The new template should be viewable when prompted to choose a document template while creating a new Report Services document, as shown below: Published:. Is it possible to prevent the delivery of reports and documents that do not return any data as a report-level setting in MicroStrategy Distribution Services 9. To not create messages for documents when they are. A document can be grouped and sorted using fields from the primary dataset only. Examples of documents include scorecards and dossiers, managed metrics documents, production and operational documents, and more. This report must contain the input object for each value that you want to allow users to change. Using grids and graphs as selectors in MicroStrategy Report Services Documents KB485724 | Knowledge Article | 81 Views | Oct 19, 2022 This article. CONTENTS BookOverviewandAdditionalResources vi 1. Web dashboards and widgets creation guide. MICROSTRA microstrategy. Create a graph that contains 1 attribute and 1 metric. (For details on Information Windows, see the Mobile Design and Administration Guide. Under General go to the server section. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. In a Report Services document, a user may want to create a calculation on the fly that uses simple arithmetic operators in combination with metrics from multiple datasets in a document. 3. Excel: This allows the user to export the document to Microsoft Excel in . For example, these reports go from basic execution pointers, quarterly deals by item. 1 To ensure that…In MicroStrategy 10. Star schemas have a de-normalized data structure, which is why their queries run much faster. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Right-click the grid, then select Properties and Formatting. Enable MicroStrategy Office and Web Integration. 4 10. 4. Click the down arrow next to data > choose "Hide nulls/zeros" to enable the hide nulls/zero option. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services. By bringing these different types of reports together inside a document, report designers can create rich reports and analytics that take advantage of. 1. Users must also have the Execute permission for any reports to be tested. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks MicroStrategy Analytics Desktop User Guide Contents © 2016 MicroStrategy, Inc. Reporting Guide. Starting in MicroStrategy 10. Toolbars are mostly divided by workflow—the Insert toolbar, for example, lists the different. Insert a new grid which contains the attribute and all metrics from M1 and M2 groups. For more information on grouping and sorting documents, see Grouping records in a document and Sorting a document. 3. MicroStrategy Web users that are licensed for MicroStrategy Report Services can view and interact with a document in Flash Mode, if the document was created before MicroStrategy 10. Step 1. The New Grid dialog box opens. 1 users are unable to undo changes made on a Report Services Document after exporting, printing or saving. Opens the report in PDF format. MicroStrategy provides a detailed document of its technical support policy and procedures, covering topics such as support liaisons, service levels, escalation process, and maintenance fees. Push-Down Derived Attributes for Live Connection Cubes. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document designers understand how end users will use. It builds on the basic concepts about documents presented in the Document Creation Guide. The following steps describe how to create a link to a MicroStrategy Web report in a document so that users can click on the link to execute the report. Instruction steps: Create a dossier, insert a text/image box. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. Drag the dataset to grid into document. Report Services Document Creation Guide: Creating Boardroom Quality Documents Version: 9. To measure the time spent in these components, refer to the following resources: Intelligence Server and Client. A wide Report Services document will display on multiple pages when in PDF view event the it was design to display everything on one row/page. To reproduce this issue in MicroStrategy Tutorial, follow these steps: Create a report with Employee, Manager, Year, Month, and Revenue. Web Document design: Create a document page, access Design Mode for documents, and perform WYSIWYG editing of documents in Flash Mode. In Design Mode, a document designer adds widgets to a document and defines them. Dashboards usually provide interactive features that let users change how they view the dashboard's data. Then go to “Widget” and set as DHTML-Survey. After placing data fields into any section, click Save. You can also create links in documents. At the Project Level: In the Project Configuration Editor, under Caching -> Result Caches-> Creation, select the setting called "Enable Document Output Caching in Selected Formats" along with the desired output formats, as seen below: A separate section called. In the Property List Window, set the 'Hide if empty' value to 'True. Users determine what information they want, when and how they want to receive it, through an easy to use web page. 4. For example, the HTML container in the following document uses a URL to display the MicroStrategy Resource Center website. Answer: Go with dossier. refresh(false, true); The example provided in this document is provided “as-is” and user has read the following customization warning:Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. Repeat Steps 3 through 6 using a second grid that displays 'Profit'. Understanding and working with document sections. Notes. 1. A red border displays around the Grid/Graph, indicating that it is in edit mode. Create a metric selector S1. Rather, the totals are displayed for each grouped-by attribute and are shown at the bottom of each separat grid. Right click on the grid and go to “Properties and formatting”. How to save the expand / collapse state in outline mode in a Report Services Document for MicroStrategy Web 10. Performance Implications of Large and Complex Dossiers. Dashboards and Widgets Creation Guide Creating Interactive Dashboards for your Data Version: 9. MicroStrategy Report Services Document Creation GuideA MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. For information about creating selectors, see the Report Services Document Creation Guide. The Report Services Document Creation Guide contains instructions to design and create Report Services documents, building on information in the Basic Reporting Guide and Advanced Reporting Guide. Below are instructions to achieve this in a Report Services Document. 3. In MicroStrategy Developer 9. 3, March 2016 To ensure that you are using…It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. 4. 3. To view a document in Presentation Mode, do one of the following: . -1: Email: Limits the number of reports or documents that a user can send to an email address at a time. Default Content Alignment(Presentation Mode Only): This option allows the user to choose center or top left alignment for the content of a Report Services document when it is displayed in Presentation Mode. When you create a document, you can specify the data that appears, control the layout, formatting,. Add the filter to the report. 1m. IS_CACHE_HIT_TYPE. Data can be connected through an API, flat file, or database. 2 Click the project to log in to. Create a Report Services document using R1 as the dataset, drag the grid into the detail header, and execute the document in PDF view. Without data, the dashboard will not show the user anything. Other examples in this book use the Analytics Modules, which include a set of precreated sample reports and documents, each from a different business area. ' In order to create an HTML document, choose a new 'HTML Document. An HTML document is an HTML container for formatting, displaying, and distributing multiple reports on the same page, or at the same time within a project. Apache Kafka is an open-source distributed event streaming platform used by thousands of companies for high-performance data pipelines, streaming analytics and data integration. Document designers also create Report Services (RS) dashboards, as described in Designing dynamic enterprise RS dashboards. SERVICE GUIDE UPDATE PUBLISHED FEBRUARY 2023. 1m Creating. The report is added as a Grid/Graph (an object that acts like a standard MicroStrategy report) in the Detail Header of the new document (see Creating a document from a report). For steps, see the Basic Reporting Guide. Creating and modifying Report Services documents. Create a new Document in MicroStrategy Web 9. Designing and creating documents: An overview. Report Services Document Creation Guide: Creating Boardroom Quality Documents Version 10. reporting functionality can be found in the MicroStrategy Advanced Reporting Guide. Save and close the report. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. To Create a Report from Scratch. MicroStrategy Report Services documents offer dynamic functionality and the flexibility to design documents with headers/footers, filters, and prompts. Use this guide to learn about designing and creating MicroStrategy documents using MicroStrategy Developer. You can use MicroStrategy Web to create a Grid/Graph that contains objects from multiple dataset reports. From the left, click Grid. 3.