locked
parameters in crystal reports RRS feed

  • Question

  • User918461375 posted

    hi.......

    I am using ASP.Net C# and crystal reports,

    i am passing parameters from aspx page, now i want that when i pass null values to parameters then it should display aal the data in tables or when i dont pass any values to parameters then also it should run and display all the data.

    please guide me ..........

    Friday, July 27, 2012 5:28 AM

Answers

  • User-661350001 posted

    in the sql query

    say something like this

    select * from table1 where (@p1 is null or c1=@p1) and (@p1=null || c2=@p2)........

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 27, 2012 6:52 AM

All replies

  • User-661350001 posted

    in the sql query

    say something like this

    select * from table1 where (@p1 is null or c1=@p1) and (@p1=null || c2=@p2)........

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 27, 2012 6:52 AM
  • User918461375 posted

    thanx for your reply.

    What should be the expression for date datatype in above code.

    Tuesday, July 31, 2012 12:21 AM