Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AvgMoJoe

    Help designing star schema

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

    Sorting Large Arrays

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

    Sorting Large Arrays

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

    Grouping by Count

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

    Grouping by Count

    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?
  6. AvgMoJoe

    Grouping by Count

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

    Event Time Differences

    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?
  8. AvgMoJoe

    Event Time Differences

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

    How do I?

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

    How do I?

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

    Brain fart - simple

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

    Brain fart - simple

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

    Brain fart - simple

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

    Group Help

    Assume "John" and "Tom" are unique ID's. (Obviously I tried to oversimplify my real data ;) ) (Besides not filtering for Table2.Measure_ID = 1600), this would cause John (1200 fox and 1700 wand) and Tom (1300 bear) to also be counted as "*Unspecified*", but they really have been specified as...
  15. AvgMoJoe

    Group Help

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

    Weekly Average of Daily Max

    I have an addendum. How can I chart these result (Weekly Averages of Daily Max)? Of course my only choices using the GUI are any summary fields I added to the Weekly Group.
  17. AvgMoJoe

    Weekly Average of Daily Max

    Beautiful! Thank you kindly sir! I appreciate you taking the time to swiftly answer this! If I were to account for days without data, I'd just add a shared variable for a count to divide by, with a little div by 0 check correct?
  18. AvgMoJoe

    Weekly Average of Daily Max

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

Part and Inventory Search

Back
Top