Last post Aug 02, 2012 02:48 AM by Ajay2707
Aug 01, 2012 08:05 AM|pradeepnt|LINK
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.
Aug 01, 2012 09:06 AM|Mudasir.Khan|LINK
inside the condition
where (@date is null or @date<=colDate) and (@colName is null or @colName=ColName)
Aug 02, 2012 02:48 AM|Ajay2707|LINK
As Mudashir say you can do it.
Also, refer this link