I had tried originally to limit the use of rts but was not successful. Within this report I have 26 formulas, 14 rt's, 5 groupings, and three sub reports. I tried rewriting the rts as summary formulas with no success. I going to try to write a sub report that looks at only one staff member...
My Productivity Percent formula is
if {@Total Hours}= 0 then 0 else
{@Total Calculation}/({@Total Hours}*.625)*100
Total Calculation formula is
{@HOURS}+ {#RTotal1}
Hours formula is
IF IsNull ({#RTotal0}) THEN 0 ELSE {#RTotal0}/60
Total Hours Formula is
{@Base Hours} - {@Leave}
Base Hours is...
I want to be clear that the formulas that the system will not accept are any formula that has an equation included. The equations generally include one or more running totals. I have tried to force the system to read them at different intervals (ie..whilereadingrecords, whileprintingrecords)...
I am trying to create a line graph that follows the productivity of a group of practitioners, every two weeks, over a specified timeline. My report has grouping by program, year, and two week periods. I have a formula that looks at the productivity percent within that 2 week period. I would...
Because the client is still within a program it cannot be considered as the last program of the chain. If I was to list that program as the last program and three weeks later the client was admitted to another program and was discharged from WIN NR, the report would be displaying inaccurate...
ok, here is an example:
episode program admit date discharge date PATID
1 CCS South 4/23/2007 11/16/2007 9050112
2 DWTC N/C 8/14/2007 2/6/2008 9050112
3 WIN SR 2/7/2008 6/12/2008 9050112
1 ATC North 5/18/2007...
Forgot to include one important Item. The results need to to be listed on one line for each episode chain. Since I am creating this as a data dump for all clients within a fiscal year.
I'm looking at admissions, discharges, and programs of individuals within a hospital setting. An easy sort to look at individual occurences. I am grouping by client ID. Each line of information has admit date, discharge date, program, entry date, Episode number, and client ID. I am trying to...
I'm writing a report that I need to include a manual line break every time a "&" sign is included. My problem is that when there are multiple answers to a question, the application links them with a & symbol. (ie...Alcohol&Caffeine&Cocaine&PCP&) (I work for a drug rehab) What I would like is...
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.