Christie, Few things you may want to check,
- Try an advanced search on the form with the qualification you are trying to use. If it is retrieving the result, probably there would not be a problem with your qualification - Try removing the addition of seconds to your date/time and check if you get the results Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 On Mon, Mar 14, 2011 at 7:58 PM, Pargeter, Christie :CO IS <cparg...@lhs.org > wrote: > ** > The full qual that I am trying is '3'>=$Start Date$ and '3'<=$End > Date$+86399 and '1000001029'=$Sent From Person$ > > I want all the records created within a date range by a person. e.g., All > records created from 1/1/11 -> 4/1/11 by cpargete > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Roehr, Mario > *Sent:* Saturday, March 12, 2011 12:52 AM > *To:* arslist@ARSLIST.ORG > *Subject:* AW: Issue with a report > > ** > > Christie, > > > > I’m wondering if this could be a valid qualification: > > > > 'Submit Date' >= $Start Date$ > > > > That means `Submit Date` would be later as the `Start Date`, but Submit > Date in the most cases is the earliest Timestamp as it was set when you > submitted the record (eg. Click on the Save button) > > > > Mario > > * * > > * * > > *Von:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *Im Auftrag von *Pargeter, Christie :CO IS > *Gesendet:* Samstag, 12. März 2011 00:50 > *An:* arslist@ARSLIST.ORG > *Betreff:* Re: Issue with a report > > > > ** > > There are no errors in Crystal Reports or the User Tool when I try the > report only on the web. I did try recreating at one point to use the > underscores incase that was the issue. But the really odd point to me is > that if I run the report with any quals it works but if I add '3'>="1/1/11" > I get the error. > > > > I tried to add the report to the Reporting Console and to select the Submit > Date and just that field and I still get the error. > > > ------------------------------ > > *From:* kimberly.sant...@oracle.com santana [mailto: > kimberly.sant...@oracle.com] > *Sent:* Friday, March 11, 2011 3:43 PM > *To:* arslist@ARSLIST.ORG > *Cc:* Pargeter, Christie :CO IS > *Subject:* Re: Issue with a report > > I am curious to know when you refresh the report in crystal reports are you > getting any errors ? > I am noticing that your qualification does not use underscores but the > crystal report field is using underscores.. > How do you have our odbc set up? to use underscores or not to use > underscores? > > Kimberly > > On 3/11/2011 9:58 AM, Pargeter, Christie :CO IS wrote: > > ** > > When I look in Crystal Report it is there. Also, this report works in the > user tool as designed (with the external field) but not in the web. > > > ------------------------------ > > *From:* kimberly.sant...@oracle.com santana [ > mailto:kimberly.sant...@oracle.com <kimberly.sant...@oracle.com>] > *Sent:* Thursday, March 10, 2011 8:37 PM > *To:* arslist@ARSLIST.ORG > *Cc:* Pargeter, Christie :CO IS > *Subject:* Re: Issue with a report > > Did you check to make sure that this field 'ARSYS_SERIAL_QUAL_COLUMN' is > on the form NTE_Notifier_Log? > > Kimberly > > > On 3/10/2011 7:24 PM, Pargeter, Christie :CO IS wrote: > > ** > > I am trying to build a report against the NTE:Notifier Log screen and if I > put any quals on the Active Link I get > > > > This field name is not known. Details: errorKind Error in File > C:\WINDOWS\TEMP\CLUserHistory {200BA716-D86C-4D45-9F30-0913A657F293}.rpt: > Error in formula . '{NTE_Notifier_Log.ARSYS_SERIAL_QUAL_COLUMN} <> > "4\3\1\3\2\7\1299744000\"' This field name is not known. Details: errorKind > > > > This has ('Submit Date' >= $Start Date$) as the qual. But if I leave > quals empty on the Active Link the report will run. Eventually, I want to > use a External qual on this report. I thought I had this running a couple > of months ago but just tested it again and now it is broken. > > > > ARS 7.1 p 6 > > ITSM 7.0.3 p 9 > > Window 2003 > > MS SQ 2005 > > IIS/Tomcat > > RKM 7.2 p 4 > > MidTier 7.5 p 7 > > > ------------------------------ > > > *Christie Pargeter * > *Legacy Health** *** > > *IS - Programming* > > *SR Technical Analyst*** > > cparge...@lhs.org > > * **1120 Building* > > tel: 503-415-5149 > > > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > ----------------------------------- > Computacenter AG & Co. oHG, mit Sitz in Kerpen (Amtsgericht Köln HRA 18096) > Vertretungsberechtigte Gesellschafter: > Computacenter Aktiengesellschaft, mit Sitz in Köln (Amtsgericht Köln HRB > 28384) > Vorstand: Oliver Tuszik (Vorsitzender), Dr. Karsten Freihube, Hans-Georg > Freitag, Frank Kottmann, Reiner Louis > Aufsichtsrat: Michael Norris (Vorsitzender) > Computacenter Management GmbH, mit Sitz in Köln (Amtsgericht Köln HRB > 28284) > Geschäftsführer: Ulrich Irnich > Visit us on the Internet: http://www.computacenter.de > Visit our Online-Shop: https://shop.computacenter.de > > This email is confidential. If you are not the intended recipient, you must > not disclose or use the information contained in it. If you have received > this mail in error, please tell us immediately by return email and delete > the document. > ----------------------------------- > > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"