Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

8.5 to 9 ? setSQLStatement() ?

Status
Not open for further replies.

terrystill

Programmer
Sep 8, 2003
2
US
in 8.5 COM this was possible:

Set session("oApp") = Server.CreateObject("CrystalRuntime.Application")

Set session("oRpt") = session("oApp").OpenReport(basePath & "MyReport.rpt", 1)

sqlScript = <--Good SQL Statement with modified WHERE clause-->

session(&quot;oRpt&quot;).SQLQueryString = cStr(sqlScript)


Java and COM RAS 9 SDK has getSQLStatement() but I do not find a setSQLStatement().

Anyone know why? know a work-around?
Do not want to modify 400+ reports. Want to replace stored SQL in rpt.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top