nested Lov's does not restrict data in report
I created nested lov's in business layer....I created 2 list of values
when user enter : year month...(single entry)
Rso's for year entered(single entry)
List of Group names for Rso entered(Multiple entry)
Results of RSO are assosicted to Group name lov and results of rpt year to RSO object.
when I create a report....and restrict data based on the nested lov's the restriction of 'rpt year month' is not being applied to the report....it is getting results for all year month....
when i checked the script .... the where clause is only applied for group_name and not for RSO or year month.
EMR_REPORTING.dbo.vMH_MEASURE_PROVIDER.GROUP_NAME @prompt(Group Name)
I am not sure what mistake I am doing.
Any inputs highly appreciated. Included screenshot *