Hi All,
I am trying to design a view in Lotus Notes in a way that when retrieving data via NotesSQL into Crystal Reports 11 - the fields that ARE date, DISPLAY as date ( not strings ).
I know I can convert them when in Crystal but it's much nicer if it happens by default.
Have tried setting the columns as Date/Time but no effect at the Crystal end. ( still appear as Strings ).
The NotesSQL driver had a option "Return Notes Implicit Fields", when turning this on and going into Crystal I can see fields that were previously hidden such as:
- NoteCreated ( type DateTime )
- NoteAccessed ( type DateTime )
- NoteID ( type number )
These columns are not displayed in the view so I do not know what settings to use. When I create a column using "Simple Function" - CreationDate - it still only appears as a string in Crystal.
Any ideas?
I have tried the Crystal Forum and they suggested using another driver. Reference:
http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21896634.html
Any help greatly appreciated, thanks for reading ;)
Broad
Firstly, I know nothing of CR, little of NotesSQL and a little more of Notes.
Just a suggestion: can you try with Access (or Paradox or whatever) to see what type of fields it comes up with? It might at least show that it is possible to get the type transfered.