Search results for query: *

I started a previous thread to figure out how to create the crosstab with my data. Now that we have auditors asking for some data, I need to figure out how to get it out of my data. Here is the link to the previous thread: http://www.tek-tips.com/viewthread.cfm?qid=1593712 Basically, this is...

For all those LiveCycle Designers (v8.2) out there, I have been able to create the dynamic form so the fields expand as needed, even going to another page if there is a lot of information. The problem I've run into however is that I've had to add more dynamic fields and have run out of space on...

Hello all. I am an Excel expert, but I've never had to do VBA coding in macro's, so I guess I'm not too much of an expert then! The issue I have is I have a report that looks something like this: Class Name Instructor Class Date Class...

I was able to get assistance with my previous group selection formula and it worked wonderfully. The problem is that they changed how the data is stored and now it is in text where it was numbers in the past. Let me give you an example of my data. We are trying to find the "Perfect Days" in...

I'm currently using CR XI and have a report that has two Excel OLE objects. I copied them over from another report and they both showed up and printed perfectly on my new report. However, now one of them shows up as a black box. See the attached photo below for example: the top object is fine...

I originally created a running total of my data that shows in the report footer and works perfectly. Now my boss wants a chart (when he didn't originally) and I know that running totals don't work in charts and I'm having a heck of a time trying to figure it out without a running total. Here is...

After a few years of not being able to use Crystal (different job), I was thrust back into Crystal and was given a report to do. I'm not sure how to describe what I'm looking to do so I'm going to try to recreate the problem below. Example Data ********** Microsoft Excel Chad Oglesbay...

Hello all. I am an educator and am looking to create a report to help me figure out who is NOT enrolled in a class. Right now we have the ability to create reports showing whose is currently enrolled in what class and when. If I have a list (text file) of all the students who should be...

I concider myself an average user and am having issues here with this problem. What I am trying to do is to create a report that has an average at the bottom. In the details I am using a formula (say it is [Total Time]) to find the difference in the start time and end time. Then in the report...

I am using Crystal XI and am trying to create a report with two dynamic parameters. The first parameter is to select the correct office and then the second parameter is to select the department within the office. I would like the ability to select multiple departments or select all of them. I...

Let me start off by giving some background. I work with a hospital system with multiple hospitals and we would like to create a report that allows us to first select the hospital and then select the corresponding cost centers within that hospital. The details would be the classes attended by the...

Hi all. My start times and end times are set as string and stored in military time without seconds. (eg. 14:45) What I would like to do is have the converted into actual time or a number, which ever one will allow me to calculate the difference between the two. I saw many threads on changing...

Hello all. I have a report that returns evaluations from every class that we teach. We normally teach all-day classes so when we run the report it is easy to take out the daily evaluations. Well, we just started teaching a few half-day courses and I can't figure out how to get the group in our...

Hi all. First of all, I'm using Crystal XI. What I have is a database of class evaluations. There are three questions that are important to us and they can grade us from 1 to 5 (5 being the highest). What I want to do is create a formula that counts the evaluation if it is a 4 or higher. I've...

Hi all. I have a report with about 2,000 names grouped alphabetically. What I would like to do though is have a group heading of just the first letter. For example: A Adams, John Ashley, Jennifer B Breckenworth, Steve Busby, Mary C Christy, Stephen Crosby, Bill Does any one have...

I have created a wonderful report that shows the answers to certain questions. The answers are simply labeled as 1 thru 5. What we then want to find out is how many answers are below a 4 and then what percentage that is. We have been able to do this with functions and formulas with ease for each...

Hi all. I'm creating a report where I want to count each time the word "Canceled" appears in the field "xclass.name". Is it possible to do this with a formula? I would like to then add a running total at the bottom so I can get a total as well (I know how to do this though). And ideas on this...

Hi all. I am trying to create a report using CR XI and am starting to run into problems. What I want to create is a quarterly report that will show each training class that we have taught, how many completed, how many canceled and how many did not show. There are three variables that we use for...