Home » Developer & Programmer » Forms » Passing Parameters & Query to crystal report
Passing Parameters & Query to crystal report [message #231249] Mon, 16 April 2007 02:12 Go to next message
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 #231401 is a reply to message #231249] Mon, 16 April 2007 23:19 Go to previous messageGo to next message
simple_ora
Messages: 50
Registered: September 2006
Location: UAE
Member
Hi
Plse give replay for it....
I can call the crystal report,but passing parameters are the problem....

Thanks & Regards
Shefeeq
Re: Passing Parameters & Query to crystal report [message #231575 is a reply to message #231249] Tue, 17 April 2007 10:04 Go to previous messageGo to next message
simple_ora
Messages: 50
Registered: September 2006
Location: UAE
Member
Hello Guys...

No Idea about it,Its urgent one...
can anbody give solution to this one............

Thanks & Regards
Shefeeq
Re: Passing Parameters & Query to crystal report [message #232237 is a reply to message #231575] Thu, 19 April 2007 21:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you searched this forum for 'crystal'? How about the 'reports' forum? How about the whole of this site? How about google?

David
Re: Passing Parameters & Query to crystal report [message #232601 is a reply to message #232237] Sun, 22 April 2007 00:19 Go to previous messageGo to next message
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 #232661 is a reply to message #232601] Sun, 22 April 2007 21:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did http://www.orafaq.com/forum/m/40106/67467/?srch=crystal+parameter#msg_40106 and http://www.orafaq.com/forum/m/32955/67467/?srch=crystal+parameter#msg_32955 and http://www.orafaq.com/forum/m/170203/67467/?srch=crystal+parameter#msg_170203 not help?

David
Re: Passing Parameters & Query to crystal report [message #233064 is a reply to message #232661] Tue, 24 April 2007 09:04 Go to previous messageGo to next message
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
Re: Passing Parameters & Query to crystal report [message #236430 is a reply to message #233064] Thu, 10 May 2007 00:04 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you solve your problem?

David
Previous Topic: How to insert data with the change the specifiq time duration...
Next Topic: how can I learn the size of for each row.
Goto Forum:
  


Current Time: Sat Dec 10 05:10:48 CST 2016

Total time taken to generate the page: 0.09869 seconds