Problem with letter report

[olu_guy]

Hi all,

 

I have designed a letter report using jasper reports that prints a two paged letter with some static and dynamic database content. i.e. the names, address, title etc all come from the database, the rest of the content are static. This works fine because I am only generating a letter for a single record (the sql query returns only a single reord).

 

The problem now is that I have to generate the same letter but for multiple records (i.e. sql query will return more than one record of name, address etc).

 

Since a letter for a single record takes 2 pages, I need the entire report in a single file but with each record starting on a new page (page break maybe ?) What I am getting now is the entire report together but the next letter starts after the previous one ends without starting on a new page.

 

Any thouhts ?

 

Cheers

[rsilverns.sympatico.ca]

I have done this same thing and have been able to implement it using groups and placing each "page" into the group header of the group.

 

So for 3 pages, I would have 3 groups, each with a Start New page = true option turned on. The expression for each group would be [$V{REPORT_COUNT} + "Page1"] (page2, 3 etc).

 

HTH,

Robin

[olu_guy]

Hi I'll have a go at using the description you gave. I not too good with using groups but I give it a go.