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

...Dim Elements As Number Elements = LastElement - FirstElement + 1 'find the best value for distance Dim distance As Number Do distance = distance * 3 + 1 Loop Until distance > Elements Dim temp as number Dim index As Number, index2 As Number Do distance = distance \ 3 For index = distance...

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?

...= 1 then "1 Visit Only" else if {%Number of Visits} in 2 to 5 then "2 to 5 Visits" else if {%Number of Visits} > 5 then "More than 5 Visits" else "*Unknown Number of Visits" If I put these two on the report, they display as expected. However they do not group as expected; everything is...

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.

...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 goose and chipmunk (respectively).

...by MeasureValues indicated by Measure_ID 1600, but I need to also include those 2's with no MeasureValues indicated by a Measure_ID 1600 as "*Unspecified*". Furthermore, I have to be careful that 2's with 1600's don't also show up on my "*Unspecified*" group where the Measure_ID differs from...

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.

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?

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