Dual pass Parameters

[jpro]

Hoping someone can help on a dual pass parameter question with Crystal Reports 8.5.

I have a table in our report that contains Ship to locations that is not linked into any of the data in the rest of the tables.

What I am trying to do is first have the user select a customer name from this table and then from that data next select the ship to location from within those results. Is there a way to apply a second criteria to the results returned from the first?

Hopefully this is a simple thing to do, but any help is appreciated. -- Thanks!

Great minds discuss "Ideas"
Average minds discuss "Events"
Below Average minds discuss "People

 

[lbass]

Well, if you want the customer to be related to the shipping locations, the tables have to be linked to each some way.

It sounds like you want a dynamic cascading parameter where the user selects from shipping locations that are customized to reflect the particular customer. This is available in versions XI and 2008, not in 8.5.

What you might want to do is create a custom pick list by concatenating the customer with the shipping location in another report. You can then export the results to text and then import the list as your picklist for a prompt {?Customer Location}. It would be ideal if you had an ID field that related to the specific location. Then your picklist report would use that in the first column and the concatenation in the second column. When you import this into the parameter screen, the concatenation would appear as the description field, and the ID as the value. You could then display on the description, but use the ID in your record selection formula:

{table.id} = {?Customer Location}

This is not a dynamic picklist (again this is available in XI and above), and would need to be periodically updated.

-LB