p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: binding problem


Message #1 by "Michel Medawar" <mmedawar@t...> on Wed, 26 Dec 2001 21:19:36 +0200
This is a multi-part message in MIME format.



------=_NextPart_000_0028_01C18E53.057889E0

Content-Type: text/plain;

	charset="windows-1256"

Content-Transfer-Encoding: quoted-printable



Merry Xmas everybody

Hope that you have spend the holidays

with the ones you love... not with ur PC...



Ok i my little problem is:

I have a stored procedure in MSAccess,

that has some parameters, i want to bound

this S.P to my Crystal Report at design time,

but i don't know why i can't see it until i

remove the S.P. parameters, even though i

checked the option "Show Stored Procedures"

in the Database Tab in the Options menu.



Thanks in advance



Michel Medawar










Message #2 by "Yama Kamyar" <y.kamyar@e...> on Thu, 27 Dec 2001 12:22:26 -0800
Hiya,



Thanks I spend my Xmas skiing @Snow Summit in beautiful Cali since I live in San Diego, California.



As for your SP... Can you demonstrate what you pass in your CR query?



Yama Kamyar

Sr. Software Engineer

--



On Wed, 26 Dec 2001 21:19:36   Michel Medawar wrote:

>---

>Need a present for your favorite programmer?

>E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp

>---

>Merry Xmas everybody

>Hope that you have spend the holidays

>with the ones you love... not with ur PC...

>

>Ok i my little problem is:

>I have a stored procedure in MSAccess, 

>that has some parameters, i want to bound 

>this S.P to my Crystal Report at design time, 

>but i don't know why i can't see it until i 

>remove the S.P. parameters, even though i 

>checked the option "Show Stored Procedures"

>in the Database Tab in the Options menu.

>

>Thanks in advance

> 

>Michel Medawar

>

>

>

>




>





Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com

Message #3 by "Michel Medawar" <mmedawar@t...> on Sat, 29 Dec 2001 17:00:36 +0200
Hi Yama

Hope your going fine,

here's a S.P that i used in my MSAccess file



PARAMETERS pPolicyNbr Long;

SELECT tbl_Policies.PolicyNbr, tbl_Policies.PolProDescription

FROM tbl_Policies

WHERE (((tbl_Policies.PolicyNbr)=[pPolicyNbr]));



when i remove the parameters from the query, i can

clearly see the query from the crystal report designer database

binding window, and ViceVersa



Any thoughts?



Thanks

Michel Medawar





----- Original Message -----

From: "Yama Kamyar" <y.kamyar@e...>

To: "crystal_reports" <crystal_reports@p...>

Sent: Thursday, December 27, 2001 10:22 PM

Subject: [crystal_reports] Re: binding problem





> Hiya,

>

> Thanks I spend my Xmas skiing @Snow Summit in beautiful Cali since I live

in San Diego, California.

>

> As for your SP... Can you demonstrate what you pass in your CR query?

>

> Yama Kamyar

> Sr. Software Engineer

> --

>

> On Wed, 26 Dec 2001 21:19:36   Michel Medawar wrote:

> >---

> >Need a present for your favorite programmer?

> >E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp

> >---

> >Merry Xmas everybody

> >Hope that you have spend the holidays

> >with the ones you love... not with ur PC...

> >

> >Ok i my little problem is:

> >I have a stored procedure in MSAccess,

> >that has some parameters, i want to bound

> >this S.P to my Crystal Report at design time,

> >but i don't know why i can't see it until i

> >remove the S.P. parameters, even though i

> >checked the option "Show Stored Procedures"

> >in the Database Tab in the Options menu.

> >

> >Thanks in advance

> >

> >Michel Medawar

> >

> >

> >

> >




$subst('Email.Unsub').

> >

>

>

> Join 18 million Eudora users by signing up for a free Eudora Web-Mail

account at http://www.eudoramail.com

>




$subst('Email.Unsub').






  Return to Index