Sequence of prompts

[former_member539471]

Hello Everyone,

Does using nested lov's effect sequence of prompts in report query ?

My prompts sequence is

1. date

2. Rso

3. Group name based on input value for RSO (used nested lov's)

I changed the query properties prompt order still "Date" prompt shows up at the end.

I will need prompt in the below sequence 1. Date . 2. RSO 3. Group name based on RSO value.How do i achieve this.Please see screenshot

Thanks Everyone

[former_member4998 · Accepted solution]

Hi

If WebI Report have multiple data provider’s...Prompt sequence display in the prompt screen,  as per the prompt sequence setup in the Data provider 1.

So select the Data Provider and change the prompt sequence according to your requirement.

Which ever prompt coming from universe, it’s display first in the prompt list.

[former_member190895 · Accepted solution]

Show me the view script of the query

[former_member539471 · Accepted solution]

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)