And with BIRT (Business Intelligence Reporting Tools, a FREE open source reporting tool from Eclipse for which BMC built plug-ins that work with ITSM), you can modify RPT files and build variables like the ones that would be needed for the calculations I mentioned. I don't know if you can do that with Crystal or not, since I've never had the opportunity to design a Crystal report.
However, be aware that BIRT isn't as user-friendly as some other reporting tools are (it's probably a hazard of it being free and open source). Fields are brought over in field ID order and you can't sort them by name. It also looks to me like they bring over EVERY field, so you have to really know the form you're reporting against. Finally, I think you need to know a bit more raw SQL to build your queries than you do with other reporting tools. But if cost of a reporting tool is an issue and you don't mind putting some time in to ascend the learning curve, BIRT looks like it gives you a LOT of control over what the report looks like, and it lets you do sub-reports, something I see as being an extremely powerful and useful feature. Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA [email protected] ITSM 7.6.04 SP2 – Windows 2003 – SQL Server 2008 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Westbrock Sent: Friday, March 15, 2013 9:18 AM To: [email protected] Subject: Re: [EXTERNAL] Re: Date Query If you have a copy of Crystal Reports Designer (or whatever the current name is for the desktop tool) you might be able to save the query in the report and then call the RPT file from Remedy. I know for sure it can do the current week/month but it's been a few years (and I don't have the tool anymore) so I'm not sure if it had keywords for previous time periods or not. -Rick ___________________________ Rick Westbrock Support to SPAWAR – IT Service Management Project, Code 54520 QMX Support Services Office (619) 524-2303 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Stroud, Natalie K Sent: Friday, March 15, 2013 8:15 AM To: [email protected] Subject: Re: [EXTERNAL] Re: Date Query And keep in mind that in January, your previous month query has to account for the change in year as well as the change in month. Analytics has some variables built in to the Universe for every important date field that make this kind of calculation really easy, but to do it manually? It's not going to be pretty no matter how you approach it. I'm certainly no expert in how to best accomplish things using Remedy code, but from a pure logic standpoint, it seems like you'd have to use a substring function to pull out both the month and year of the date you are looking at, calculate the previous month and year based on those values, then query for tickets whose dates have month and year values that match the previous month and year values you calculated. Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA [email protected] ITSM 7.6.04 SP2 – Windows 2003 – SQL Server 2008 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Friday, March 15, 2013 8:10 AM To: [email protected] Subject: [EXTERNAL] Re: Date Query Yes, that would give me the last 30 days, but what I am looking for is last month. This being March I want the incidents created in February regardless of what day in March I run the report. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Lisa Singh Sent: Friday, March 15, 2013 10:06 AM To: [email protected] Subject: Re: Date Query > if it can be done for last week or last month. > Use this as a qualifier to find tickets logged in the last 30 days - or $DATE$ but I always use $TIMESTAMP$ for no particular reason. 'Reported Date+' > $TIMESTAMP$ - (30*24*60*60) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
