Re: AR System 7.5

2008-10-09 Thread Marc Burick
Dave, Last I heard, which was last week, is this quarter. Still, no definite date has been set. Marc Shellman, David [EMAIL PROTECTED]

WPOSTEMsg

2008-10-09 Thread Fritz Cornelissen
Hi All, Which Remedy API can I use to talk to Tivoli wpostemsg? Kind regards, Fritz ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Daniel Bloom on Sympatico
{\rtf1\ansi\ansicpg1252\fromhtml1 \deff0{\fonttbl {\f0\fswiss Arial;} {\f1\fmodern Courier New;} {\f2\fnil\fcharset2 Symbol;} {\f3\fmodern\fcharset0 Courier New;} {\f4\fswiss\fcharset0 Arial;} {\f5\fswiss\fcharset0 Times New Roman;} {\f6\fswiss Tahoma;}}

Progress Bar on New

2008-10-09 Thread Timothy Rondeau
Hi all, Trying to do some training on the web and users noticed that the Progress bar is not selectable on new. Modify is fine, New is not there. Web, no drop down: Client side: Anyone ever run into this issue something not showing up in the web? The Changes show up in

Error when runing reports via the web [ARERR 9260]

2008-10-09 Thread rdalton
Env = Unix Solaris / Oracle / ARS 7.01 / ITSM 7.03 Customer attemps to run canned report via web interface and receives the following error: Error during processing : ARERR [9260] Report location is missing from report settings configuration page. Please see your administrator. When I look up

Re: Error when runing reports via the web [ARERR 9260]

2008-10-09 Thread Matt Reinfeldt
The latter, Robert. You must have a BOXI server, or Crystal Reports Server v10 or 11 installed and then you configure your mid-tiers to use it to display reports. All the information is in the Mid-Tier 7.x Guide, since you need to install a piece of the Mid-Tier, the Crystal ARWeb Viewer on the

Re: Error when runing reports via the web [ARERR 9260]

2008-10-09 Thread Frank Caruso
You need a Business Objects reporting server setup in order to run Crystal reports on the web. On Thu, Oct 9, 2008 at 9:07 AM, rdalton [EMAIL PROTECTED] wrote: Env = Unix Solaris / Oracle / ARS 7.01 / ITSM 7.03 Customer attemps to run canned report via web interface and receives the

Error when runing reports via the web [ARERR 9260]

2008-10-09 Thread Robert Dalton
Env = Unix Solaris / Oracle / ARS 7.01 / ITSM 7.03 Customer attemps to run canned report via web interface and receives the following error: Error during processing : ARERR [9260] Report location is missing from report settings configuration page. Please see your administrator. When I

Re: Archiving

2008-10-09 Thread Russ Grant
Gary, Not sure if you saw my recent post on archiving but I had a problem with archiving that was related to the form being archived (not the archive form itself). A filter that triggered on a delete to send a notification was preventing the archive process from executing - actually it would

Re: Copy Prod Environment to Dev Environment

2008-10-09 Thread Grooms, Frederick W
Mid-Tier patch 2 to patch 4 is not an issue as the Mid-Tier install does not do anything to the database. You need to upgrade the Prod CMDB to 2.1, then it is a simple matter to copy (Backup/Restore) the database. NOTE: Save the database data that holds the license information on Dev first so

Re: Copy Prod Environment to Dev Environment

2008-10-09 Thread Chowdhury, Tauf
Joe, if you are on Oracle let me know. I may be able to help you with a slight backdoor method to copy your prod DB to Dev after blowing up your dev DB, by copying just the structure, meta data, and configuration data, and leaving all your main application data on prod.. What is this method?

Re: Progress Bar on New

2008-10-09 Thread Pierson, Shawn
I've never run into that. The first thing I'd try would be clearing the cache on the Mid Tier, and if that doesn't work, go into the Admin Tool and look at the form. If the Save button is available, click it, and try again after the Mid Tier re-caches. From: Action Request System discussion

UKRUG Registrations Now Open

2008-10-09 Thread Dave Saville
Less than a month to go to the UKRUG ( UK Remedy User Group) on November 5th in London at One Great George Street, Please register your interests Technical or Business streams so we can gauge how may people are in each stream.  Confirmed topics So far: BMC - Blade Logic how will it fit with

Re: Error when runing reports via the web [ARERR 9260]

2008-10-09 Thread rdalton
I thought it might be something like that - thank you so much for the quick response - greatly appreciated! (btw - sorry to everyone for the double thread - total noob) Matt Reinfeldt wrote: The latter, Robert. You must have a BOXI server, or Crystal Reports Server v10 or 11 installed

Re: Show Check box on table field

2008-10-09 Thread Kemes, Lisa
This works for dropdown boxes too! I just love this list! Thanks for the info Gordon! Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank, Gordon M. (CMS/CTR) Sent: Thursday, September 25, 2008 12:49 PM

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Rick Cook
Yeah, lot of that going around. Many placement firms don't seem to know the going rates for Remedy developers, which means that they can't educate their customers about same, so they end up billing us out like offshore Java guys, driving rates down all over. One large firm I spoke to didn't even

Re: Progress Bar on New

2008-10-09 Thread strauss
I actually remember something like this from 2006 or so... in a very early version of ITSM 7 on mid-tier 7.0.01. I think the drop down was visible, but did not work at all. I seem to recall one of the early patches fixed it. What patch levels of mid-tier and ITSM 7 are you running? I

Re: Copy Prod Environment to Dev Environment

2008-10-09 Thread Savant, [EMAIL PROTECTED]
One other item worth mentioning: Support is adamant that they will not officially support the database copy method. You can do it and they will still provide support, but if the underlying root cause of the problem turns out to be a direct result of the database copy, they will NOT provide a

Re: Progress Bar on New

2008-10-09 Thread Timothy Rondeau
We are on patch 2, which I was just testing our Test server works fine, Dev server does not and prod does not. So something else going on. All systems are on the same patch 2 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]

Re: Progress Bar on New

2008-10-09 Thread strauss
..also, your screen shot makes it look like you have customized the Incident form view somewhat. If so, there is always that chance that you have changed the layering of objects in the view and hidden the button under something else. Things like that usually require that you re-save the form,

AR System 7.5

2008-10-09 Thread Shellman, David
I had expected that BMC/Remedy was going to make an announcement about 7.5 at User World. Since User World was canceled, news concerning 7.5 has been sparse. Anyone heard any recent news? Thanks, Dave Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] Tyco

Remedy Developer Position (Mid to Sr Level) Colorado

2008-10-09 Thread Jay parker
Remedy Software Engineer Employment Status: Full-Time APPLY ONLINE ONLY: http://recruiter.kenexa.com/corpexp/cc/CCJobDetailAction.ss?command=CCVi ewDetailjob_REQUISITION_NUMBER=132422ccid=1sn5RRaP6Ig%3D LOCATION: Broomfield, CO REPORTS TO: Manager Remedy Services RESPONSIBILITIES:

Re: Show Check box on table field

2008-10-09 Thread Frank, Gordon M. (CMS/CTR)
You're welcome! Gordon M. Frank Remedy Skilled Professional ITIL V3 Certified Lockheed Martin From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, October 09, 2008 9:44 AM To:

Re: Laid Off

2008-10-09 Thread Robert Molenda
I'm a Principal Consultant for Infosys Technologies - we are normally looking for people - meant to send that off-list - but the 'reply-to-button and lack of coffee' feature on gmail still exists... On Wed, Oct 8, 2008 at 5:09 PM, Robert Thomas [EMAIL PROTECTED] wrote: Yes, What type company

Re: AR System 7.5

2008-10-09 Thread Joe DeSouza
The beta tests however must be soon enough as I noticed that from about 2 weeks you have the option or raising a Trouble Ticket citing it as a ARS 7.5 problem as 7.5 is already made available on the version list.. Joe - Original Message From: Marc Burick [EMAIL PROTECTED] To:

Re: Copy Prod Environment to Dev Environment

2008-10-09 Thread Joe DeSouza
Its basically oracle exports taken in segments, first the structure only, then data from the T tables excluding data from applications by taking data from tables whose form names begin with prefixes like CFG or SHR or User or Group etc, I have a whole list of them if you need.. Then take data

Re: Laid Off

2008-10-09 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
Ahh, but gmail does have the mail goggles feature. Perhaps this new feature would assist in the prevention of accidental emails being sent to the list? I know I've sent a few in my career to the list that were intended to be directed towards individuals.

Re: Copy Prod Environment to Dev Environment

2008-10-09 Thread strauss
Probably because there is such a _long_ list of things in the ITSM 7, AIE 7, and SLM 7 applications that you have to manually fix after the restore. I am still discovering and documenting new ones. So far I have documented these over the last month+. It might be a little choppy since they

Re: Laid Off

2008-10-09 Thread Robert Molenda
I can do MATH when I'm asleep and deprived of coffee :) Saw that the other day and thought - hum now people will have calc open all the time :) On Thu, Oct 9, 2008 at 8:50 AM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] wrote: Ahh, but gmail does have the mail goggles feature.

Re: Laid Off

2008-10-09 Thread Rick Cook
Yeah, I had the same thought - I'd need something more difficult than simple arithmetic to thwart a stupid email. Like a hammer that pops out of my laptop and says Hey, you're about to send a stupid Email! Rick On Thu, Oct 9, 2008 at 8:58 AM, Robert Molenda [EMAIL PROTECTED]wrote: ** I can do

Re: Laid Off

2008-10-09 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
Lol, they need to add some advanced heuristics to gmail to check to see how dumb your email will really be! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, October 09, 2008 11:09 AM To:

Re: Copy Prod Environment to Dev Environment

2008-10-09 Thread Nowak, James
Does anyone have a documented method to do this in 6.3? Jim Nowak Infrastructure Tools OfficeMax Inc. 630-438-7365 w 630-414-0193 c -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Thursday, October 09, 2008

Re: AR System 7.5

2008-10-09 Thread Alan Blake
The BETA test is still underway. I understood they are targeting early next year. Alan _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, October 09, 2008 9:40 AM To: arslist@ARSLIST.ORG Subject: Re: AR System

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread William Rentfrow
Not even - $55 inclusive? That's $2200/week. My travel expenses for this week alone are about $3200. Granted that's a bit expensive... William Rentfrow Principal Consultant, StrataCom Inc. [EMAIL PROTECTED] 701-306-6157 C -Original Message- From: Action Request System discussion

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Drew Shuller
At that rate, travel/living expenses would have to be minimized. That could be done if you have a one-bedroom apt and had three roomates. I can read the writing on the wall. In Joshua's defense, he knows the going rates. He won't contact anyone directly if a contract is below their rate. Drew

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Joe DeSouza
55 in Baltimore is less than junior rates.. Gas is perhaps the most expensive in the US in the DC / Virginia region - whats it like there now 4 buck 50 to a gallon? And if you choose to live in the outskirts of Baltimore which might be cheaper on rents, you'll still end up paying the difference

Gary A Roach/K-CORP/KMT/KMT is out of the office.

2008-10-09 Thread Gary Roach
I will be out of the office starting 10/09/2008 and will not return until 10/13/2008. I will be checking email / v-mail regularly. If you need to speak with someone immediately please call (or email) Kim Hawley at 724-539-6145 or Kathy Bangor at 724-539-5648.

Re: Archiving

2008-10-09 Thread Chintan Shah
As far as what I have seen, when you start archiving,  all filters that fires on Delete and are Enabled on source form are executed(tested with Delete From Source option). One weird thing, I have seen is, even if you turn off Delete workflow at the time archiving is happening, it still

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Joe DeSouza
55 all inclusive would be even worse.. might be just a wee bit manageable if it were 55 an hour with 95% remote work so you cut down travel expense to 5%. Something like a day every 2 or 3 weeks on site IF there is no air travel involved.. ELSE it hardly would make a difference.. IMHO at most

Re: AR System 7.5

2008-10-09 Thread Joe DeSouza
When did the Beta start? We are signed up for it and I didn't get a heads up about having received access to download the code? Joe - Original Message From: Alan Blake [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, October 9, 2008 12:26:58 PM Subject: Re: AR System 7.5 **

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Rick Cook
Well, it's all about what a willing seller and a willing buyer will agree to. I don't see the logic in working for that kind of rate - many perm jobs pay more, with full benefits. I guess pathetically low rates like this will be offered as long as qualified people accept them. Others have to

Re: Show Check box on table field

2008-10-09 Thread Jason Miller
We also use a checkbox in a table field. Pretty cool feature! We do have issue with people using WUT 7.0.01 with patches 5 6 cannot use a button to check all. Funny thing is that it works fine in 6.x clients back to 6.0.1 patch 1321 and no problems with 7.1. We haven't noticed any problems

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Joe DeSouza
That really depends on the definition of 'qualified' people doesn't it. I mean why would someone who is really qualified (in the true sense of the word) accept something lesser than what he/she thinks she is capable of making. Especially when you know that the city you are going to be working

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread William Rentfrow
I agree on Josh's knowledge, etc - I have talked/emailed him a few times myself. I certainly wasn't trying to give him a hard time - just commenting on the market in general... William Rentfrow Principal Consultant, StrataCom Inc. [EMAIL PROTECTED] 701-306-6157 C -Original Message-

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread William Rentfrow
The single worst rate I have ever seen was after the tech bubble burst in late 2001 or so - it was $35/hr all inclusive. I hope we're not headed that direction againif so I may take up breadmaking or some other tangible products career :) William Rentfrow Principal Consultant, StrataCom

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Drew Shuller
I saw a rate like that about 18 months ago. I doubt if that one got filled. Otherwise, it's a race to the bottom, and at some point, a lot of us will lose their jobs if we're not willing to compete on the world market. Yes, a lot of the people on this list still have great jobs that pay a lot.

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Joe DeSouza
I may take up to bar tending :-) I look more like a bar tender anyways than a software developer! Might fit in there real well - Original Message From: William Rentfrow [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, October 9, 2008 2:42:57 PM Subject: Re: Job: Remedy

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread J.T. Shyman
What, prey tell, does a bartender look like? Or a software developer for that matter? :-) --- J.T. Shyman _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, October 09, 2008 2:53 PM To: arslist@ARSLIST.ORG

database instance move

2008-10-09 Thread sivarama velicheti
Hi group, We need to move the ARSystem database from the old SQL instance to a new SQL instance. Can you please let me know what the application connection strings (like changing the database name in ar.cfg etc.) may be changed? What are the steps to be followed for that, or what

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Joe DeSouza
Actually to come to think of it there's a very little difference :-) But I'm one of those who wears my hair long and a few earings and have even got mistaken for a musician at a concert that I was at recently.. Might not sound like me at all but that's how I go around in casual.. Joe -

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Sanford, Claire
Wow! that was almost a description of Rick Cook (j/k) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, October 09, 2008 2:07 PM To: arslist@ARSLIST.ORG Subject: Re: Job: Remedy

Re: AR System 7.5

2008-10-09 Thread Alan Blake
The open BETA started beginning of Sept. You can send an inquiry here [EMAIL PROTECTED] Alan _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, October 09, 2008 11:51 AM To: arslist@ARSLIST.ORG Subject: Re: AR

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Tim Widowfield
Try this: What'll it be? Hmmm? Try that. Come on. We haven't got all night. Try it. What'll it be, HM --Tim - Original Message From: Joe DeSouza [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, October 9, 2008 1:53:10 PM Subject: Re: [ARSLIST] Job: Remedy

Re: database instance move

2008-10-09 Thread Joe DeSouza
All you need to do then is make sure that the ARAdmin account has the same password. The password is encrypted if changed from the default and resides in your ar.cfg file. If you do not find the password line in the file it means you are using the default password. Other than that there is not

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
Of course, I went out to bmcelite.com to see your profile. Unfortunately, you've not yet set one up. C'mon Joe, stop slacking... Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, October 09,

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Joe DeSouza
I wanted to go in as Jack Sparrow 2 Halloweens ago and didn't need a wig if I had :-) I went in as a vampire from the Covenant instead.. - Original Message From: Sanford, Claire [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, October 9, 2008 3:09:57 PM Subject: Re: Job:

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Rick Cook
To all of the recruiters who post here: We always appreciate it, and we're not trying to bash you. But please, for your good and ours, some of you need to do more research on what appropriate rates are for senior Remedy developers, and make it clear to your customers that those rates are higher

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Rick Cook
Claire, dear, I'm afraid it's been too long since you've seen me. :) For those who have not had the pleasure, no one would confuse me with a rock star. Unless it was one of those guys from the '70's bands who let himself go a bit... Rick On Thu, Oct 9, 2008 at 12:09 PM, Sanford, Claire

Re: Job: Remedy Developer (Mid Level) - Contract - Baltimore, MD - Kforce

2008-10-09 Thread Warren Baltimore
Sounds like my last design meeting I guess the jobs really are similar. On 10/9/08, Tim Widowfield [EMAIL PROTECTED] wrote: ** Try this: What'll it be? Hmmm? Try that. Come on. We haven't got all night. Try it. What'll it be, HM --Tim - Original Message From:

Re: Search vs. Modify

2008-10-09 Thread Kemes, Lisa
OK, here's another one, I'd like to lock down a drop down list field, but I would like the user to be able to type in the field when they are searching. The reason is: when they select the drop down list (list A), they have to first select 2 other drop down lists first (to get the data for the

Issue with Product Name

2008-10-09 Thread Begosh, Kevin
Hi all, I am having an issue with Remedy in that when a incident is resolved the product name field is being blank out. This is nothing I did, so it is out of the box code. We are on AR Server 7.1 patch 3, Server Desk 7.03 patch 7, and SQL 2005 server, and Windows 2003 AR Server. I have

Re: Search vs. Modify

2008-10-09 Thread Rick Cook
Or you could have Change Fields active links that fire on the various Window Types. On Query, it would leave the fields all enabled. On Modify, each field would only be enabled if the preceding one was populated and validated. Rick On Thu, Oct 9, 2008 at 12:59 PM, Kemes, Lisa [EMAIL PROTECTED]

Re: Search vs. Modify

2008-10-09 Thread Kemes, Lisa
Wow!! Thanks Rick, I would have never thought of that trick. Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, October 09, 2008 4:07 PM To: arslist@ARSLIST.ORG Subject: Re:

Re: Search vs. Modify

2008-10-09 Thread Reiser, John J
Lisa, You would have to do some ARS magic. Add a DO field in the same position as your dropdown. On Open window with $OPERATION$ = Query do a Change Field Active Link to Show the display_only_ARS_Magic field. On search you will need to build the qualification in your hidden Query Bar (field ID

Re: database instance move

2008-10-09 Thread Hugo Ruesga
You must change all the references to the ar.cfg file (ar.conf) regarding your current instance. Also you must check and be sure that your host file has been update if your hosts name changes for the app server and the db server (just in case that the db is set on a remote location). An

OT: Remedy Developer Position (ITSM 7.x) Tuscaloosa, AL

2008-10-09 Thread Timothy Powell
KPBS, Inc. is looking to immediately fill a positon for: Remedy DEVELOPER/Engineer TYPE: Contract Position TERM: 1 year with possible extensions PROVIOSIONS: Contractor must be able to pass a Moderate Risk Level-Public Trust background check LOCATION: Client site is in Tuscaloosa,

Re: AR System 7.5

2008-10-09 Thread Easter, David
Information on the beta programs, and the expected release timeframe for AR System, was posted to the ARSList in July, 2008 - but can also be found on the BMC DN here: http://developer.bmc.com/communities/message/79512#79512 -David J. Easter Sr. Product Manager, Solution Strategy and

Crystal Question

2008-10-09 Thread Steven Iocco
Hi folks, this should be a no brainer but I cannot wrap my head around it. Trying to do a formula to put N/A in a field on my report if the last resolved date is null. Here is my formula if {HPD_Help_Desk.Last Resolved Date}= then N/Aelse {HPD_Help_Desk.Last Resolved Date} It returns A

Re: AR System 7.5

2008-10-09 Thread Shellman, David
** David, That was July and this is October. Many things have changed since July. No 2008 BMC User Group for one. I don't have my Carnac hat on for this one. Is 7.5 still on schedule? Dave - [EMAIL PROTECTED] (Wireless) From:

Re: Crystal Question

2008-10-09 Thread SUBSCRIBE arslist Melissa
Can you try the is null function? if isnull({HPD_HelpDesk.LastResolveDate}) then N/A' else {HPD_Help_Desk.Last Resolved Date} Steven Iocco [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/09/2008 07:06 PM Please respond to arslist@ARSLIST.ORG

Re: Crystal Question

2008-10-09 Thread Steven Iocco
Hi, yes I have. I get an error saying a string is required here and highlights the {HPD_Help_Desk.Last Resolved Date} after the else. Thanks Date: Thu, 9 Oct 2008 19:12:15 -0500From: [EMAIL PROTECTED]: Re: Crystal QuestionTo: [EMAIL PROTECTED] Can you try the is null function? if

Re: Crystal Question

2008-10-09 Thread Joe DeSouza
Steve, Try if {HPD_Help_Desk.Last Resolved Date} is null then N/A else {HPD_Help_Desk.Last Resolved Date} Joe - Original Message From: Steven Iocco [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, October 9, 2008 8:02:00 PM Subject: Crystal Question ** Hi folks, this should

Re: Crystal Question

2008-10-09 Thread Joe DeSouza
My bad about the last email.. Melissa got the right syntax.. what I wrote would be good for SQL comparison in a DB Cheers Joe - Original Message From: SUBSCRIBE arslist Melissa [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, October 9, 2008 8:12:15 PM Subject: Re: Crystal

Re: Crystal Question

2008-10-09 Thread SUBSCRIBE arslist Melissa
if isnull({HPD_Help_Desk_Work_Info.Last_Resolved_Date}) then N/A else cstr({HPD_Help_Desk_Work_Info.Last_Resolved_Date}) This works for me. I added the cstr to the else statement. Steven Iocco [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG

Re: Crystal Question

2008-10-09 Thread Steven Iocco
Thanks Meilissa and Joe, this works. Date: Thu, 9 Oct 2008 19:49:35 -0500From: [EMAIL PROTECTED]: Re: Crystal QuestionTo: [EMAIL PROTECTED] if isnull({HPD_Help_Desk_Work_Info.Last_Resolved_Date}) then N/A else cstr({HPD_Help_Desk_Work_Info.Last_Resolved_Date}) This works for me. I added