Search results for query: *

Relational DB report writer swinging into dimensional modeling, so please be patient. Essentially I am creating a Fact Table which holds the Numerator and Denominator for various healthcare Measures per Physician. Each Measure has a Goal and a Score. This will serve to populate a Scorecard...

Crystal Reports 2013 SP 2 P 1 I need to figure out how to sort a large array. I am getting an error "A Loop was evaluated more than the maximum number of times allowed." This happens whether I use a bidirectional bubble sort (which I can understand since the iterations become large)...

I am trying to accomplish the following: Group report by Patients with '1 Emergency Visit Only','2 to 5 Emergency Visits', or 'More than 5 Emergency Visits'. I thought I could use the following SQL Expression to count: COUNT("PAT_ENC_HSP"."ED_EPISODE_ID") OVER (PARTITION BY...

Given the following results: Patient #1 Event_Type Event_DTTM ------------------- ----------------- Arrived 10/16/2012 8:00AM Roomed 10/16/2012 8:15AM Physician Assigned 10/16/2012 8:20AM Physician Assigned 10/16/2012 8:25AM Disposition Assigned...

Crystal 2008 MS SQL DB Given the following table structure: Provider.Provider_Name (Group 1) Prov_Spec.Line Specialty.Name --------------------------------- Dr A 1 Internal Medicine 2 Hospitalist Dr B 1 Hospitalist 2 Internal Medicine Dr C 1 Internal Medicine Dr D 1...

Say I have only one table: Table1 ID Name 1 John 2 Tom 3 Fred 4 Sam 5 Max 6 Wilbur I want to display a report with 2 groups: "Red" and "Green" I know that Red should have 1,2,3 and Green should have 1,4,5 How do I show John on both Red and Green? I don't care about Wilbur.

Crystal 2008 MS SQL DB Given the following data set as it comes from my query: I am using formulas for grouping since I am reporting differently for different Xtypes. For Xtypes 2, I'm grouping by MeasureValues indicated by Measure_ID 1600, but I need to also include those 2's with no...

Using Crystal 2008 I have a field {Level} which contains a measurement between 0 and 100 and can be recorded multiple times during a day. Group 1 is by week (using a formula {@WeekBeginning} which accounts for starting on Saturday rather than Sunday). Group 2 is by day (using the 'for each day'...

I keep running into this problem and finally want to get it sorted out. I am creating a chart which shows average exam volume/counts per hour. For example, I will chart out Weekday hourly averages spanning over a month's time. For Tuesday there will be data/bars for only those hours which had...

Scenario: I want to compare subreports for consistancy across multiple organizations. Each Org has multiple ExamCodes. ExamCodes are consistant across Orgs (each have uniqueID though). Each ExamCode has multiple Charges. These should be consistant, but I know some are not. I want to make...