Search results for query: *

The 005.8 could be in any of the code fields (meaing 1, 2, 3, or 4). The following examples could occur Code1 - 098.3 Code2 - 005.8 Code3 - null Code4 - null Code1 - 005.8 Code2 - null Code3 - null Code4 - null Code1 - 245.7 Code2 - 657.6 Code3 - 005.8 Code4 - null As you can see code3...

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 my running total to count records when three scenarios hold true and then I am resetting on change of group. So I guess the answer to your question is no I am not just counting records. The three scenarios are things like when balance > 0 and FC_code = '250' and claim_date <...

I assume you mean create another running total and basically do NOT reset on change of group. If that is what you are referring to, that is exactly what I am trying to avoid. I have way to many running totals that I do not want to recreate. If this is not what you are referring to, can you...

Well, technically I am using Running Totals because I need to count the episodes when three scenarios hold true. Plus I am having them reset after each group. Any thoughts? -crachic

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 think this is what you are looking for. SELECT view_episode_summary_admit.EPISODE_NUMBER, view_episode_summary_admit.program_X_type_code, view_episode_summary_admit.preadmit_admission_date, billing_episode_totals.episode_balance FROM SYSTEM.view_episode_summary_admit...

Here you go. SELECT view_episode_summary_admit.EPISODE_NUMBER, view_episode_summary_admit.program_X_type_code, view_episode_summary_admit.preadmit_admission_date, billing_episode_totals.episode_balance FROM SYSTEM.view_episode_summary_admit view_episode_summary_admit LEFT OUTER JOIN...

I did the left outer join but I do need to select a field from the episode table. I do not understand where I need to input the criterion that you gave me at. Can you pleae calrify. I apprecaite it. -crachic

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

Great idea...Worked Great...Thanks