Recent content by AvgMoJoe

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

I ended up using a custom crystal function for sorting (found here) which does not seem to have the same limitation. Now I only need to worry about an array exceeding 1000 which is less of a concern. Function ShellSort(Values() As Number) 'exit if array has no elements If Ubound(Values)=0...

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

Adding to Command ended up making a report that ran forever. I ended up messing with the original way, and noticed I hadn't put the Number of Visits in the actual grouper (there is a grouper, a display of the grouper, and a chart display of the grouper. Now it works. I hate it when a stupid...

If I apply a time range to the resulting scheme, will EncounterCount show total encounters within PAT_ENC_HSP table, or only count those within the time period?

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

Thank you :)

Excellent, Thank you! If there are multiple events of the same type and they do not necessarily load chronologically, I assume you would toss in a Min() somehow?

(Crystal 2008)

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

I don't believe you understood the nuances involved. Specialties could belong to one or more service lines, and the grouping will be dependent on how specialties compare among themselves for one physician.

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

A command was exactly what I was thinking I would need to do, but haven't done so yet! Thank you!

Actually that would not work, because I will be using table1 for grouping information from other tables linked to it.

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.