CRAXDRT.Report get Select statement

[deulyd]

Hi,

I have a report object and I need to update the Select Statement but I really don't know how to do that... I tried with the "SQLQueryString" but its always empty and is also read only.

Here my code :

'--------------------------------------------------
Dim crApp As New CRAXDRT.Application
Dim crRpt As New CRAXDRT.Report


Set crRpt = crApp.OpenReport("C:\report1.rpt")

' Change SQL Query of crRpt here!

crRpt.Database.LogOnServer "p2sodbc.dll", "ODBC_DB", "", "USER1", "user1"

Me.CRViewer1.ReportSource = crRpt

Me.CRViewer1.ViewReport

'-------------------------------------------------

 

[vidru]

It doesn't work that way. Once the report is saved, the 'meat' of the query is locked in place. You can use the RecordSelectionFormula property to affect the WHERE clause, but you won't be able to change the actual query.

-dave