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...

Nevermind, finally figured it out. Went to Options - Suppress Printing if No Records Selected.

LB - This thread is helping me with a question i had, using your below recomendation: You could place the first two fields in a detail_a section and format each field to "suppress if duplicated" (format field->common tab). Then go into the section expert and format detail_a to "suppress blank...

This is what I needed - as always THANK YOU!

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...

That was too easy - thanks for opening my eyes !!

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...

Thank you for the replies guys. LB - I'm not familiar with "union statements" and i'm searching on them now. But can you show me an example of how that would look? Tx again.

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...

@MTTR = ({MOD_TRB_Trouble.Ticket Resolved Time}-{MOD_TRB_Trouble.Event Start Time})*24 Basically gives me a MTTR in hours. So I then have a set of data that could be X number of tickets. When I average the whole, I do not want to count the top and bottom 5% MTTRs. Thanks and let me knwo if...

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...

Thanks - let me try to clarify. When the report is run you select a date parameter and a work group parameter. My record selections is as follows: ({Closed Time} >={?Start Date} and {Closed Time} <= {?End Date}) and ((({Work Log}like'*'+({?Work Group }&" - Group")+'*')or {Submitter Primary...

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...

What if my data contains values that are of the same length? In the below example, "blue" and "gold" are both 4 characters - but I only want to count the number of times "blue" appears. A1=(red blue red red gold) A2=(blue yellow red blue) A3=(yellow green red) A4=(blue blue gold blue red)...

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)...

Had to tweak it a bit but this helped a ton. As always thanks for the quick reply.