×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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

Multiple multi value parameters

Multiple multi value parameters

Multiple multi value parameters

(OP)
Hello.

I'm wondering if I use 2 multi value parameters in my report of the entries from both parameters will match up. Ie, the report uses the first entry of multi A and the first entry of multiB, then it processes the second entry of multiA along with the second entry of MultiB, etc.

TIA

Holly

RE: Multiple multi value parameters

Hi Holly

I'm sorry but I don't understand wat you are asking. Are you able to explain in more detail exactly what you are trying to achieve please. Sample data and parameters will probably help.

Cheers
Pete

RE: Multiple multi value parameters

Multi-value parameters are useful for IN clauses. Something like "Product in ('x0', 'x1', ...)". You probably can treat them as arrays and do filtering like
(Product[0]='x0' AND Factory[0]='y0')
OR
(Product[1]='x1' AND Factory[1]='y1')
However, this will be a mess and I am not sure how you can enforce parameter values to always be provided in the right order.

If you need sets of parameters check if data-driven subscriptions will serve you better. The concept is taken from SSRS but you can implement it with Crystal reports too. In general, you run a custom query , which will return some records and you can use the values from each record to run a report. You will run the report once per each record and your parameters don't need to be multivalued. For the sample above you will have rows like these
Product Factory
x0 y0
x1 y1

and you will run your report twice.

www.R-Tag.com Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

RE: Multiple multi value parameters

Hi,

The OP is posing a problem where Parameter1 valuea means that Parameter2 values list will not be congruent with Parameter1 valueb Parameter2 values list.

That is, in order to get a list of Parameter2 values to select from, a Parameter1 value must be selected which will dictate the Parameter2 value list or visa versa.

I solve this problem by running my queries from Excel, where I can run a query to generate a list based on a previously selected parameter. As I recall, I once ran a query that had 5 parameters, that required 4 supporting queries for parameter lists, prior to running the query in question.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Multiple multi value parameters

It still isn't entirely clear - is Cascading Parameters what you are looking for? That is where the pick list for the 2nd parameter is based on the selection of the 1st parameter.

This is functionality that was introduced in later versions of Crystal.

Probably not helpful but in the absence if further detail from OP I've got nothing else to offer.

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