Search results for query: *

I figured it out. In messing with the groupings, the default for @date went to look at each week, instead of each day. It's working well now. :) Thanks so much for all your help!

No suppressed group headers. I changed the @elapsedtime formula to what you said above, and when I checked the formula I got the error "Not enough arguments have been given to this function." I changed the @elapsedtime formula to: if {@Full Name} = next({@Full Name}) then...

The first group is @fullname: {eAgentLoginStat.AgentGivenName} + " " + {eAgentLoginStat.AgentSurName} The second group is @date: datetimetodate({eAgentLoginStat.Timestamp}) The third group is @time: datetimetotime({eAgentLoginStat.Timestamp}) I used your formula for @elapsedtime...

There seems to be a small problem. I used the formula above for the elapsed time in seconds, but it's giving a negative number for some of the breaks. Here is an example: Timestamp Event Type Elapsed Time Formatted Time 8:29:06am Not Ready 327 00:05:27 8:34:33am...

Thank you VERY MUCH lbass. That did the trick. :)

I have a date/time field "Timestamp" that is a date/time an agent changes an Event Type (values are login, ready, not ready, logout). I group on the Agent Name, then on @Date - which is a formula datetimetodate({eAgentLoginStat.Timestamp}). Then I group on time -...

I'm glad to hear it. Thanks lw. :)

Thank you LB. :) I've been writing reports for 2 years and I still learn something new about it every day.

Nevermind, I got it. I removed the group and replaced it. Duh again. :)

Thank you lbass, I had a "duh" moment. I have long since deleted the group name in a previous edit. Is there a way to get it back?

I want my report to show the first day of the week in the group headers for my Timestamp (which is grouped by week). My query is for the lastfullmonth. If I put the Timestamp in the header, it just shows a random date in that 7 day period. Minimum brings the first day of the month...

@Business Days formula: //Main formula WhileReadingRecords; Local DateVar Start := date({HPD_HelpDesk.Create_Time}); // place your Starting Date here Local DateVar End := date({@Resolved or Closed}); // place your Ending Date here Local NumberVar Weeks; Local NumberVar Days; Local Numbervar...

I used Ken Hamady's formulas for Business Days and Business Hours and that works great, but the date/time fields I'm using sometimes report back hours and days that I don't want to include in the scope of my work day, therefore my calculations on time to resolve have strange results and show a...

We support Public Safety, Health, Assessment and Taxation, etc - therefore we need to keep file and database security tight on every level. Each employee has certain security clearances for the specific job they do. It weakens security when everyone is given rights to everything, so giving...

I am aware that I could report from the Oracle database, but we aren't willing to do that because of the multitude of security issues we'd have with it. In addition, the Oracle database calls the tables and fields "T023, T050", etc. We have decided as an organization to have the developers...

Thanks BOjdg2n for a very helpful post. I sent it to my Remedy developers in hopes it will help them find a solution.

Well, I am a government employee, and we have spent lots of money on Remedy, so the vendor isn't an option I can change. :-) Thank you for your help.

I can do subreports, but I don't like to because of the slowness, and I still can't get them all to show in one graph. Remedy uses an Oracle backend. I guarantee I cannot link tables. I have talked with many coworkers who are reporting analysts and with the developers and it won't work...

I'm not getting any error message, I just need all fields to show. :) If I join 2 Remedy tables I get no data - no error message comes up. remedysupport.com says they don't allow reporting software to join tables.

Remedy security doesn't allow Crystal to join it's tables. If I did a join in Crystal it would have to have one Remedy table and one (other database) table, or have the Remedy developers do a join for me so that Crystal views it as one table.