DateTime parameter problem

Comments

• AlexTZ

  April 2009 edited 9:14PM

  Hello,
  
  Which data provider do you use? It's a MS SQL or something else?
• Vita

  April 2009 edited 9:14PM

  AlexTZ wrote: »

  Hello,
  
  Which data provider do you use? It's a MS SQL or something else?

  Yeah it's MSSQLDataConnection
  
  
  
• AlexTZ

  April 2009 edited 9:14PM

  Did you tested it on a new FR.Net version? It works well for me. Please describe steps how to reproduce this error.
• Vita

  April 2009 edited 9:14PM

  I have FR.NET build 196.? 
  
  my description:
  
  - in designer create New DataSource (MSSQL -> select table -> Finish)
  
  - right-click on new table -> edit
  
  - in tab Define Parameters create New -> set Datatype and Expression(same type as parameter) -> Finish
  
  - right-click on new table -> View data and I get this message: "Failed to convert parameter value from a variant to a DateTime"
  
  
• AlexTZ

  April 2009 edited 9:14PM

  You have to set up the DefaultValue property of the parameter. This property is used when you trying to view table data. The Expression property can't be calculated when you in the report designer.
• Vita

  April 2009 edited 9:14PM

  Thanks for your help. I had no idea that parameter DefaultValue have to be set (especially when I set up parameter value in code before I tried evaluate table). Now it works in designer and code also