Search results for query: *

I am using Crystal Reports 2016 I have been tasked with developing a report that is based off a user performing several search options. They can search by 1 or multiple fields. I developed parameters for each field that can be searched on with the optional prompt set to true. I then added the...

We have column charts that are displaying percentage of value. The problem we are having is that not all of the charts do not total 100%. We are rounding the numbers and our customer only wants to see whole numbers. We are using Crystal Report 2016 and have CRChart. The are hundreds of carts...

I have a report that captures Dairies in a Series of Bad Test Results. When a dairy gets their milk tested and it is bad, it goes into a series and requires special testing. They can get off the list by having 3 consecutive good results. I need to be able to use a suppression or a filter to...

I have been asked to provide a report that will display errors for data entry. If the field {{Command.birth_name_last} includes any characters that are not a-z or A-Z or include numbers then I am to display a message. I have tried several methods, but no luck yet. Using Crystal 2008 connected to...

I have an error report that is used for spotting errors in data entry. One of the errors I am looking for is a space in a string field like first name. Everything works fine except if there is a space at the end of the field. Crystal is not recognizing that space. I have tried InStr and InStrRev...

I have not found the solution to this one yet. I need to test to see if a space is used in any position of a string. The instr works as long as the space is not at the end. I have tried instrrev and that does not work either. The fields I am using are first name, last name, middle name. I am...

We have just recently converted Deski Reports to Webi are using BOXI 3.1. During the import users were imported for the current production while the folders and reports were imported from development. There are less than 100 user all in groups so resetting the security to the folders was simple...

Using Crystal 2008 and SQL database. Employees request time off. Database holds start and end dates for request. I have been asked to create a report that will display by each work day for a month, minus weekends and holidays, if employee is off P (Partial Day) or F (Full day). The report needs...

I have been reading the posts but have not found a solution to my issue. I have a field that for Network Login ID shown as: .JDOE.TW.VIS_PC.HBCD .SSMITH.AGNYMIS.HHSA I need to extract the string following the second period. For example the above two records would be TW.VIS_PC.HBCD...

OK...Here is a complex situation. I have a report with results as follows: Group1 - PatientID Group@ - TicketID A Patient can have multiple tickets. A record stores the payment made with the balance. So again there can be multiple payments made to a balance. When a record is stored, the...

I use Crystal XIR2 and this is an access database. I have clients that receive child care. I need to know the total months child care is received and the total consecutive months child care is received from the last date received by Parent SSN. My report looks like this so far Group 1 -...

I know several people have been asking the question about how to display decimals for percentages in a crosstab. I have reviewed the comments, but I am at a loss. Below is a row in crosstab showing my counts and percentages. As you can see the percentages does not add to 100%. I need to show the...

I have a report that has multiple parameters. Two of the parameters are dynamic. I need to be able to have the report use either one of those parameters or both. For example: Dynamic Parameter 1 (Nurse) Dynamic Parameter 2 (Location) The end user needs to be able to run the report by either...

I am trying to extract a word from a string field. I have a field called "Software" which is a string field and can inclue data such as "Access", "Microsoft Access", "Microsoft access professional", etc., etc. Which I need to do is if the word "access" is in the string then output "access". I...

I have a group of family members. For each family member there are ethnicities. I need to be able to create an array that will include all ethnicities within the family. I cannot sort the records by ethnicity because the head of the household needs to be the first record. My records might look...

I am using CRXI and have a question regarding supression of a group based on a comparison running total in the detail line. The data I have on the report that I am analyzing is a number field ({BI_DTL.PAY_MNTH}) that represents year month and is as follows: BI_DTL.PAY_MNTH 200608 200609 200610...

I have read the posts on supression of groupheaders and counting details, etc. But none of them answer my question. I have a report that has 4 groups. Group 2 is the group that I do not want to print at the bottom of a page if there is no information following. However if there is a Group 4...

I am using CR XI. I have 2 groups. I would like to have summeries based on criteria within the 2nd group. Group I = WorkerID Group II = ApplicationID Details = AppPending AppDenied AppApproved Data would look like this: MM21 12345 Y N N N Y N...

I have a report that shows Clients with Hospital visits. The report is grouped by Admit Date. In the details section I have client IDs. I need to have a field that shows previous Admits which would be an accumulative count of the Client ID. A client could be on the report more than once, but not...

I would like to know how to suppress a group in the main report if there are no records in the subreport for a group. I have tried using a shared variable and pass a value from the subreport to the main report and then do a record selection based on the result of that value, but it does not...