To achieve this I created a report with my query of a list with 100 sequential rows and put it in the Detail 1 and my static text in Detail 2.
Then I added: Print When Expression = $V{PAGE_NUMBER}%2 != 0 to Column Header and Detail 1 and Print When Expression = $V{PAGE_NUMBER}%2 != 0 to Detail 2 and also maximized Detail 2 Band Height (without this I will loose more rows)
Everything show in the right pages but report aren't showing all rows. I mean, if my query return 100 rows, 1-100
1st page show 1-20 2nd page show static text 3rd page show 22-40 4th page show static text 5th page show 42-60
I want to print a list on odd pages of the report and a static text on the even pages.
in Products
Posted
To achieve this I created a report with my query of a list with 100 sequential rows and put it in the Detail 1 and my static text in Detail 2.
Then I added: Print When Expression = $V{PAGE_NUMBER}%2 != 0 to Column Header and Detail 1 and Print When Expression = $V{PAGE_NUMBER}%2 != 0 to Detail 2 and also maximized Detail 2 Band Height (without this I will loose more rows)
Everything show in the right pages but report aren't showing all rows. I mean, if my query return 100 rows, 1-100
1st page show 1-20
2nd page show static text
3rd page show 22-40
4th page show static text
5th page show 42-60