List of options available?

[staceyn]

Hello,
I am using Crystal XI against an informix database.
We are trying to create an image report that shows item information along with images of the items being reported on.
For each item there is another table that holds what the valid color and sizes are for these items.
There is currently no grouping on the report.
The item image, item number, description, cost, price etc are all in the detail section of the report.

The user would like to be able to select the appropriate color/size record while running the report. However these values are different for each item, so a general parameter won't work.
As an example if they choose to report on items 100000 and 100001, the only valid colors for item 1000000 are black, white and blue;the only valid sizes are S M L XL. For item 100001 the valid colors are black, green and orange, valid sizes are M,L, XL, XXL.
So if I select item 100000 the list should only provide valid colors black, white and blue and valid sizes are S M L XL. If I select the detail record for item 100001 the list should only provide valid colors as black, green and orange, and valid sizes as M,L, XL, XXL

Is there a way when running the report that a option can be selected for each individual item in the details to pop a window for the user to select the appropriate color/size record for each specific item in the details section?

Appreciate any help

Thanks

 

[lbass]

You are describing a dynamic cascading parameter. You could set up the report to return the available colors and sizes per item if you only allowed one item per report run. If you allowed multiple items, the options would show those items, and then the colors would show those available for either or both items, and the sizes would include any listed for those items.

Another idea would be to set up a command that would concatenate the item, color and size into one field that could then be used for the parameter picklist (only), so items might be listed as:

tshirt-black-sm
tshirt-black-med
shoes-brown-eee
shoes-black-eee

You would then have to set up a selection formula that with a formula that matched the description.

-LB