Last post Dec 23, 2020 06:45 PM by oned_gk
Dec 22, 2020 03:31 PM|jagjit saini|LINK
I have 4 parameters . From Date , To Date , Product , UserSign.
From Date & To Date to be mandatory. I am using Owor , Wor1 tables.
I want if user Enters From Date & To Date only then records get filtered only on date Basis.
if user enters Date & Product then records get filtered only on date Basis & Product
if user enters Date & UserSign then records get filtered only on date Basis & UserSign
if user enters Date , Product , UserSign then records get filtered on Date Basis , UserSign , Product.
Dec 22, 2020 04:03 PM|mgebhard|LINK
Share your code.
Dec 23, 2020 04:20 AM|jagjit saini|LINK
I don't know how to write in Record formula
Dec 23, 2020 06:45 PM|oned_gk|LINK
Not sure how to write it in cr, i don't have installed cr
Try like this way to query
SELECT * FROM TBL WHERE (@product is null or product=@product) AND (@UserSign is null or UserSign=@UserSign)
and soon ....then pass empty @product with null value