index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Wow! I am impressed by the quality of support! :: (8) Post a New Message | Post a Reply
Feb 22 2005, 7:25 PM	Wow! I am impressed by the quality of support! Post a Reply
digitald2 since: Feb 21, 2005 from: Hawaii	This seems to be such a little company but I am very impressed by their quality and promptness of support.  I had a bug I found the other day and today they already came out with a patch for it.  Awesome.   I have another suggestion/request though.  I am trying to create a user defined field that accepts a date range.  For example I want to see sales between and user defined date range such as 02/01/05 through 02/22/05. When I create a prompt it returns: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. Thanks,
Feb 23 2005, 12:24 PM	Re: Wow! I am impressed by the quality of supp... Post a Reply
ghost from: Washington, DC	thanks digitald2! What version of SQL Server are you using? Also make sure the fields are of DATETIME data type. Also, try entering your date in the format YYYY-MM-DD e.g. 2005-02-23 and let me know if this makes any difference. ------------------------- Ghost
Feb 23 2005, 5:38 PM	Re: Wow! I am impressed by the quality of supp... Post a Reply
digitald2 since: Feb 21, 2005 from: Hawaii	I created a report in your live demo under the trouble shooting group section that supposed to show orders between a certain date. It returns Syntax error in date in query expression '( ([Orders].[OrderDate]=#1994-11-01 Date# OR [Orders].[OrderDate]>#1994-11-01 Date#) AND ([Orders].[OrderDate]=#1994-11-20 Date# OR [Orders].[OrderDate]<#1994-11-20 Date#) )'. I tried using both date formats
Feb 23 2005, 5:40 PM	Re: Wow! I am impressed by the quality of supp... Post a Reply
digitald2 since: Feb 21, 2005 from: Hawaii	I notice after a while the reports in your demo dissapear.  Do you have it reset every couple of hours or so? If so, how do you backup all these report files?  What if I want to export or backup my report files on my server, how would I go about doing that? Thanks,
Feb 23 2005, 5:44 PM	Re: Wow! I am impressed by the quality of supp... Post a Reply
digitald2 since: Feb 21, 2005 from: Hawaii	Syntax error in date in query expression '( ([Orders].[OrderDate]=#11/01/94 Date# OR [Orders].[OrderDate]>#11/01/94 Date#) AND ([Orders].[OrderDate]=#11/20/94 Date# OR [Orders].[OrderDate]<#11/20/94 Date#) )'.
Feb 24 2005, 9:02 AM	Re: Wow! I am impressed by the quality of supp... Post a Reply
ghost from: Washington, DC	I'm not what input you added. Make sure you are entering just the date itself without the Date string in the serch text as shown below: It should be '( ([Orders].[OrderDate]=#11/01/94# OR [Orders].[OrderDate]>#11/01/94#) AND ([Orders].[OrderDate]=#11/20/94# OR [Orders].[OrderDate]<#11/20/94#) )'. Instead of '( ([Orders].[OrderDate]=#11/01/94 Date# OR [Orders].[OrderDate]>#11/01/94 Date#) AND ([Orders].[OrderDate]=#11/20/94 Date# OR [Orders].[OrderDate]<#11/20/94 Date#) )'. Let me know if this helps P/S: The examples on our site are overwritten every hour - I will set it to 3 hours. ------------------------- Ghost
Feb 24 2005, 9:22 AM	Re: Wow! I am impressed by the quality of supp... Post a Reply
digitald2 since: Feb 21, 2005 from: Hawaii	I tried that but it still doesn't work.  I am using ?StartDate and ?EndDate as the user defined criteria. Syntax error in date in query expression '( ([Orders].[OrderDate]=#11/01/94 Date# OR [Orders].[OrderDate]>#11/01/94 Date#) AND ([Orders].[OrderDate]=#11/20/94# OR [Orders].[OrderDate]<#11/20/94#) )'.
Feb 24 2005, 9:28 AM	Re: Wow! I am impressed by the quality of supp... Post a Reply
digitald2 since: Feb 21, 2005 from: Hawaii	Oh... I see what you mean.  In the format section you can't define what date style displays.  You have to leave that blank.
Pages: (1)   [1]

search this forum: