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.....
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vilas GitePosted Sep 18, 2011, 10:19 AM
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 DighePosted Sep 18, 2011, 5:53 AM
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, field1,field2, date + Space(1) + time, field3
From table1