Recent content by Johnkylex

I would like to be able to take a years worth of data, see what the top ten issues would be for a particular week, and then take those top ten issues and graph them showing the total number for each one on a monthly bases. Thanks, John

This is what I have, however it only shows in the report the entries that have all five levels filled. It is still missing the ones that have some blank code levels. totext ({443 MFP Life Database.TRACK_1}); totext ({443 MFP Life Database.TRACK_2}); totext ({443 MFP Life Database.TRACK_3})...

Great...that works...now...two more things... 1. each group is now one work...how would I insert space to define each one even though it is considered one field now? 2. What is the format of formula I would use to make Crystals recognize any code field that is blank...in my case all four code...

Can you give me an example of what that formula would look like? THANKS!!!

I have a table with field headings with similar data of headings..then there are entries like this Code1 Code2 Code3 Code4 Usage Usage OpPanel Symptom Prntqual Roller Used Usage Symptom Prntqual Cart Refilled What can I do to have crytsals calculate the number of...

Is there a way Crystal can calculate a linear regression on a set of numbers on a month to month bases?

What I did was create a blank report with no database links...then I imported subreports into the main report. There are no links that I can find. Is it possible to have the one main report pull information from the 17 databases even if the 17 databases have nothing in common IE link key or...

I tried that...and the subreport came back blank. What am I doing wrong? Thanks!

Thanks! How do you link them?

I have one report that has 17 subreports in it. The subreports are based on seperate databases. The main report shows the data for each subreport. I want to be able to go to the main report, select certain dates and the subreports send back the information based on the date selected by the...

Yes...what I want to show is a chart of the top ten calls, then 10 seperate charts for each top ten with its total for each month. The year can play a apart in the charts. Thanks

I am using 8.0

I am back again... Now I am charting data. In my report I have the top ten issues shown broken down by the four products offered. I then have caculated the % of those calls based on total number of calls we have. So in my chart I want to show the top ten problems with each problem broken down...

I need to calculate calls coming into a center. The calls are broken down into hardware and software calls. I need to calculate for each month the number of hardware and software calls and show that on a report. Next I need to show on a monthly bases a certain problem a customer is calling in...

Thanks....so would the formula be Count ({TEST.GROUP}) = "H"