visual studio 2008 - How do I add the time to a date field in a CR report? -


i've got couple of crystal reports xi release 2 reports part of com interopform's app, included in vb6 app. both of these reports display date datetime field in sql server database. they've worked fine last 3 years or so.

now i've been tasked showing time portion of data. i've got both of .rpt files opened in cr 11 r 2 designer, , looking @ format editor. under date tab don't see display both date , time of data. (unless system default long format, i'm not sure of on each of users' machines. in fact, frankly don't know how check on own machine, windows xp pro machine sp3 installed.) anyway, i've taken under custom style, again don't see there allow me display time portion of datetime field database. how display both date , time, datetime field in database?

you should see quite few options. if view looks attached picture, you're go.

if see bunch of formats numbers, date not stored in correct format. fixed making custom formula converting field datetime , displaying new formula field instead of original.

format editor


Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

html - Instapaper-like algorithm -

c# - How to execute a particular part of code asynchronously in a class -