Scriptlets "maximum open cursors exceeded"

[hussainian]

Hi!

1.     I'm setting a variable in Report Scriptlet which is displayed in the page header. When I set the variable value in afterReportInit method, the variable is only shown on first page and null on the remaining. When I set the variable in beforeReportInit method, it is shown on all pages except first. And when I set it in afterPageInit, it is shown on all the pages. Can anyone please describe why do afterReportInit and beforePageInit not print on whole report?

2     I've a group in my report with both header and footer. In the case when the group's footer band is displayed on the first line of a page (group's header and all detail on the previous page), the above mentioned variable is not displayed (null) in the page header. Why is it so and how to counter this problem? I've tried putting variable setting statements in different methods. Putting these statements in Detail or Group related methods raises the "maximum open cursors exceeded" exception.

Muhammad AsadUllah.

 

[lucianc]

Variables whose values are set by scriptlets should have calculation="System".  Try that and see if it works fine.

Regards,

Lucian

[hussainian]

Yes, it did. Thanks Lucian.