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

This worked PERFECTLY. Thank you veeery much..

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

The field value is a text field, although only 7 digits, is different for each person listed. I tried this: picture(totext{{INSTransInmates.Bkg#},0,""),"XXX-XXXX") but got an error: Too many arguments have been given to this function. It then highlights the...

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

Under Field Explorer, I created the following: Parameter Fields * ClassName * Date Formula Fields * ClassAfterDate if isnull({Employee_stc.Class}) or {Employee_stc.Class} <> {?classname} or date({Employee_stc.STCDate}) < {?date} then 0 else 1 Under Group Selection Formulas I have Sum...

Yes, I need to be able to have a date. Some of the training classes have to be repeated every 2 or 3 years. Thanks for your help, but a minor problem. In this formula, there are several Paraenthesis that don'seem to be closed. I put a *** next to the ones in question. if...

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

As a begginer I am trying different things in an attempt to get it all to work. The right code is why I placed the question here. rlporter

I want the data in the report to be on or before the entered date. I got each of the formula's working, one at a time, but I can't seem to get them working together.

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

I had seen the white paper before, but to me it looks like it is saying that Crystal Reports can use Paradox tables in designing a report. What I am trying to figure out is how to run a report from within a Paradox form. I have the runtime files with the version I bought, but I don't know how...

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

Thanks for your help, but I'm still unclear. For the employee have 2 fields, HowMany and HowLong. My code for that is: {RecordsStats.HowLong} / {RecordsStats.HowMany} For the group I total the 2 fields for the entire group and sort it by code. The results are called: Sum of...

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

This didn't work by itself. I finally hit on it, mostly because the help I received here. I had to do a summary of the group code and then suppress the details. I moved the summaries to the group header and everything shows up on one line. Thanks for all your help..

Yes, Insert / Summary with this result: When I right click on the HowMany and click insert summary, a dialog box opens. There are 3 fields not greyed out. * Choose the field to summarize I select HowMany * Calculate this summary Using the drop down list, I choose Average * Summary location...

The following are the options: Field:RecordsStats1.HowMany *************************** Format Field Highlighting Expert *************************** Browse Field Data Select Expert *************************** Insert Summary Running Total Move Backward To Back Forward To Front Size...