Thank you for your response LJ. I’m a real novice, so, as logical as your suggestion is, it is a little intimidating to me. I was really hoping there would be a simple BIRT function, that would work. I’ll continue to play with it, and hopefully eventually find the solution.
Susan Champagne From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: March-12-15 9:49 AM To: arslist@ARSLIST.ORG Subject: Re: BIRT report: Previous month function; and ability to schedule? ** Susan, Just thoughts off the top of my head....on button press 1 - using MONTH and YEAR functions, collect tmp values for last month, last year, current month, and current year for $DATE$ 2 - Do some sort of calculation that determines if last month is 0, then set it to 12, and if last month is 12, set last year -1 (to capture Dec last year) 3 - Set a Date/Time field = $lastMonth$/1/$lastYear$, set another to $currentMonth$/1/$currentYear$ 4 - now that you have the date/time values for the first of the month for last month, and the first of the month for this month, do an open window action of type report, utilizing the new calculated date/time values from step 3 as qualification of what should be in the report In theory, that should 'always' work for last month data, ensuring the query is 'DateTime' >= $lastMonthDate$ AND 'DateTime' < $thisMonthDate$. This query of course runs in 'your' timezone, so results may vary depending on who presses the button and what timezone they are in...but should work pretty good. On Thu, Mar 12, 2015 at 7:34 AM, Champagne, Susan <schampa...@hsnsudbury.ca<mailto:schampa...@hsnsudbury.ca>> wrote: ** Hi folks, I am struggling with trying to get the correct syntax, using BIRT Functions, to acquire results for “last month”. I am simply trying to pull the list of tasks that were assigned to a particular group. So, for example, I will run the report in any day of March, and the results should display all data from the month of February. Then, in April, I will expect the results to display the March data. I have found several suggestions, online, but none have given the correct results. Also, if you know of a means of scheduling a report to be e-mailed automatically, from Remedy, please let me know. Using ITSM 7.6.04. Your assistance with these questions is most appreciated. Thank you, Susan Champagne Health Sciences North's vision is to be globally recognized for patient-centred innovation. **************************************************************** The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Health Sciences North's vision is to be globally recognized for patient-centred innovation. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
