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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Dynamic & Cascading prompts

Status
Not open for further replies.

eastwestk

Programmer
Jun 10, 2009
39
US
Hello Everyone,

I have a crystal report which is using the sql server stored procedure as a datasource. In the stored procedure I have 3 parameters,One of the parameter is called @Country.

When I try to make this @Country parameter dynamic I am getting the error as

Fail to get values
The table could not be found
Error source:prompt.dll Error Code: 0x8004380D

Is it like I cannot use dynamic parameter if the datasource is the stored procedure because it's working fine if I change the datasource to a database table.

I am using crystal reports XI R2.

Please help.

Thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top