I have a column that pulls a patient's latest office visit date which is based on a formula evaluated at runtime based on a Date Range parameter given. For eg.
?StartDateFrom (for eg. 2012-8-1)
?StartDateTo (for eg. 2012-8-31)
LastOfficeVisit pulls the last office visit date the patient had within the above date range.
The report needs to pull the first 100 patients who had their office visits between this date range sorted in descending order, as given below:
This is the format of the report
Age,LatestBPDate, LatestBP are all formula and all these are placed in the Group Footer Section (group-PatientName)
DOS Patient Sex Age LatestBPDate LatestBP
1. 8/31/2012 Pt_GGG ... ... ... ...
2. 8/31/2012 Pt_AAA ... ... ... ...
3. 8/30/2012 Pt_XXX ... ... ... ...
...
...
99.
100. 8/1/2012 Pt_YYY
Can anyone offer help on how to do this?
Thanks in advance for any help/suggestions.
Betty
?StartDateFrom (for eg. 2012-8-1)
?StartDateTo (for eg. 2012-8-31)
LastOfficeVisit pulls the last office visit date the patient had within the above date range.
The report needs to pull the first 100 patients who had their office visits between this date range sorted in descending order, as given below:
This is the format of the report
Age,LatestBPDate, LatestBP are all formula and all these are placed in the Group Footer Section (group-PatientName)
DOS Patient Sex Age LatestBPDate LatestBP
1. 8/31/2012 Pt_GGG ... ... ... ...
2. 8/31/2012 Pt_AAA ... ... ... ...
3. 8/30/2012 Pt_XXX ... ... ... ...
...
...
99.
100. 8/1/2012 Pt_YYY
Can anyone offer help on how to do this?
Thanks in advance for any help/suggestions.
Betty