I seem to recall active links having issues with using greater than/less than operators on non-integer fields, including date fields. Have you tried moving the values into some display integer fields and then using those two fields in the qualification?
Regards, Brian Pederson From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Roehr, Mario Sent: Saturday, March 12, 2011 12:52 AM To: [email protected] 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:[email protected]] Im Auftrag von Pargeter, Christie :CO IS Gesendet: Samstag, 12. März 2011 00:50 An: [email protected] 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: [email protected] santana [mailto:[email protected]] Sent: Friday, March 11, 2011 3:43 PM To: [email protected] 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: [email protected]<mailto:[email protected]> santana [mailto:[email protected]] Sent: Thursday, March 10, 2011 8:37 PM To: [email protected]<mailto:[email protected]> 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 [email protected] <mailto:[email protected]> 1120 Building tel: 503-415-5149 _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com<http://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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
