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!

8.5 to 9 ? setSQLStatement() ?

Status
Not open for further replies.
terrystill

terrystill

Programmer
Joined
Sep 8, 2003
Messages
2
Location
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.

Similar threads

lavadan
  • Locked
  • Question Question
Export to excel with drop down data
Replies
2
Views
699
hilfy
hilfy
smmaruf82
  • Locked
  • Question Question
How to Fixed 4 Column in Crystal Report Crosstab
Replies
1
Views
626
lbass
lbass
DanEvansJr
  • Locked
  • Question Question
Crystal Report to Adobe pdf - font issue
Replies
1
Views
818
DanEvansJr
DanEvansJr
n2nuk
  • Locked
  • Question Question
Migrating reports from CR server 2013 to CR Server 2016
Replies
6
Views
1K
n2nuk
n2nuk
Tracy Leggett
  • Locked
  • Question Question
Nth Largest item based on Price but need to show Item #
Replies
1
Views
605
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top