>hi there colleagues, I need some help here. I'm using seagate crystal reports and I wanna change the sql statement used in the report

Angel,

What I personally do is use Crystal's RDC application and report objects. The application object is CrystalRuntime.Application and the report object is CrystalRuntime.Report. Once the report object is instantiated with the report I'm working with, I modify the object's SQLQueryString property (e.g. oReport.SQLQueryString = cSQLStatement).

Laterness,
Jon