| Passing Parameters & Query to crystal report [message #231249] |
Mon, 16 April 2007 02:12  |
simple_ora
Messages: 50
Registered: September 2006
Location: UAE
|
Member |
|
|
Hi
Can anybody give the details of passing parameters and query to
crystal report.I can run the report from form,but not suceeded in passing parametrs.
CrystalReport1.Formula(0) = 'VARIABLE' is not working for me...
Thanks & Regards
Shefiq
|
|
|
|
|
|
|
|
|
|
| Re: Passing Parameters & Query to crystal report [message #232601 is a reply to message #232237] |
Sun, 22 April 2007 00:19  |
simple_ora
Messages: 50
Registered: September 2006
Location: UAE
|
Member |
|
|
Hai Martin
I searched this forum,there i found the coding to call crystal report ..,But i did n't find anything related to my needs.I just wan to know how to pass the parameters (Ie Formula) to crystal report...,,,
I googled it ,but no result...
Thanks & regrads
Shefeeq
|
|
|
|
|
|
| Re: Passing Parameters & Query to crystal report [message #233064 is a reply to message #232661] |
Tue, 24 April 2007 09:04 |
simple_ora
Messages: 50
Registered: September 2006
Location: UAE
|
Member |
|
|
Hai Martin
The given link for stored procedure and crystal report...
But iam in half to my result...
now iam getting error on code
sWhere := '{' || sReportTable || '.COUNTRY}=' ||'''IRAN''';
CRYSTAL_CRYSTALCTRL.SelectionFormula(:item('CONTROL.CRYSTALREPORT1').interface,sWhere);
showing error ora-100504
its calling oracle builtin package for ole...
any idea...
Regards
Shefeeq
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
