Very urgent problem in crystal reports please help
-
i want to show records between two dates and my date datatype is varchar i am inserting date in yyyy/mm/dd format my record selection formula is ir.RecordSelectionFormula = " {ViewPartyOrder.pcode}=' " + ComboBox2.Text + " ' and {viewpartyorder.orderdate}>=' " + DateTimePicker4.Value.ToString("yyyy/MM/dd") + " ' and {viewpartyorder.orderdate}<=' " + DateTimePicker3.Value.ToString("yyyy/MM/dd") + " ' " ir is the object of crystal report when i am using this i get blank record but when i apply this into another table it works fine
-
i want to show records between two dates and my date datatype is varchar i am inserting date in yyyy/mm/dd format my record selection formula is ir.RecordSelectionFormula = " {ViewPartyOrder.pcode}=' " + ComboBox2.Text + " ' and {viewpartyorder.orderdate}>=' " + DateTimePicker4.Value.ToString("yyyy/MM/dd") + " ' and {viewpartyorder.orderdate}<=' " + DateTimePicker3.Value.ToString("yyyy/MM/dd") + " ' " ir is the object of crystal report when i am using this i get blank record but when i apply this into another table it works fine
-
i m new in crystal report please send me some code