Search results for query: *

LB - Here's an example of what I'm getting. Columns: 1 2 3 4 5 6 7 8 Phy #1 8 1 113901 21796 14238 21796 7558 Phy #2 37 0 407708 0 11019 10777 Phy #3 23 19 188519 215466 8196 11340 3144 Columns represent: 1=...

LB -- Thanks for your response. The count and count diff formulas are calculating correctly. However, the average charge diff is not correct in every row. If there are values for both 2004 & 2005, then the charge difference is correct. However, if the weighted average for 2005 is $0, then the...

Yes that's correct. Year and physician are row fields. # of patient visits, charges, average charge per visit are column fields and are sumarized for each physician. 7wheel

I'm using CR 10 with an XP workstation. I have a cross-tab report grouped by year; e.g. 2004 and 2005; then it's grouped by physicians. I have summarized fields for # of patient visits, charges, and average charge per visit. I need to show the difference between 2004 & 2005 for # of visits...

This worked! Thanks to "chinjk" and "GParker" for their suggestions [smarty] and exceptionally quick response. This group is amazing!

K - I didn't get the results I expected. To clarify...the report is grouped by physicians and each physician has 5 patients selected by random with their medical record number. Your suggestion reversed the order of the med rec numbers; for example if original med rec no was 687899, the result...

I'm using Crystal version 10.0 on an XP workstation. I have a report which lists patients' medical record numbers which are 6 digits in length. I need to sort these patients using a medical record function called "sorting by terminal digit" which I understand is to sort by the last 2 digits...

lbass -- Kudos! This worked perfectly! Thanks for your help. We're using Crystal 10.0 as report writer for new decision support system and have much to learn.

I am new to this site so hopefully I'm doing this correctly. I have a report that groups physicians and then displays patient identification numbers under each group. I need to select 5 random patient numbers for each physician group for further research and verification of data. I've...