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!

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

Search results for query: *

  1. miketbuck

    Line graph

    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...
  2. miketbuck

    Line graph

    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...
  3. miketbuck

    Line graph

    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)...
  4. miketbuck

    Line graph

    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...
  5. miketbuck

    Comparing lines of detail

    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...
  6. miketbuck

    Comparing lines of detail

    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...
  7. miketbuck

    Comparing lines of detail

    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.
  8. miketbuck

    Comparing lines of detail

    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...
  9. miketbuck

    Manual Line Break

    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...

Part and Inventory Search

Back
Top