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!

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

java & com ver 9 lost functionality

Status
Not open for further replies.
terrystill

terrystill

Programmer
Joined
Sep 8, 2003
Messages
2
Location
US
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(&quot;oRpt&quot;).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!!


 
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question Question
We're using command in crystal report
Replies
1
Views
766
hilfy
hilfy
VHDN
  • Locked
  • Question Question
Using Special File in Command
Replies
5
Views
792
hilfy
hilfy
Ajmal N
  • Locked
  • Question Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
7
Views
751
kray4660
kray4660
Ajmal N
  • Locked
  • Question Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
5
Views
617
dgillz
dgillz
mohebkasem
  • Locked
  • Question Question
Using Case in a crystal reports command parameter.
Replies
1
Views
581
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top