Monday, March 22, 2010

COGNOS 8 – Page Break on a Query


We created a report called Patient Statement. This report is actually a form that is set by the state as a standard, the specialty of this report is that; we need to design it in such a way that report the client should be able to print the report and post it directly through an envelope.
Let me explain it better. The form is designed such that when we will fold the report into 3 part, the address of the patient comes exactly @ the address area of the envelope. So the end-user, runs the report, prints it out and folds it into the envelope and it should be ready to post. (Basically reduce the labour work of finding the patients address and writing / typing it on the envelope each time). The other issue was the total for each page that should be at the bottom of the A4 page even though the number of claims or payments in the report varies. So we had to format the length of the page also.
We also needed to have only 1 patient per page. So in order to make this simple Page Break on the report, here are some steps to follow.
1. Create the list or crosstab
2. Go to the page explorer, and drag the ‘Page Set’ under the Page1.
3. Drag the Page1 under the Detail Pages (Under the Page Set1)
4. Drag the query item you want to page break on. Here in the above screen shot, you can see that I have tried to Page Break on Patient. I could have used only the Patient ID, but I was just playing around with the options. By adding multiple levels under the ‘Page Set’, we can actually break the page depending on all the condition we want to.
Such a simple but very useful option.
Look at the screen shot above to understand it better.

No comments: