Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

nested Lov's does not restrict data in report

Hello All,

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.

SELECT

  EMR_REPORTING.dbo.vMH_MEASURE_PROVIDER.RSO,

  EMR_REPORTING.dbo.vMH_MEASURE_PROVIDER.GROUP_NAME,

  EMR_REPORTING.dbo.vMH_MEASURE_PROVIDER.RPT_YEAR_MONTH,

  EMR_REPORTING.dbo.vMH_MEASURE_PROVIDER.FN,

  EMR_REPORTING.dbo.vMH_MEASURE_PROVIDER.PRIMED_STATUS_PROVIDER

FROM

  EMR_REPORTING.dbo.vMH_MEASURE_PROVIDER

WHERE

  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 *

Thanks.

Untitled3.png (82228 B)
Untitled2.png (61042 B)
Untitled1.png (30034 B)
Not what you were looking for? View more on this topic or Ask a question