Recent content by MJD500

Hi Gary, That works wonderful BUT now I can't sort by the total because of the Next function I am using. If I sort by the total, it won't work. But so far I have 2 solutions, I can either use the actx viewer an not use the dhtml viewer or I can use the next function but not be able to sort...

Hi, I can't figure out how to implement Madawc's solution above and Gary's solution works only when I use the actx viewer for some reason...but this is what I have in my detailed section right now and I'm wondering if someone has an idea on how I can suppress the numbers of the running total...

Hi Gary, That works well if you are viewing the report with actx but if you view with dhtml or html_frame, it ignores the text box. Thank you for solution. I still haven't tried madawc's solution and will need to use this one for reports being viewed with dhtml. Thanks again Jocelyne

Hi Gary, I did suppress the detailed section but that last group still drills down into an empty page. I will try madawc's solution. Thank you Jocelyne

Hi, I need to suppress drill down on the last group in my report and I don't know how? Can someone help? The reason I am grouping the last group is because I want to show a count for this group within the previous group. GH 1 Service GH 2 Category GH 3 Item if I show Item in details, it...

Very good Rosemary. I changed just the business hours formula to whileprintingrecords and left whilereadingrecords for the holiday formula and I put the holiday formula in the report header as suggested by Ken. It works. Now, I have to be able to display the result in the following format...

Hi, I am trying to save following formula and I am getting an error message: The formula cannot be evaluated at the time specified. I can't figure out what I did wrong. Can someone help? //Main formula WhileReadingRecords; Local DateVar Start := date({SRMIS_REQUEST.CREATE_DATE}); // place...

Hi Seabubble, Actually, I'm having the same issue. I need to calculate the result in minutes also. I wonder if someone else can help? Jocelyne

Thank you. I knew the solution had to be somewhere. That is exactly what I was looking for. Jocelyne

Hi, I did search tek-tips for answers but was not able to find anything BUT if the answer already exists, could someone guide me to the thread please? I have Work Start (Datetime) Work Stop (Datetime) When a resolver group starts working on a ticket, the datetime gets stored in the Work...

Yes! Thanks. I wasn't too sure on how to use the datediff for this one. I got it! Jocelyne

Hi: Thanks for your help Steve. This will work for me I think. But How do I get previous months? for example if month(datetocheck) = month(currentdate) - ?? what to get last month, 2 months ago and 3 months ago? Thanks again. Jocelyne

Hi Anyone: I'm trying to make a manual cross tab to show for each business line GH1 TP CS LAB And then for each month (always 3 previous months), I want to show total # of tickets for each GH1 December January February # Percent # Percent # Percent TP 29 15%...

Hi: I am scheduling about 50 reports to be run in CE and I would like to see a list of all the reports which are currently scheduled along with the frequency, example: monthly, weekly, every nth day, etc... I've been using the CSP query builder and I can't figure out which field would show...

Hi: I need to export a report every week with random information for all 40 agents. Instead of running the report 40 times, I would like to create one report and export 1 word file for each agent. Is this possible? I have to run the report at Midnight Sunday and email it to each different...