Pageview report

Pageview allows you to view the data in a 'record' format. It is mostly used in cases where you have only one data row to be displayed. Instead of showing the data as a row, the format shows the data in a more readable 'record' -format (see picture below).

If we have a report that returns a single row the result might look something like this:

If the result contains multiple columns, it might be better to change the layout to use the Pageview-feature. We'll place the command select 'dbr.pageview'; in front of the actual dataset query, to turn the following result set's columns into rows. So adding the command:

select 'dbr.pageview';

select f.title as 'Title', 
       f.description as 'Description', 
       f.release_year as 'Release year', 
       f.rating as 'Rating', as 'Language'
from f
  join mydb.language l on f.language_id=l.language_id
where f.film_id = vID;

produces a result like this:

If the report produces multiple rows, each row is displayed as an individual record.