I created report in Crystal Report 2008 using Stored procedure with four parameters. Now I have to pass Cascading LOVs to these store procedure parameters which are created from Business view.

 

When I am refreshing the report the same prompts display two times..

 

for example the parameter Level1,Level2,Level3 and Level4 are created in the Stored procedure.

I mapped Cascading Business View LOV(Level1-Level4) to Level1. Again using the same Business View Cascading LOV and mapped to Level2. Like wise LOVs mapped to Level4.

 

When I am refreshing the report

Level1 parameter display as one prompts with LOV

1. Level1

 

Level2 parameter display as two prompts for

1. Level1

2. Level2