Search results for query: *

DOH! It was a pilot error. I had misremembered what I had previously done. I was trying to do in a single escalation what I had previously done in two. In two, it works fine...

I've created a form to track metrics for our PCR system implemented using Remedy. I have an escalation that should create a single record identifying the product and week. However, I'm getting several thousand records, one for each PCR. I can't seem to find a method to automatically create...

When I try to log onto a server I'm getting an ODBC error indicating the password isnt' valid. I'm not even getting to the password prompt. I'm using Crystal to access a Remedy database, I've done it earlier this week successfully. The database and server haven't changed. Remedy continues...

I had the same problem. It was the scale-to-fit-page option. Disable it and it seems to print correctly. I have a newer mac, so I don't know if that'll fix your problem, but it did work for me. -Randy

Oh, you mean that detail. Sorry, I completely missed where you were going. That would work acceptable. A better option would be a bar for each week showing the previous two weeks. My ideal chart would be a line chart that shows a moving count for the two weeks prior to each date.

A moving count is more accurate. I think of this data in terms of daily numbers, so I think of the report as a moving average of that number. But a count is more correct. I want to print a graph of the number of entries we get into/close out of Remedy. I want to smoothe out the graph, which...

I'm not interested in how often the data changes daily since I'll only be reporting by weeks anyway. So that could default to any convenient method. My ACTUAL data varies daily, if that is what you are asking. It varies quite a bit, probably in the range of 3-15 per day. I'd say typically...

Can anyone provide a method to create a moving average? I want to graph a moving average of data against time. My records are sorted in chronological order. I want a moving average of the number, basically a count of the records in a two-week time period. I'm using CR version 7 connecting...

that's clever, David. I believe that will work. Thanks.

Thanks guys. I appreciate the help you've given. I'll try reposting as Ken suggested. David's idea seems more complex but looks promising too. -Randy

You are correct, I was getting my terms confused. It is a moving average. I'm not sure what more there is to tell. I started to write something more, but it came out to pretty much what I wrote the last time. Essentially: I am plotting the number of records submitted over a five-week...

Oops, you are correct. It isn't a parameter field, it is a formula field. Sorry for that misinformation. I'm just trying to calculate the number of records between two dates. The problem I had in not using a subreport, was that the dates overlap. I couldn't find a way to get the record...

We're using CR version 7.0.1.100 connecting throu ODBC. The count reference probably falls into the too much information category, it is probably irrelevant. However, to calculate the running average I am generating a subreport between two dates and counting the entries. This value is passed...

I am trying to calculate a running average over time for a graph. I have subreports that collect the data in the date range, get a count and successfully pass the count back to the main report. The count is passed into a parameter field. That works fine. Now when I try to do a line graph, all...

Ken has the problem correct. I need to have dates in the report for which there are no corresponding records. -Randy

I'm trying to group on a date field and use a subreport to show data for the prior two weeks. The data doesn't exist for all dates, so I can't just use that database and group on its date field. I want to group on date fields, but don't have any database containing all the dates I need. Its...