Cascading prompts in Business View Manager

Hello All,

I have a questions regarding data sources connectivity in business view manager.

I am trying to use Excel sheet as a data source and created data connection,Data Foundation,Business Element,business View and then List of Values and Prompt Groups.

When i tried to used this as a dynamic prompt in my crystal report,there are no drop down values shown...Just a text box is displayed.

Regards,

Diptesh