Get vouchers of single date

[TariqMehmod]

Respected Seniors

I want to display all vouchers of single date 31-12-2020

So I have these parameters

 dt@ SELECT Distinct t0."DocDate" From ORDR t0

 num@ SELECT t1."NumAtCard" From ORDR t1 Where (t1."DocDate" = '@dt')

And this is selection formula

 {Command.DocDate} = {?dt@ SELECT Distinct t0."DocDate" From ORDR t0} and
{Command.NumAtCard} = {?num@ SELECT t1."NumAtCard" From ORDR t1 Where (t1."DocDate" = '@dt')}

When I run report and select date 31-12-2020 then dynamic list displays all vouchers from all dates but I need vouchers on of 31-12-2020

What I doing wrong?
Please help me to get only those vouchers that falls on 31-12-2020

Thanks in advance

 

[lbass]

Please show a screen shot of how you set up the date parameter.

-LB

 

[TariqMehmod]

Yes sir here are parameters

Please

 

[lbass]

It looks like you tried to create a subquery to populate your picklist within the label of the dynamic parameter. Instead, you need to create a separate command just for this purpose. Do not link the command to your original command. When you set up the dynamic parameter, reference the date field in the subquery to populate the picklist and then within your original command, create a parameter of the same name in the screen on the right and reference the parameter in the command.

I suggest you read about dynamic cascading parameters by doing a search for other threads on this topic, for example:
thread149-1678886

-LB