A report in Cluvio is essentially a query + visualisation, placed on a dashboard grid.
Report query is the way to obtain the tabular data from the datasource, plus the optional R script that can further transform the SQL query result data into the final result data.
The SQL query is perfomed by your SQL database, the R script is executed on the Cluvio backend servers.
The results of executing the SQL (+ optionally R) query are the tabular report data. These data are available at any time for download via the "Download CSV" function from the Report dropdown menu on a dashboard, or from the results section in the query editor. The report data are cached for 2 hours by Cluvio, so that dashboards display fast without putting too much load on your database for each display of the report. Unless the user specifically asks for current results (via Refresh action on dashboard or report), the cached data, if any, will be displayed. This means that a report would never show data that are older than 2 hours.
The final way the report data are presented to the user is the report visualisation, which is configured as part of creating/editing the report in the query editor. This step configures how the columns in the result data are interpreted, formatted and visualised as tables, numbers or charts once the report is placed on the dashboard.