Skip to content

Reports built from a query ​

The quickest kind of report is one that was already built without anyone realising: a query, its results set up the way you want them, saved as it stands. This page describes how that is done, so you know what to ask for.

Reports are made by Paritor, not on your own database

Like queries, reports are maintained centrally while the features are still changing, so on your database there is no Save as Report and no New Report Design. This page describes how the reports you are given were built. If the report you need does not exist, ask us for it — it is then made once and every customer gets it.

Save as Report ​

On a query's results screen, arrange things first — choose your columns, filter them, and move to the Group By, Pivot or Visual tab if you want the data reshaped. Then use Save as Report.

You are asked for a name and description, and the report is saved.

What gets captured ​

  • The query it came from
  • The parameter values you ran it with
  • Which columns were showing
  • Any filtering you had applied
  • Whichever tab you were on — the plain results, a Group By, a Pivot, or a chart

That last point is the one to remember. A report saved from the Visual tab comes back as a chart; the same query saved from the Pivot tab comes back as a pivot. Get the view right before you save.

Editing one later ​

Edit Definition on the Reports list reopens the query results screen with everything restored — your columns, your filter, your transform, your parameters. Change whatever you need and use Save as Report again.

On your own database there is no Edit Definition for this kind of report

Since Save as Report is not there either, editing one would end on a screen that could not keep the result — so the button is not offered. If you need one of these reports altered, ask us: it is changed once and every customer gets the change.

A designed report is different: its Edit Definition opens the Report Designer.

This time the dialog offers a choice, because there is now something to replace:

  • Overwrite the existing report — the default, and what you usually want
  • Save as new — keeps the original and creates a second report alongside it

Saving from a plain query run offers no such choice, because there is nothing to overwrite.

TIP

Save as new is the safe way to experiment with a shared report. Make your variant, leave the original alone, and delete yours if it does not work out.

Where these differ from a designed report ​

A saved view is shown in the same results grid you built it in, so everything on Working with results still applies — sorting, the filter row, column totals, and Export to Excel or CSV.

What it does not give you is page layout. If the output has to be paginated, carry a letterhead, or be sent one section per person, you want a designed report instead.

Paritor - Winslade Park, Manor Drive, Clyst St Mary, EX5 1FY