Search results for query: *

Thanks h0h0h0.. I like this idea. Now hopefully the end-user will buy off on this. So simple I couldn't see the tree for the forest. Thanks again.

I am creating a stacked line chart from a helpdesk database using speed_of_answer, avg_talk_time, pct_abandons. I have created the chart and can display speed_of_answer & avg_talk_time ( for example avg_talk_time is 6.25 sec but they actually want the data label to be displayed as 6:15 sec ). I...

Thanks a lot Howard. This worked great.

The formula (@SUM_VAL) I want to summarize at report level is not in the detail, it is in the CASE group. Summarizing the @NEW or the @ORIG gives the incorrect number.

Since Crystal doesn't allow me to summarize a summary field how would I get a report summary. I have a detail line for a CASE with a newvalue field and an originalvalue field. I have 2 formulas that for each value. @NEW: if newvalue then 1 else 0 @ORIG: if originalvalue then 1...

Ken, I had already changed it to match yours. This is a very useful formula and kudos to you for creating it. Thanks Randy

Ken, I just took a look at you formula on the FAQ and it is correct. The formula supplied by Jean-Paul left out the '+1' on the 'Days:=' assignment statement. Randy

Ken, I have not included the holiday piece yet but I will after I talk to the end users to find out exactly which holidays they want to exclude. I will also check the FAQ above to for any differences. I did test this one against 3 different months and it worked just fine. Thanks Randy

Ken, When I subtract my start date from end date I get 1 less day than what is in the month. Ex. subtract 3/1/2002 from 3/31/2002 I get 30. This would be because the subtraction isn't inclusive so adding 1 more day is what is needed. Randy

Thanks Jean-Paul, This formula works great except it had one less business days in the month than it should have. On the Tot assignment statement I added 1 and now it is showing the correct business days in the month. Thanks again Randy

I am using Seagate Info 7 and trying to create a formula to determine how many weekdays are in a month. If I was using Crystal 8 I could use the Basic Syntax and do loops but I have not found anything about using loops in Seagate Info 7. I was just going to loop through the dates in a month and...

We are migrating Seagate Info 7 APS from one server to another which is not problem, but we are also migrating the reports to a different server. The APS and the reports have been copied to their new locations but when looking at the scheduled jobs they are pointing to reports in their old...