on 07-28-2010 3:19 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Since it is unavailable in my version, I will not pursue it now. Thank you for that information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.