CrystalReports

Question

Hi... In my SQL DB I am having Date Field and Time Field seperately..Time Field contains time in number of seconds format... I want to show Date and Time in one column as 16/09/2011 18:43 in CrystalReport...Plz help me.....

Vilas Gite · Answer

Hi Ravindranath.. Refer this good article by Mahesh Sir may be helpful for your post… http://www.c-sharpcorner.com/UploadFile/mahesh/DateFormatInCR06132007092248AM/DateFormatInCR.aspx Thanks! ---------------------------------------------------------------------- If this reply helps your post…then check  This is correct answer

Mayur Dighe · Answer

Hey Ravindranath M  You can do it by passing SQL Query Manually to set the DataSource property for desired CrystalReport . The Sql Query must like this...... Select pkid field1field2 date + Space(1) + time  field3 From table1