Search results for query: *

Hello - using Crystal 2008 for this report. I have a report where I am pulling in 4 copies of the same table in order to display a hierarchy. There are 4 levels of hierarchy being displayed on the report from these alias tables. I need to pull two fields (Name and Tax_ID) of information from...

Hi, We are looking to have a form display certain information from a table, based on the data entered in the previous field. For example: Employee: Joe Employee Organizational Unit: Operations Department: IT We want just the 3 departments under Operations to show in the drop-down while on...

I am using Crystal XI. We have a report we use to determine if a field has punctuation in it. This is an audit report used to catch these errors prior to an extract being taken. We are currently looking for results to be returned in the select expert using the following: like ["*!*", "*#*"...

I am currently using Crystal XI. I need to pull employees who are between the age of 55 and 64.99 between the time period of 7/1/2009-6/30/2011. If they reach this age at any time or go over 64.99 during any time during this time period, I will need them on my report. Thanks!

I am using Crystal XI and need to pull in counts for each month in a 12-month period. The 12-month period can be different each time it is run. The data is entered with an effective and termination date to capture eligibility. Here is an example of how someone can be in they eligibility...

I apoligize if this is already a thread, I searched but couldn't find exactly what I need. I am using Crystal XI and would like to create a formula for a date field to convert to mm/dd/yyyy from m/d/yyyy. I am looking to evaluate it against another database to determine if there is a keying...

I am using Crystal 8.5 and XI. I need to display records that certain field data in not in Upper case. Examples are below: 125 Main Street 45 ELM STREET 45 PORTER CIRCLE 98 Salem Street I would like the results return: 125 Main Street 98 Salem Street Thanks! Kim

I am using Crystal 8.5 and XI. I would like to display a field in my report that displays the text after the "-" in the field. Here are some examples: Field Data Formula should display JYMC-M$1 M$1 C100MC-M$1P M$1P...

We have a query to export to text using fixed width. The query is using 3 tables and is 9,134 characters per record. It allows us to run the query, but when we try to export it we get the error "Record is too Large." Any thoughts on how we can get the data out of Access in the fixed width...

I have a table of data that I want to run a query against to insert a running total column based on a field in the table (Member ID). Example of the column data would be: Member ID Benefit Plan Date I want to have a running total on a reoccuring Member ID. Example of...

I am using Crystal 8.5 and need to change the format of a date time field to a specific format. I can do it within the report, but when it is exported to Access it loses its format. Here is the current format 11/1/2006 12:00:00AM I need to format it in a formula to 2006-11-01-12:00:00 In...

I need to add blanks to a field if it is not a certain length. For instance, if my field is last name and I need it to be 30 characters no matter what, I need to write a formula to add the blanks. This is how I do it in Crystal Reports...

I am tryinng to extract data for a conversion project using 8.5. The record layout that I have been given includes many arrays. This is what I am trying to accomplish for the first array: LastName FirstName Sex ReferenceID ReferenceType Jones Ken M 001223333 001...

I am using Crystal 8.5 and need to fill a field (LastName) with blank spaces if the length is less than 30. Example: If my last name is Jones, I need the formula to add 25 blank spaces after it for when I export my report. If my last name is Simmons I need the formula to add 23 blank spaces...

I am using Excel 2003 and have a vlookup formula - =VLOOKUP(A3,'3rdQuarter'!$B$2:$D$60,3,FALSE) When no results are found it returns #N/A on the sheet. The user does not want to see this. I found where you can change how it prints to blank or -, but need to change how it is displayed...

Crystal 8.5 I have a group on Account and want to show Coverages on one line in the report. Account Coverages City of Portsmouth Health, Dental, Life City of Concord Dental, Life, LTD, FSA The coverages appear individually on a separate...

Crystal v8.5 I am trying to pull all subscribers in our enrollment database who do not have a particular coverage type (i.e. Life Insurance). The problem I am having is that each subscriber can have more than one line of data in the system (i.e. they have Medical, Dental, etc.). When I try to...

I have included a shared variable in my subreport and have also included it in my main report. Everything is great and I am able to perform a calculation with the shared variable by group. However, I want to grand total in the report footer for each column - of which one is my subreport, a...