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...
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?
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...
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.
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...
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...
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'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.