Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formula for census day

Status
Not open for further replies.

p658484

Technical User
Feb 12, 2009
20
CA
Hello,
Is there a formula or a field to run a crystal report by census days.
For example if an admission is from April 1 to April 5. This case should appear in the census reports for April 1, 2, 3, 4 & 5.
The census day should be the runtime parameter.

Thank you.
 
It is unclear what the problem is that you are facing. Why not just set the admission date equal to the desired date range (via parameter) in the selection formula?

-LB
 
Hello,
The census data is needed to asses the work load for a physician. For example we need to know the list of patients Physician A has for the day regardless when the admission was. So, for April 1st the list should include all cases on site for that day. These cases could have had any admission date before or on April 1st.

Thanks
 
So how do you know if a case has been on site on a particular day? You are not providing sufficient info.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top