Change the data source for a chart, page, or report
You select a default data source when you first create a report. Every chart and control you add to the report gets its data from that data source, unless you select a different one. You can specify a data source for each chart, control, or page. You can also set a default data source for the entire report.
Change a chart's data source
These instructions also work for controls or other component's with data properties.
- Edit the report.
- Select a chart.
- In the selected component's Property panel, select the DATA tab.
- At the top of the left-hand panel, click the current data source name.
- In the Select Data Source panel, select an existing data source, or, at the bottom, click CREATE NEW DATA SOURCE.
- If desired, create the new data source.
- If prompted, click ADD TO REPORT.
- At the top of the Select Data Source panel, click the arrow to return to the properties panel.
What's the difference between "Attached data sources" and "Available data sources?"
The data source selector will usually show 2 lists of data sources: attached and available. An "attached" data source is one you've already added to the report. If you share the report with other editors, they can use any attached data sources, as long as they also have access to the underlying data set.
An "available" data source is one to which you have access, but have not yet added to the report. Sharing a report does not share your available data sources with other people.
Learn more about managing the data sources added to your reports.
Change the data source for the page or report
Setting a data source at the page or report level overrides the default data source you selected when you first created the report. New charts or components you add will use this data source instead of the default.
Set a data source for the current page
- Edit the report
- Navigate to the specific page (e.g. page 2)
- Select Page > Current page settings
- In the Current Page Settings panel, select the DATA tab, then click Select Data Source
- Select an existing data source or create a new one
- If prompted, click Add to report.
Set a data source for the entire report
- Edit the report
- Select File > Report settings
- In the Report Settings panel, click Select Data Source
- Select an existing data source or create a new one
- If prompted, click Add to report.