Search results for query: *

I have a 2 part question. 1. Is there a way to lock formula's in a field so the delete key will not delete the formula? 2. Is there a way to write a formula so if 2 fields equal each other the value of 3 other fields will be 0? I have a small parts quantity spread sheet. I have the following...

When using a picture, such as: picture({INSTransInmates.Bkg#},"XXXX-XXX") Is there a way to sort the report from the last three digits of the picture? The digits are a number such as 1234567. I understand how to use a picture to separate the 7 digits in different ways, but is it...

I have a field with 7 digits in it, 1234567. Is there a way, in CR9, to separate the digits and display them in different formats? Example, 123-4567 or 1234-567. Thanks for any help. rlporter

In CR9 under the dropdown menu Database > Set Datasource Location I get an error and CR9 closes. Has anyone else had this problem and found a solution? Also in CR9, is there a way for a report to read an ini file for its header. I have a report that is used by several departments. Each wants...

I have two tables: Employee Employee_stc The Employee table holds the names of the employees and the Employee_stc the training records. There are several hundred training classes. Not all employees have had all the classes. I need to run a report based on the following criteria: ClassName...

I have an employee table and a training records table. Not everyone has been to training, so they have no records in the training table. I would like to print a list of anyone in the employee table that is missing from the training table. Can this be done in CR 9? Thanks for any help. rlporter

I am trying to create a report with 2 parameters. 1. Date 2. Class I have tried this using the select expert with no luck. {Employee_stc.STCDate} = {?Date} and {Employee_stc.Class} LIKE {?Class_Name} I actually need the report to show all students that have taken a class prior to the entered...

Can a report designed in CR 9 be run in Borland Paradox. I have the developers edition so I have the runtime files. Thanks for your help.. rlporter

I am using Crystal Reports 9 I am creating a report that will show employee output for their shift. We have identified each job by a 3 digit code. What I am having trouble showing is the employee average against the groups average. I need to add the total output for each code for the group and...

I have a table with the following fields: Code - 3 digit code describing a certain job HowMany - number of widgets completed for above code HowLong - time it took to complete, in minutes I wish the result to look like this: Code...HowMany....HowLong 100....10.........20 120....3..........60...