Hello everyone,
   
  Trying to use Crystal for the first time and having an issue with dates. The 
user tool crashes when I run the report from an active link.
   
  I Created a view (union of some forms) at the database level called foo using 
TSQL and using the followings for one of the columns.
   
  convert(char, dateadd(second, convert(int, MIC.Fecha_envío), '01-01-1971')) 
"Fecha_envío_char"
   
  In the Admin tool I create a view form called bar which reads the data from 
foo.  When I view the data in bar in the user tool, the values in the column 
have the format of  May 9 2007 12:44PM. 
  If I include this column in crystal to build my report and test from the 
client the latter crashes.
   
  Does the column needs further formatting? Any thoughts?
   
  Many thanks in advance
   
  frexpopo

             
---------------------------------
 Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail 

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Reply via email to