×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Cascading Parameters

Cascading Parameters

Cascading Parameters

(OP)
Hi All

Iam trying to create a cascading parameter by using fields from two different tables. The tables belong to the same db and are part of a relational db.

I am using CRXI Rel 2....

Is this possible?

Many Thanks  

RE: Cascading Parameters

Please do not crosspost. Yes, it should be possible, although the tables should be linked with each other, I believe.

-LB

RE: Cascading Parameters

(OP)
Cheers Ibass.....when you mean linked do you mean they should be directly linked or can I get away with them being part of a relational db?

RE: Cascading Parameters

I have always used directly linked tables, but I'm not 100% sure they have to be. Why not try it?

-LB

RE: Cascading Parameters

(OP)
Hi I have tried cascading parameters with tables that are not linked...no success...

Any one had any success or got any ideas?

RE: Cascading Parameters

(OP)
Ok I have managed to set up the cascading parameter but I am getting the following error message when trying to run:

---------------------------
Crystal Reports
---------------------------
Prompting failed with the following error message: 'List of Values failure: fail to get values. [Cause of error: Failed to retrieve data from the database.
Details:  [Database Vendor Code: 245 ] Failed to retrieve data from the database. Error in File UNKNOWN.RPT:
Failed to retrieve data from the database.
Details:  [Database Vendor Code: 245 ]]'.

Error source: prompt.dll  Error code: 0x8004380D
---------------------------
OK   
---------------------------


Anyone any ideas???

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close