parameters in crystal reports RSS

• • Reply
  

  pradeepnt

  Member

  266 Points

  154 Posts

  parameters in crystal reports

  Jul 27, 2012 09:28 AM|LINK

  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 ..........

  Thanks and regards
  Pradeep Narayan
• • Reply
  

  Mudasir.Khan

  All-Star

  15346 Points

  3142 Posts

  Re: parameters in crystal reports

  Jul 27, 2012 10:52 AM|LINK

  in the sql query

  say something like this

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

  View Blog
  • Marked as answer by pradeepnt on Jul 31, 2012 04:20 AM
• • Reply
  

  pradeepnt

  Member

  266 Points

  154 Posts

  Re: parameters in crystal reports

  Jul 31, 2012 04:21 AM|LINK

  thanx for your reply.

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

  Thanks and regards
  Pradeep Narayan