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....