View Full Version: Date parameter field problems

kgroff >>Program Help >>Date parameter field problems


<< Prev | Next >>

parkerl- 04-11-2007
Date parameter field problems
I am receiving an error when entering date parameters. Although a date has been selected I get an error message the says "Please enter a Date value". Surprisingly this is not an issue for Date Time parameters. I am running Win XP Pro with .NET 2.0. Thanks LP

kgroff- 04-11-2007

Can you post the actual error message details. It should be something like this: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.InvalidCastException: Conversion from string "asdf" to type 'Date' is not valid. at Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(String Value) at CrystalDelivery.modInitiateReport.fncReportSource() at CrystalDelivery.frmViewer.frmViewer_Load(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- Crystal Delivery Assembly Version: 7.0.2.8 Win32 Version: 7.0.2.8 CodeBase: file:///C:/Program%20Files/Groff%20Automation/Crystal%20Delivery/Crystal%20Delivery.exe ---------------------------------------- Microsoft.VisualBasic Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Runtime.Remoting Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll ---------------------------------------- CrystalDecisions.Shared Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.Shared/10.2.3600.0__692fbea5521e1304/CrystalDecisions.Shared.dll ---------------------------------------- CrystalDecisions.CrystalReports.Engine Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.CrystalReports.Engine/10.2.3600.0__692fbea5521e1304/CrystalDecisions.CrystalReports.Engine.dll ---------------------------------------- CrystalDecisions.ReportAppServer.CommLayer Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.CommLayer/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CommLayer.dll ---------------------------------------- CrystalDecisions.ReportAppServer.ClientDoc Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.ClientDoc/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ClientDoc.dll ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- CrystalDecisions.ReportAppServer.DataSetConversion Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataSetConversion/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataSetConversion.dll ---------------------------------------- CrystalDecisions.ReportAppServer.DataDefModel Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataDefModel/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataDefModel.dll ---------------------------------------- CrystalDecisions.ReportAppServer.Controllers Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.Controllers/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.Controllers.dll ---------------------------------------- CrystalDecisions.ReportAppServer.CubeDefModel Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.CubeDefModel/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CubeDefModel.dll ---------------------------------------- CrystalDecisions.ReportAppServer.ReportDefModel Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.ReportDefModel/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ReportDefModel.dll ---------------------------------------- CrystalDecisions.KeyCode Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.KeyCode/10.2.3600.0__692fbea5521e1304/CrystalDecisions.KeyCode.dll ---------------------------------------- System.Web Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll ---------------------------------------- CustomMarshalers Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll ---------------------------------------- CrystalDecisions.ReportAppServer.XmlSerialize Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.XmlSerialize/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.XmlSerialize.dll ---------------------------------------- CrystalDecisions.Windows.Forms Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.Windows.Forms/10.2.3600.0__692fbea5521e1304/CrystalDecisions.Windows.Forms.dll ---------------------------------------- CrystalDecisions.ReportSource Assembly Version: 10.2.3600.0 Win32 Version: 10.2.51014.0 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CrystalDecisions.ReportSource/10.2.3600.0__692fbea5521e1304/CrystalDecisions.ReportSource.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.

parkerl- 04-11-2007
Not an "exception" really
"Error message" may have been the wrong choice of words. I don't think the application is throwing an exception. (Debugging isn't kicking in) It is just giving me a dialog saying it doesn't like the date. I will try to send a screen shot.

Jannoth- 12-11-2008

Hi all. I seem to be getting this problem and can't work out a way around :cry: A CRXI parameter asks for a Date and when the date is entered in Corral v 1.0.0.4 (I really prefer this interface to the new ones) then I get the message "Please enter a Date Value". My network is on Windows 2000 - can anyone please shed some light cos colleages want to kill me :shock: Thanks J

Jannoth- 12-12-2008

I've just noticed (since my above post) that CRXI requires Parameter Dates to be entered in the format "yyyy-mm-dd". But, Corral only accepts dates in the format "dd/mm/yyyy" - even if you use the "calendar feature" (launched by clicking the drop down arrow). Strangely enough, I've spotted that dates don't cause a problem whenever the parameter accepts Ranges as opposed to discrete values - but that won't work for us in this instance :x Does this help anyone work out what I need to do? Thanks - in great hope :?

Forumer™ is Voted #1 Free Forum Hosting provider
Build your own community today with the largest message board hosting company.