Invalid set of rows requested,... reset pagination
194518May 2 2007 — edited May 3 2007Hi,
I get an "Invalid set of rows requested, the source data of the report has been modified reset pagination" error every now and then.
I have an application with a report (sql Query) in Page 1. This is a one column report which is a hyperlink (Column Link) to page 2. It passes two values(X1, X2) to Page 2. On page 2 I have a "Branch To Function Returning Page " in "Before Header" that looks into values of X1 and X2 and branches one of the several Pages (3 to 8).
All the pages (3 to 8) have reports based on SQL Query. Page 3 is a one column report, Page 4 is a two column report, Page 5 is a three column report and so on.
I get this error message when I try to access one of these pages (3 to 8). It happens randomly. If I click on the reset pagination link after the error message, then the page gets displayed properly. What is causing this? Any help is appreciated. Thanks in advance.
raje.