Re: Crystal Report Calculation Question
I don't think you can do a summary there - you need to use a running total
instead.
HTH
Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED]
Brandi Barbour <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
08/26/2008 11:48 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
[ARSLIST] Crystal Report Calculation Question
**
All,
I am trying to calculate (add together) a formula field that is in group
footer 2.
For some reason i can not do a summary of the formula field because it
does not come up in the fields to be summarized.
The formula field is defined as Hours and has a formula of :
{CSC_SES3_WOI_WII_Work_Order_Join.csc_dec_estimated_hours} *
DistinctCount ({CSC_SES3_WOI_WII_Work_Order_Join.csc_dec_estimated_hours},
{CSC_SES3_WOI_WII_Work_Order_Join.Summary})
This works fine.
However now i need to add all the values from this formula and place it in
the group footer 1 section so it will calculate all the time spent for all
the entries under Group 1.
Can not seem to find how to do this.
I have tried just adding the same formula field to the Group 1 footer
section but that just gives me the last entry in group 2 footer and does
not add all the sections together.
Any ideas?
Crystal Reports XI
ARS 7.1.0
ITSM 7.0.3
Thanks,
Brandi __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: OT:Friday Befuddlement
FYI - Does the same thing in Word 2007. Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] "J.T. Shyman" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 03/07/2008 02:17 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject [ARSLIST] OT:Friday Befuddlement ** I ran across this one yesterday and it had me laughing. For those of you that have MS Word 2003?open a document, type the word information and ask it for synonyms or look them up in the built-in thesaurus. Then, realize that this fits perfectly with Microsoft?s corporate vision. --- J.T. Shyman __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Crystal Reports Date problem.
In Crystal, check File --> options --> Fields --> Date --> Date Tab and see what's specified. HTH Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] "sanapala, Rajinikanth IN BOM SISL" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 02/07/2008 08:22 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: [ARSLIST] Crystal Reports Date problem. ** Hello, I checked the window settings (regional) they are in English US and Date format is MM/DD/YY and user tool is in En US. Still I am facing the same problem. Can any one suggest me how to deal this? ARS: 6.3 Oracle 9i Crystal Report 10 Regards, Rajinikanth From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: Thursday, February 07, 2008 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports Date problem. What date format do you have set in Windows (Control Panel >> Regional and Language Options)? I believe the client will use these settings by default. You should be able to set a different date format for the client under Tools >> Options >> Locale. HTH, Thomas - Original Message - From: sanapala, Rajinikanth IN BOM SISL Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, February 06, 2008 22:41 Subject: Crystal Reports Date problem. ** Hello ARS List, I have got a strange problem with my reports, I am entering my Date Ranges in Remedy user in (MM/DD/YY, MM/DD/YY), but when it is retrieving the records from the system it is considering as (DD/MM//YY) And some times query engine error. For Ex: I wanted to retrieve (1/2/2007 2nd Jan to 05/06/2007 may 6th ) it is giving the values from 1st Feb. to 5th Jun. What need to be done to come out of this problem. Thanks in Advance. Rajinikanth. SISL INDIA Important notice:This e-mail and any attachment thereto contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Important notice:This e-mail and any attachment thereto contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Mansur, Joanne is out of the office.
I will be out of the office starting 01/21/2008 and will not return until 01/28/2008. I am away from the office with access to cell phone and email. I will return your message as soon as possible. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Job: Remedy Developer / Boston MA / Perm
Northeastern University is looking to fill a direct hire permanent position for a Sr Remedy Developer. Experience with ARS 7, and ITSM Applications helpful. SQL and ITIL foundations a plus. While waiting for the position to be posted on line, contact me off-line and I will give you more information. Respectfully, Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Friday Humor - Questions that have Confused humankind!!
A mail carrier Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Friday Humor (U)
the way I heard it "EX" is a has-been "Spurt" is a drip under pressure so an "Expert" is a has-been drip under pressure Joanne Rick Cook <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 10/26/2007 02:13 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: [ARSLIST] Friday Humor (U) ** I still remember the best definition of the word "Expert" I ever heard. X is the mathmatical symbol for the unknown. A Spurt is water under pressure. Therefore, an Expert is an unknown drip under pressure. I think many of us might qualify ourselves there... Rick On 10/26/07, Lai, Canhai <[EMAIL PROTECTED]> wrote: Quotes from Stubby... "An expert is someone who knows more and more about less and less until he knows everything about nothing, while a generalist is someone who knows less and less about more and more until he knows nothing about everything." -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Friday, October 26, 2007 6:12 AM To: arslist@ARSLIST.ORG Subject: Re: Friday Humor (U) I've got another one that is self-depreciating humor. I had been debating the benefits of specializing in something like Remedy rather than becoming something more generic like a VB developer. He would say that it was too narrow of a field so there wouldn't be as many jobs, but I argued that the narrowness of the field meant that there were less people who could do it, thus improving the ratio of jobs to applicants in our favor, and that it would pay better as a result. Anyway, a Dilbert comic came out that fit into our debate, except that I had to change the punch line. Shawn Pierson -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hennigan, Sandra H CTR OSD-CIO Sent: Friday, October 26, 2007 8:05 AM To: arslist@ARSLIST.ORG Subject: Friday Humor (U) UNCLASSIFIED Enjoy! Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x251 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Mansur, Joanne is out of the office.
I will be out of the office starting 07/06/2007 and will not return until 07/23/2007. I will not have access to email. I will respond to your e-mail upon my return. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Support Contracts and Escalations and Case Creations A la carte
Back before we switched from basic plus to 24x7 support, we would often pay for the extra service for a weekend of full support during upgrades. It was very helpful, and easy to justify, since the coverage helped to realize the upgrade during off hours, which kept my users happier. HTH Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] Kyle Whitley <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 06/06/2007 11:15 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject [ARSLIST] Support Contracts and Escalations and Case Creations A la carte Just wondering if anyone has be given any a la carte support options from BMC (not any authorized partners). Specifically during upgrade periods and production cut overs. Is there a per incident fee for issues that need to be escalated or created beyond the standard response times listed for agreed upon support level. If I needed to escalate a case and I was on the basic support plan, could I escalate an urgent case based upon some per incident fee? If so what are the prices for doing such an escalation or creation of cases? Thanks -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: OT: Dan Appreciation Day
Ditto! Thanks for all you do! Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] Susan Palmer <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 05/18/2007 10:52 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject [ARSLIST] OT: Dan Appreciation Day ** Dan, I appreciate the efforts you go through to make this wonderful forum available to all of us. Sometimes we are a little unruly but we know you understand. What I can never understand is people that do things that purposely cause you extra effort to maintain this forum. I guess they are just jerks. Thanks again !!! Susan __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Question about search result
** Change your search to 'Create date' >= "09/10/06" and 'Create date' < "09/21/06" and you'll get the results you are looking for. HTH Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] Addis Solomon <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 09/29/2006 10:35 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject [ARSLIST] Question about search result ** When I define an advance search saying 'Create date' >= "09/10/06" and 'Create date' <= "09/20/06", The result is not including the the 20th date. In other words the result is only for < 20 but not including the 20th date. Does anybody know why it is doing this? I greatly appreciate your help. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: saving data as csv file
I open files using taskpad (freeware download) - it's easy to read and doesn't lose the formatting. We have a special field for emplid which can have leading zeros and often causes chaos when someone opens the import file in excel and saves it. All the zeros disappear. Since I've strongly encouraged the use of taskpad the havoc has been lessened. HTH Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] Ron Fariss <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 09/12/2006 04:22 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: [ARSLIST] saving data as csv file Mimi, There are 2 methods for opening a .csv file to see if your formatting is correct. More work / Easier to Read - Rename the .csv file to .txt and then open the new file in Excel and pay special attention to the format for each column. Less work / Harder to Read - Open the .csv file with notepad. Hope this helps. Ron Fariss AIG Technologies Remedy & TelAlert Administration Work: (713) 831-2365 Cell: (281) 782-0979 Ricki Haines <[EMAIL PROTECTED] To: arslist@ARSLIST.ORG DICAL.COM> cc: Sent by: "Action Subject: Re: saving data as csv file Request System discussion list(ARSList)" <[EMAIL PROTECTED] ORG> 09/12/2006 03:08 PM Please respond to arslist Mimi, If you mean you’re losing the formatting of the xls file when saving as a csv file, here’s the fix. If you’ve already changed the cell formats in xls, do it again in the csv file (date formats, etc.). When everything looks the way you want it, save the csv file and DON’T OPEN it again to see if it’s still formatted properly. If you do you’ll see that the format has been lost and you’ll need to format again. If you have a Case ID with leading zeroes, change the format of those to Custom and enter 000 (15 0’s) or however many you have as your input length. It took me a while to get the hang of this, but now I have no problem importing into Remedy. HTH, Ricki Haines On Tue, 12 Sep 2006 12:00:18 -0700, Mimi Lakew <[EMAIL PROTECTED]> wrote: Hello, I am trying to convert an xls file to csv file so I can import the data in remedy as csv file. Can anyone tell me how can I convert the file please? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
