cancel
Showing results for 
Search instead for 
Did you mean: 

LOVs in Business View Manager

Former Member
0 Kudos
47

Hi All,

I know the implementation of dynamic cascading parameters using list of values in Crystal XI.

But i need some information regarding Business View Manager.

Country > Region > City - This is my desired cascading parameter. For creating this parameter, what should be my data foundation?

Select country,region,city from customer

Can i use this query in my data foundation? I think this will duplicate the values inside country and region...

Please help me in this issue....

Thanks,

Meena

Accepted Solutions (1)

Accepted Solutions (1)

fritzfeltus
Product and Topic Expert
Product and Topic Expert
0 Kudos

If you're interested in getting the best performance for your DCP, try this article:

[Crystal Reports XI R1 And R2 Dynamic Cascading Prompt Performance 1.8|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e073744a-693f-2b10-b5b8-b216437cb007]

I'd recommend the chapter "Cascading LOV Data Access Tuning", it explains how you can configure your LOV to ensure on-demand access for each level of the LOV.

Former Member
0 Kudos

Hi Fritz,

Thanks for your quick response.

That was a useful document. But still i have got the same doubt.

how to remove duplicates while using the below command object in data foundation for the cascading list of values:

Select country, region,city from customer

Any help is really appreciated.

Meena

fritzfeltus
Product and Topic Expert
Product and Topic Expert
0 Kudos

I'm not certain why you are worried about duplicating data for Country and Region? Why do you think this data will be duplicated and where can you see this?

Also note that using a command object in the data foundation will cause your all values for all levels to be retrieved in one database access, which may cause unnecessary delays.

Answers (0)