locked
Report Formula RRS feed

  • Question

  • User1979860870 posted

    Hi

    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.

    Thanks

    Tuesday, December 22, 2020 3:31 PM

All replies

  • User475983607 posted

    Share your code.

    Tuesday, December 22, 2020 4:03 PM
  • User1979860870 posted

    Hi

       I don't know how to write in Record formula

    Thanks

    Wednesday, December 23, 2020 4:20 AM
  • User-1716253493 posted

    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

    Wednesday, December 23, 2020 6:45 PM