locked
Crystal report date parameter RRS feed

  • Question

  • User918461375 posted

    Hi........

    I am using Crystal report in ASP.Net C#4.0. I have report in which i have date parameters, now i want that when i pass null in date parameter it should display all records and when i pass values in from date and to date parameters then the report should display the records between from date and to date. Please provide me the formula which should be written in select expert.

    Wednesday, August 1, 2012 8:05 AM

Answers

  • User-661350001 posted

    inside the condition

    where (@date is null or @date<=colDate) and (@colName is null or @colName=ColName)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 1, 2012 9:06 AM
  • User-578610739 posted

    Hi Pradeep,

    As Mudashir say you can  do it.

    Also, refer this link

    http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=15765

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 2, 2012 2:48 AM

All replies

  • User-661350001 posted

    inside the condition

    where (@date is null or @date<=colDate) and (@colName is null or @colName=ColName)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 1, 2012 9:06 AM
  • User-578610739 posted

    Hi Pradeep,

    As Mudashir say you can  do it.

    Also, refer this link

    http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=15765

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 2, 2012 2:48 AM