Skip to content

From version 3.8.0

This page describes behaviour available from client version 3.8.0. Sites on an earlier version do not have it yet.

Saved reports

A saved report is a named set of filters for one screen. Saving keeps the choices made on the screen (what to group by, which suppliers, which period), never the figures. Opening a saved report puts those filters back and runs the screen again, so the figures are always current.

The control is the Saved reports button in the heading of each screen that supports it. It is the same control on every screen, and each screen has its own separate list of reports.

Screens that have saved reports

Screen Dates that can be saved Can be emailed on a schedule
Rebate Report Builder Report period Yes
Report Builder (turnover) Report period Yes
Turnover (the turnover queries list) Date range Yes
Insights (the BI dashboard) Reporting period No
Rebate dashboard Rebate, Scheduled and Paid periods, each on its own No
Rebate targeting None No
Product search None No
Data Quality None No
Agreement Browser None No

From version 3.8.3

Product search, Data Quality and the Agreement Browser have saved reports from 3.8.3. The other screens have them from 3.8.0.

A report saved on one screen cannot be opened on another.

What a saved report holds

  • A name (up to 255 characters) and an optional description (up to 1,000 characters).
  • The screen's filters as they were when it was saved.
  • For screens with dates, whether the dates are fixed or relative. Fixed dates always cover the exact period chosen. Relative dates are worked out again every time the report is opened, so a year-to-date report stays year to date. See Fixed and relative dates in saved reports.
  • Its owner: the person who saved it.

Results are not stored. This is why a saved report can be shared safely: the screen is run again for whoever opens it, with that person's own permissions, so two people opening the same report can see different figures.

Who can see a saved report

Report Who can open it Where it shows
Private (the default) Its owner, and administrators Under My reports in the owner's Saved reports menu
Published Every user of the site As a button in the Ready-made reports bar on the screen
Shared by link Anyone signed in to the site who has the link Nowhere for the person receiving it: they open it from the link
  • Only an administrator (a user with the admin role) can publish a report or remove it from the published list. See Publishing a saved report and setting the default view.
  • Administrators see every user's reports for a screen on the Manage saved reports page, and can rename, delete or publish them.
  • The owner or an administrator can change or delete a report. Anyone else who opens a published report and changes the filters can only Save as a new report of their own.
  • If the owner of a published report who is not an administrator updates it, it stays published.
  • Reports belong to one site. A link to a report does not work on another site.

Default views

A screen can open on a saved report instead of its built-in filters.

  • The default for everyone is a published report an administrator has pinned. One per screen.
  • My default is a report a user has pinned for themselves. One per screen for each person. It affects nobody else and does not publish the report.

When a screen opens it uses, in this order:

  1. the report named in the link, if the screen was opened from a saved report link;
  2. the user's own default;
  3. the default for everyone;
  4. the screen's built-in filters.

Clear and start fresh in the Saved reports menu puts the screen back to its built-in filters, not to the default report.

Sharing and email

  • A report can be shared by link. From 3.8.1 its owner can switch on Anyone with this link can view this report, and from 3.8.3 Share this view makes a link to the filters on screen without saving them under a name. See Sharing a saved report by link.
  • A private report with relative dates on the two report builders or the turnover queries list can be emailed to its owner every day, week or month. See Emailing a saved report on a schedule.

Why does a saved report change unexpectedly

  • The dates have moved. The report was saved with relative dates, which are worked out again on every open. A clock icon beside the name marks these reports.
  • The figures differ from a colleague's. Each person sees only the deals, suppliers and members their own permissions allow, whoever saved the report.
  • The screen opens on a report nobody chose. A default is set: either the user's own or the one an administrator pinned for everyone. The bar above the filters says Viewing "name" (your default) or (the default).
  • A warning says the relative dates could not be worked out. The rule stored with the report was unusable, so the screen used the fixed dates the report was saved with instead.
  • "That report isn't available to you. Showing your default view instead." The report was deleted, is private to someone else, or its link has been switched off. The message is the same in each case.
  • A scheduled email stopped. The report was published, or was saved again with fixed dates. Both cancel the schedule.
  • A setting on the Insights dashboard is not kept. The Group or member view is decided by who is looking, so it is not stored with the report.
  • The free-text search is not kept on the Agreement Browser.

What a saved report is not

  • Not a snapshot. To keep figures as they stood on a day, export the grid to Excel.
  • Not a scheduled task. Only the email schedule runs in the background; see the task scheduler.
  • Not a way round permissions. Publishing or sharing a report gives people the filters, never data they could not otherwise see.
  • Not the same as a browser bookmark. A bookmark of a saved report link works only while the report exists and the person may open it.

Audit trail

Opening, saving, deleting, publishing, sharing by link, scheduling an email and setting a default are each recorded in the audit trail, under the actions Open Saved Report, Save Report Definition, Delete Saved Report, Publish Saved Report, Share Saved Report By Link, Schedule Saved Report Email and Set Default Saved Report.