Siebel Reports Administration Guide > Creating a Simple List Report > Additional Information for Developing and Deploying Siebel Reports >
About Using a Datastream Twice
Two sequential report sections can use the same datastream. However, this approach generates the following error message, Operation is not allowed on sql object in forward only mode. The workaround is to comment out the SetForwardOnly mode statement in the ROL's Fetch method. This approach will negatively impact the performance of the report. The datastream is read once each time it is executed.
Another approach is to retrieve the data once and store the rows in a global list variable that can be used as the datasource of subsequent report sections. The steps to accomplish this, with a few modifications, are described in Sorting Records in Memory.