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', l.name as 'Language' from mydb.film 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.