Single SQL for Multiple Squential Reports

[GreatDreamer]

I have 3 sequential reports. All three are using the 3 separate sql that are the same. I would like to have 1 sql and have 3 separate reports use the 1 sql. Does anyone know what is the best approach is. Be detail as possible. Thanks

 

[johnberchmans]

The sample report in the
C:\Program Files\Actuate7SP2\ErdPro\Examples\DataAccess\ReuseQuery folder might help you.

-- JB

 

[dhanuss]

create a report section that just contains the Datastream and Datarow with required SQL. Declare a global acMemoryBuffer or acRecordbuffer variable. Assign the Datasource to the variable in the report finish method and use the rewind method of the variable. you can use this global variable in subsequent Sequential reports. you can assign this variable in each reports obtaindatastream method. Just try to explore. if you still can not get it.
send me an email. dhanuss@hotmail.com
Thanks
jay