Search results for query: *

Hi, I have a small table that I want to make into an array so that Crystal can compare the records it pulls into the report against this array. How can I convert a table into an array? and How do I iterate through the array to compare each value? Thanks, Michael

Hi, I have a report that shows how many calls were turned around within 24 hours, and how many calls were turned around more than 24 hours. This information is then shown on a graph. I have 2 questions: 1. Is there a way to manipulate the graph so that it breaks it out by month? 2. If a call...

How do you make Crystal count only within a group? I've separated my data into a customer number group, then within that, I have another group of customer reps. How do I count the number of reps for each customer? Thanks, Michael

Hi, I have a pretty complicated problem. I want to count calls made by a call center. They can have 3 outcomes: Completed, Left Message, and No Answer. I want to count calls made to specific customers and track the outcomes, but no more than 3. For example, a rep calls customer XYZ 11 times...

I have a DateAdd function that looks like this: if {ACTIVITY.STARTDATE} > DateAdd(&quot;d&quot;,-1,{?Date}) and {ACTIVITY.STARTDATE} < DateAdd(&quot;d&quot;,15,{?Date}) and {ACTIVITY.CATEGORY} = &quot;Call Report&quot; then 1 else 0 When I run the report and use the date...

I have two detail sections, a & b. The way it prints now is a/b, a/b, a/b...all the way to the end. Is there a way to print all of a, then all of b, keeping all of a together and all of b together? Thanks, Michael

I have two tables, ACCOUNT & USERINFO. They are linked by ACCOUNT.ACCOUNTMANAGERID & USERINFO.USERID. I am trying to replace blank fields in ACCOUNT.CATEGORY with &quot;Call Report&quot; where USERINFO.TITLE = 'Manufacturers Rep'. How can I do this? Thanks, Michael

Hi, I am trying to calculate the time between two fields in a ticket database, [RECEIVEDDATE] and [COMPLETEDDATE]. This is my formula: Local DateTimeVar d1 := {TICKET.RECEIVEDDATE}; Local DateTimeVar d2 := {TICKET.COMPLETEDDATE}; DateDiff (&quot;h&quot;, d1, d2) - DateDiff (&quot;ww&quot...

I'm new to Crystal reports. Is it possible to create a chart based on formula fields? I have a database of account names which I then used formulas to count each account name starting with A's, B's, and so on. I want to show the number of accounts that start with A, B, etc. on a bar graph...