Dynamic Cascading parameter, allow multiple values is greyed out

[Former Member]

Greetings,

I have a LOV which is a cascading prompt (Department > Employees), in crystal reports I cannot edit the dynamic parameters 'Allow multiple values' setting, it's is highlighted and non-editable.

Is this because of how I'm using the dynamic parameter in the record selection (see below) as the Crystal reports DataSource is a stored procedure?

{usp_Services_Utilisation;1.EmployeeName} = {?@ChoosenEmps}

Or is how I've created the LOV in the business view manager, intrigued why this setting cannot be changed?

Help and guidance would be appreciated, thanks

Rob

[abhilash_kumar]

Hi Rob,

If the {?@ChoosenEmps} parameter is a Stored Procedure parameter, then the 'Allow Multiple Values' WILL be disabled.

It really does not depend on where the LOV has been created.

If you want the stored procedure to accept multiple values, perhaps, you could modify the stored procedure to accept a delimited string. The users can then enter something like this: abc, def, ghi for the stored procedure to process.

-Abhilash

[Former Member]

Hi,

Sorry I should have updated this thread, I didn't see the obvious the dynamic prompt in the business view manager where the multiple values was set to false, I changed this which carries the value through to the crystal report when opened in the designer.

Thanks for your reply.