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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Parameters to DB

Status
Not open for further replies.
Scroller52

Scroller52

Technical User
Jan 25, 2008
102
US
I'm using CR XI.

I can connecting via OLEDB (ADO) command to a SQL table. My command looks like this:

folder.reportname "Legal Entity={?Legal Entity}" FLAGS[/SILENT]

I would like for this parameter "Legal Entity" to be passed through so that I do not need to change any of the filters on the SQL table when I refresh the report.

Also, passing date parameters would be necessary as well. Any help on this topic would be greatly appreciated.
 
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
859
Kennymc
Kennymc
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
565
Ivan Kok
Ivan Kok
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
679
hilfy
hilfy
Dimitrie1
  • Locked
  • Question
string parameters in command
Replies
3
Views
608
kray4660
kray4660
Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
576
Gary Hnat
Gary Hnat

Part and Inventory Search

Sponsor

Back
Top