cancel
Showing results for 
Search instead for 
Did you mean: 

DB Access for Parameter Values

Former Member
0 Kudos

I'm a brand new CR user (day 3) so I apologize if I am wasting anyone's time here. I want to display a report based on parameters that will require two calls to the database and two interactions with the end user. First, I need to display all customers on our DB so the appropriate one can be selected. Then I need to go back to the DB and get all contacts for that customer so the appropriate one can be selected. Then I base the report off of that selection. Based on my reading, I am under the impression that CR does not have this capability (at least as recently as release 8.5). Is this true? I have to believe this sort of thing is not uncommon so does anyone have any suggestions?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

CR8.5 is nearly 10 years old, but cascading parameters were only introduced in CRXI about 3 years ago.

For prior versions you will have to buy some third party software.

Ian

Answers (2)

Answers (2)

adam_alsop2
Participant
0 Kudos

Since you're stuck on 8.5, depending on your interface/environment, you could have a stored procedure (or PL/SQL command, depending on your DB) developed for the interface to generate this and then kick off the report using the selected values.

I have done that before using a simple ASP page (.NET), Oracle, and PL/SQL.

Otherwise I would highly suggest upgrading to at least XIr2/3 or 2008.

Best of luck!

Former Member
0 Kudos

Since it is unavailable in my version, I will not pursue it now. Thank you for that information.