Introduction to Datasets
In order to feed data to a Report Visual you must create Datasets. Each Dataset represents the result from executing a SQL query or SQL Stored Procedure connected to a data source. The columns in the result are usable as column headers in tables and/or as chart axes, whereas the resulting rows are the data for analysis.
- Datasets are required to create a Report Visual.
- A Dataset is fed from a SQL Query or SQL Stored Procedure
- A single Dataset can be used for one or more Report Visuals.
- SQL Query or SQL Stored Procedure should not have spaces in column names (you can add spaces to report names in order to enhance the user experience by going to the RockDaisy design panel of any item)
The Dataset’s query/stored procedure should be designed to only return the data needed to populate the report visual.
For example, to show Sales by Year in a Bar Chart tell your query to return one row for each year. It’s the query designer’s responsibility to aggregate the data within the query, as follows:
Adding a Dataset
Step 1: go to [+Add] -> ‘Dataset’
Step 2: Assign your Dataset Name
Assigning the Dataset definition for a Report Visual
Step 1: Click [+Add] -> Report Visual button
Step 2: Choose your existing Dataset
Changing the Dataset definition
Step 1: Go to your SQL Server and update the according stored procedure tied to the dataset (recommended).
Step 2: Within the RockDaisy window (in your browser) click Ctrl F5 or click the refresh button.
Step 1: Go to the Properties tab of an existing Report Visual and click the [EDIT] button next to the dataset dropdown.
Go to the Design/Preview tab and manually remove the column (CustomerId in this example) as depicted below: