Search results for query: *

Using Crystal Reports 8.5 and Oracle Tables..... One of the tables that becomes populated as tests are completed (ARRESULTS) contains fields that relate the tests to a "CASE" (CASE KEY), the test type, the test and the test result (in character form). If there were five test results entered...

Using Crystal Reports 8.5 with Oracle tables..... I have a series of double cross tab reports that essentially do the same thing for different time periods. They count assignments and cases for four offices and four units (4 X 4). The only different between assignments and cases is that there...

When a user enters a Parameter that results in no records (a blank report), how can I create a formula that prints a helpful and/or informative message?

I was trying to use CR 8.5 to do some reports using data in a couple Excel spreadsheets in use in our shop and could not seem to find a way to use them directly. Got around this by converting the Excel files to Access files, but I was supprised that I could not just use the .XLS files directly...

In one of my Oracle tables there is a memo field that is filled in with key phrases when a certain event is triggered. There is also an event code field that is populated when the event occurs, but the codes are too general. I need to be able to pick specific information for the memo field. I...

When you choose "is between" from the Select Expert drop down, does Crystal Report select include the limits in the selection? For example, if I am using two date parameters such as 10/1/2004 and 10/27/2004, will all the records including 10/1 and 10/27 be included?? Or will I get only 10/2...

In CR 8.5 I usually create a series of reports that do the different things I need to happen and string them together as subreports to give me one report (that is transparent to the user). Question: If I edit and change the subreport from the "master" report, does that change the original...

I have a table field {LABITEM.Lab Item Number} which is string because dashes are used for sub-items. (1 can become 1-1, 1-1-1, etc.). But, of course, if I sort on Lab Item Number I get 1, 10, 11, 2, 22, 2-2, etc. I need a string to value formula that would sort the field as desired: 1, 1-1...

Simple options I'd like to be able to set in Crystal Reports 8.5: The default directory for loading reports and saving new reports. The default Oracle database. The default directory where report output will be stored (This is a major one, since CR 8.5 always defaults to some buried...

Crystal Reports 8.5 and Oracle tables..... I have a field in a table that we are using to flag certain types of cases. Right now there are three different entries in this field (LABEXAM.Report Type). However the vast majority of the records in the database show this field as empty. I can...

I have a basic cross tab report showing a distinct count of pending assignments 30 days old and younger and over 30 days. It list and totals the numbers for four locations and four sections (in each location). I know when I do a grouping report, one of the options in a Summary is to show the...

Using Crystal Reports 8.5 and Oracle tables, I am very weak in the linking of the tables I am using. I have been told to use "Outer Left Joins" on all my links. Most of my results involve the use of what three "master" tables. LabCase, LabExam and LabRept. A record is created in LabExam...

I want to create a report that evaulates data collected from Sunday of the current week. If I call whatever date Sunday is StartWeek, I need to select data between StartWeek and currentdate. I tried the following formula with no success: shared dateVar sdate := currentdate; if...

My administration would like a report that would graph the monthly and/or quarterly (30/90 day) production turn-around-times. The calculation of TAT is simply {LABREPT.Date Completed} minus {LABREPT.Date Assigned}. I need to filter for Unit and Location ({LABREPT.section} and {LABREPT.Lab...

@ReportTitle formula in CR 8.5: "Commulative Cases/Assignments Received for " + MonthName(month(currentdate)) + " " + totext(int((year(currentdate)))) My year keeps printing as "2,004.00" no matter what I try. How can I format to "2004"??

I am using Crystal Reports 8.5..... Need a formula to determine the first day of the month from any given day in that month so that I can run a report that spans the first day of the month to the currendate.....

In one of the main Oracle tables I am working with, each record indicates a completed assignment. However, what constitutes a "case" is a case number assigned to a unit at any given time. In-other-words there might be two assignments to the same unit from a single case. This would be two...

Are there any free utilies out there that would capture and save information about a Crystal Report so that you could easily see what tables were being used, formulas, parameters, etc. Also, is there a simple utility to look at Oracle tables to determine the last time the table was updated. I...

A huge table I am working with contains lab test results. One of the fields contains actual result values for various tests and is a string field, since it is a catch-all for varied types of data. The tests I am interesting in tracking have a number in this string field indicating how many...

I am using the following formula form my Group Header Titles: if {LABREPT.Lab Code} = "C" then "Central Lab" else if {LABREPT.Lab Code} = "N" then "North Lab" else if {LABREPT.Lab Code} = "S" then "South Lab" else if {LABREPT.Lab Code} = "E" then "East Lab" else "No Lab Assignment" The first...