SBSMedicalTech
Programmer
I am working on a report that takes 10 months of aging data for a medical practice. In the crystal report I have tied to this report, I am grouping by the Company then by the doctor. In my group 2 header for the Doctor, I need to return ONLY the most recent month's aging information. In my data set, I am seeing the current month and the prior 9 months of data. In my SQL, I have a column titled "Month" that counts from 1 to 10 (1 being the current date and 10 being the oldest month).
What I need assistance on is with my Group 2 Headers - (Group 1 Company, Group 2 Provider). In the header, I am adding in the aging buckets 0-30,31-60,61-90 ... etc. I tried to set these up as running totals by summing on the field and then on the "Evaluate" I tried to tell it "Use a Formula" and then used {Data.Month} = 1. I thought by telling it to pick only those where month = 1, it would provide me back with those records being the most current and in fact its giving me the oldest ones (where the month = 10) as it lists that value first in the result set via the SQL query. I only care to return back the most current date and not the oldest. Not sure what i can do to only return those - any help is appreciated.
What I need assistance on is with my Group 2 Headers - (Group 1 Company, Group 2 Provider). In the header, I am adding in the aging buckets 0-30,31-60,61-90 ... etc. I tried to set these up as running totals by summing on the field and then on the "Evaluate" I tried to tell it "Use a Formula" and then used {Data.Month} = 1. I thought by telling it to pick only those where month = 1, it would provide me back with those records being the most current and in fact its giving me the oldest ones (where the month = 10) as it lists that value first in the result set via the SQL query. I only care to return back the most current date and not the oldest. Not sure what i can do to only return those - any help is appreciated.