terrystill
Programmer
in 8.5 COM this was possible:
'begin snippet
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("oRpt".SQLQueryString = cStr(sqlScript)
'end snippit
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 before sending to RAS.
This is now mission critical!!
'begin snippet
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("oRpt".SQLQueryString = cStr(sqlScript)
'end snippit
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 before sending to RAS.
This is now mission critical!!