Siebel Reports Administration Guide > Getting Started > Additional Siebel-Actuate Reporting Issues >

Using a Datastream Twice

Two sequential report sections can use the same datastream. However, this approach generates the "Operation is not allowed on sql object in forward only mode" error message. 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.


 Siebel Reports Administration Guide, Version 7.5, Rev B 
 Published: 18 April 2003