Search results for query: *

Using CR2008 I've got a cross tab that seperates data by the Day of Week and also by Hour Of Day. And it's showing volume of alarms. End product looks like 12AM 1AM 2AM 3AM ........10PM 11PM MONDAY 23 45 24 255 ........ 54 43 TUESDAY 44 22 23...

thread767-1457047 Using the below reply, I have a question. lbass (TechnicalUser) 9 Mar 08 17:22 This depends upon your version of CR, which you should always identify. In higher versions, you can suppress all sections within the subreport, format the subreport...

Using Crystal 10 In short, I'm curious how to use results from your main report to drive the search criteria in the sub report. Not sure if this is even possible. We're connecting to Remedy DB but we're unable to do joins on the fly, so we have to create Join forms within Remedy to pull this...

Using C10, i've searched a few times and can't find the answer to this one, but i feel it should be fairly easy. Trying to set up a report to run for the fiscal month - which for us is the 22nd of one month to the 21st of the next. I currently have it set up to run using the following...

Using Crystal 10. I've searched but couldn't find an answer to this one. I have a report where users will search based on one or more colors. In my table there is no field that shows actual colors - just a numeric value that equals a particular color: 1=Red 2=Blue 3=White 4=Black I've got...

Using Crystal 10. I've got a report with 4 sub reports. My Record Selection for one is as follows: ({HIS_MOD_TRB_Trouble.Submitter Primary Group}={?Pm-@Work Group} and {HIS_MOD_TRB_Trouble.Create Date}=lastfullmonth) or ({HIS_MOD_TRB_Trouble.Assigned to Group}={?Pm-@Work Group} and...

I've got a report where I pull tickets for any given month and then report various metrics based on those tickets. I'd like to filter out tickets from the high end and low end of MTTR (Mean Time To Repair), to get a potentially more accurate average. @MTTR is a formula based on 'Create Date'...

Using Crystal 9. I've seen other questions posted on this issue ( thread767-1099726 ), but no good long term resolutions. I've got a report that is grouped by Division. Within each group (by division) I have a pie chart that shows time separated into 6 pieces. The 6 pieces are the following...

Crystal v9.2 I have data (like below) where I'm trying to get a count for each technician on issues submitted, resolved, closed. Problem I'm having is that any one tech could qualify for one or all three variables. And the values change as the report is run (maybe a tech is no longer with the...

I'm looking for a way to find work log entries made by unique users and then count the number of entires made. Work log entires are saved as seen below with a time stamp followed by a users login name. The next line then shows the state they are from. The next line(s) would contain that users...

I've got cells that containt "work log" information that can vary in length and content. I need a formula to look at a range of cells (or each specific cell) and count the number of occurances of a word. For example, I want to count the number of occurances for "blue": A1=(red blue red red)...

I'm pulling a field into crystal that's a free form diary(work log) for users. Need to count the # of times a word appears in that field. When I run the report I could receive back any number of records, and within each record "the word" appears at least once but could be more. For example...

I have a collection of data on trouble ticket information. Trying to calculate Mean Time To Repair. I’m displaying the total average and then “attempting” to display the 3 tickets with the highest MTTR and the ticket #s that are associated with those MTTR values (which is where my problems is...

Here is what I have: Create Date Value 2 Tkt # Elapsed Time 5/30/06 8:00 AM 5/30/06 9:30 AM 123 1.5 5/29/06 1:00 PM 5/29/06 5:00 PM 214 4 5/29/06 2:00 AM 5/29/06 3:00 AM 215 1 The formula for the column on the right(Elasped...

I have 2 Cross Tabs in one report and I need to delete some data from each. They each show # of cases per week per state. Both are pulled from data with parameter of ?State = Utah (which can be changed depending on report. Basically, I do NOT want to see data that = ?State (in this case...