Search results for query: *

Hi, I am using Crystal 11. I am trying to create a running total for a group of records and I am not successful. I can create the running total in the detail section but when I try it for the group, it does not work. Can someone please help me with the correct formula to create a running...

Hi, I have a report that is providing me data as follows: name date count jake 200611 5 jake 200611 3 jake 200611 1 how can I get the report to combine those to provide me with one total for the count? eg: jake 200611 8 Thanks for your help.

I have a set of data eng mat fren sci totalScore avescore 1 0 3.2 2.7 1.9 2 1.2 3.6 2.8 0 the total score is all the grades added for the subjects. however, the average score takes the grades for those subjects that had a grade and finds the average. We...

I newly installed the new crystal reports XI and it was working fine as of yesterday. Now when I needed to open the application I got an error messages which stated that crystal could not load the keydecoded.dll. Has anyone had this error before? Any advice on how I can fix this would be...

I recently bought crystal reports XI professional and I am having problems opening the formula window to create a new formula. I also have issues opening or editing an already existing formula from other reports. Has anyone else ever had this problem. I have tried the uninstall and reinstall...

I am getting the following error and looked at everything and can't figure out what the problem is and why i cannot get any data to be audited. "Auditing information is not being written to the auditing database. Please verify that the auditing data source is properly configured on the CMS. "...

I am using Crystal 10. I would like to control the columns to stop after line 34 and to have it display results in the next column and after line 34 go to the next column. So I have split the report into three columns. I wrote a formula called max and entered 34 in it and then I inserted a...

I have a report using crystal 10 where I am trying to print out schools who have not turned in student grades. I am only getting the schools that have turned in something. I really want the opposite. Can anyone help me? I am using three tables to get the data example: grades: eng math for...

The following is the record selection formula: {students.application_status} in ["Active", "Approved", "Withdrawn"] and {students.year} = 2005 and {students.semester} = "School Year" and ( {?CheckNo} in [{bssp_tuition.apr_check}, {bssp_tuition.aug_check}...

The following is the record selection formula: {students.application_status} in ["Active", "Approved", "Withdrawn"] and {students.year} = 2005 and {students.semester} = "School Year" and ({bssp_tuition.apr_check}= {?CheckNo.}; {bssp_tuition.aug_check} = {?CheckNo.}; {bssp_tuition.dec_check} =...

I am not sure if this is the best way to go about it however, I need to create a report that will look up a check number from 10 different fields and print the field(s) that matches and the amount of the check (this is a seperate field). Eg. there are 10 fields for each month of the year...

I have a payroll report that runs automatically however, one of the fields on the report needs to change when the report is ready to execute again for each person. How can I get that field to change to the next value for the next period automatically? Is there a formula I need to create in the...

I have a timesheet report that runs automatically based on a calendar. One of the fields need to be updated to change the period date (this is static information) for the next time it executes. How can I get that to change automatically? Is there a formula I need to use in the report to...

What is the most efficient way to convert a test field to be used in a calculation. I used: tonumber ({Field1}) and I keep getting an error in the evaulation formula that says it is non-numeric.

I have a text formula field that I would like to summarize on certain values. Eg. the GE a calculated field which prints either "Below" or "above". I want to create a summary that would count how many time "Below" shows up and how many times, "Above" Shows up. In the GE formula, I had a...

I am trying to use the count function to count the number of times a report prints "below average" or "above average" I would like it to be like a summary of a field and show up in the grand footer section of my report. What is the best way for me to handle this.

I have created a cross table to list contacts, contact roles, email address, phone numbers. However, a contact that has two or more roles, their email address is printed three times for each rold. How can I get it to only print one email address for the contact? Thanks for your help.

Can anyone help me with printing a null set of records. for example. I would like to print the records for students who did not have any grades entered at all. I managed to create the report with left outer joins which gave me everyone but I only need to see those who did not have any scores...

Hi, I am trying to split up an address formula to print on seperate lines. Is there a specific syntax that I can use to accomplish this? {streetaddress} &" "& }CityStateZip} but this will gave me one line. I want them to appear on two seperate lines.

If you have three tables: I want all the data from table a and b and matching data from table c only that table c contains nulls or blanks. How can I join these tables to work.