Error creating LOV in Business View Manager - cannot be based on current DF

[Former Member]

Hi,

I'm trying to use Business View Manager for the first time. I'm trying to create a dynamic, cascading prompt to be used by Crystal Reports.

I've been able to create:

- data connection

- data foundation - simple one table

- business elements - two columns from the table

- business view

- List of Values

I am now trying to create a parameter in the Business Elements tool. The parameter needs to be a Dynamic, Cascading parameter.

When I try to save the new parameter, I get the follow error:

The List of Values used by this parameter cannot be based on a Business View derived from the current Data Foundation or Business Element.

HELP

Thanks

[Former Member · Accepted solution]

Hi Chris

If you are trying to create a LOV and use that as a parameter, then you need to create LOV as Dynamic Cascading values. Once created then you can use that LOV in the Crystal Reports.

This is the best way to get dynamic cascading prompts in Crystal reports.

Please refer to Business View Admin guide for more information.

Hope this helps!!

Regards

Sourashree