Cognos Error RSV-VAL-0032

This article explain how I got Cognos Error RSV-VAL-0032 and solved it.
In a report I have a filter on Date From. It works with a DatePicker Prompt. Often the client wants to print the report or view in PDF. When the report is started and no Date From is chosen, the parameter p_date_from is empty. So when I show this parameter in the report it is empty.
To solve that I created a report expression with the following case:

Continue reading

Page break in report

Case:

You want to build a report which shows salesdata per region and show every region on an new page.

Solution:

Create a table with branch, year and some fact data.

Click once on the column branch.

In the toolbar click on Structure > Page-break (with Master/Detail)

After that you can also click on ‘Section’. This way you create an header per page for Region.

See Section in report for more enhancement details.