Search results for query: *

I am using Crystal XI. I want to group by code. The problem is that this code can be in four seperate fields. The four seperate fields are labeled code_1, code_2, code_3, code_4. An example of the code would be like 005.8. This code that I want to group by is put into code_1, code_2, code_3, or...

I am currently using version XI and I need to be able to modify these reports in version 8.5. Is there a way to take a crystal report in version XI and convert it to a version 8.5 format either in crystal itself or an outside application. -crachic

I have a general question in regards to Crystal Reports XI. I would like to do a "Find and Replace" feature where I want to find all instances of one field (i.e. tablename.create_date) and replace it with another field (i.e. tablename.entry_date). More specifically I want to replace the one...

I am using Crystal 8.5. I currently have two groups setup. Group 1 - Bill Date Group 2 - Insurance Code I have totals for each group 2 and each group 1. Example: 7/21/08 (Group Header 1) AET 24 (Group Footer 2) CIG 12 (Group Footer 2) Total 36 (Group Footer 1) 7/22/08 (Group Header 1)...

I am using Crystal XI. I have a subreport that is calculating a number. The sample data I am using is calculating the number 10 which is the correct number. I have that number displaying in my main report. What I am looking to do is to take that number and use it in a calculation in my main...

I am using Crystal XI. I am trying to calculate the number of episodes that the admission date falls within a month to date (MTD) and a year to date (YTD) range. The difference here is that I want it to calculate the MTD and YTD totals based on a date entered by the end user and not the...

I am using Crystal XI Here is what I am trying to accomplish in words. For all Inpatient episodes, find all charges for a patient that are within 3 days of the admit date of the inpatient episode. At this point I am not worried about the layout but I have a small sampling of data that I am...

I am using Crystal XI. I have a main report that is grouped by a setting code. This main report totals values for each group by means of a running total. I have a subreport that I want to copy the running totals from the main report to the subreport. It copies fine but when I go to edit the...

I am using crystal XI. I have a field that has three values (I,O,P) and is a static field where nothing will ever change with this field. It is hardcoded. I currently have formulas working that total up the number of episodes for each value (I,O,P) by means of grouping by this field. I also...

I am using Crystal XI. I have 3 parameters and they are buckets, Financial Class, and Summary (Y/N). The buckets and Financial Class have many choices for the user to select from. The Summary is simply a Y/N to the question, if they choose No, then it will show detail. I want the data to...

I am using Crystal XI. I have two tables, Table 1: Admit table that give me which type of admit it is, either pre-admit or admit Table 2: Episode totals that gives me the episode balance for all episodes that have a balance My report is supposed to give the following output. # patients...

I have 5 levels of detail on the horizontal part of my crosstab. They are Years, Quarters, Months, Weeks, and Days. I also have 5 parameters (one for each level of detail) asking the user if they want the detail broken down by each of them. When they choose NO, I want it to NOT show the detail...

I am trying to display a running total that displays information that is outside of the search criteria. For example I only want to list the referrals that fall inside my search criteria but there is one field that I want to use the entire database for and not limit the calculations to just the...

I need to write a formula and I am not sure where to start. I need the formula to accomplish the following: if the admit date of an episode is less than or equal to 7 days after the discharge date of the previous "same type" episode put an X. The discharge date is inclusive, meaning that the...

I am trying to populate data in a subreport based on the output in the main report. Below is a generic example of what I am trying to accomplish. A subreport may not even be the way to do this but that was my initial thought. Main report Group 1 - Location Group 2 - Room Group 3 - Bed I have...

I have a scenario where I want to do an evaluation that is basically the following. This is not actual code. If (?Date) in (Beginning Date) to (End Date) Do evaluation else if (?Date) ...... The ..... represents the part where there may be no end date. The end date has not occured yet. I want...

I am getting output for a label I created. The output I am getting is in the upper left hand corner and I want that same exact information to print on all 30 labels. (Avery Standard 5160 - 8.5" x 11" sheet) I am using Crystal Reports 11. Any ideas. -crachic

I am trying to evaluate using a running total. Below is my formula that I have in my evaluate portion of the running total. if {view_episode_summary_admit.preadmit_admission_date} >= (?Begin Yearly Admit Date} then ({view_episode_summary_admit.program_code} <> '503' or...

I am having trouble getting a field to display when a condition holds true. I have the following fields that I am trying to work with: - sport_name from Table Sports - example values of basketball, baseball, football - sport_order_number also from Table Sports - example values of 1, 2, 3...

Hello, I have a running total formula that I am using to sum a field. I have it evaluating only if a certain criteria exists. I also have it resetting at the change of group 1. When the criteria does not exist I want it to display a zero '0'. Currently when the criteria does not exist it...