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 wOOdy-Soft 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: *

  • Users: csm2
  • Content: Threads
  • Order by date
  1. csm2

    Cannot get rid of an old report

    Some time ago I put a quick & dirty report out on a web server for the user. Since then I have fully developed the report on my local machine. When I transfered the new version to the web server and ran it, the old version ran even though I deleted itoff the server. How can I make sure that...
  2. csm2

    My user is a Health Dept with 4 Dis

    My user is a Health Dept with 4 District Offices. They want to know the Average Number of daily visits each nurse in each DO makes during a month. They also want to know the % Difference from DO average of each nurse's average, as well as % Difference from Departmental average (all DO's...
  3. csm2

    Should I use SQL Designer

    I am creating a report of open patient enrollments w/o activity for the past nine months. I have the following SQL: SELECT fields FROM tables WHERE DischargeDate is null and StartOfCaredate < @CutoffDate and a.patno=b.patno and LastActivityDate < @CutoffDate and LastActivityDate in (SELECT...
  4. csm2

    Passing data from subreport to main report

    I am trying to pass subreport formula results to main report formulas using shared variables. The data from subreport is not being added to main report formula. Main report formula: Shared numberVar AllTotJanInd; {@AllJanField}+{@AllJanTravel}+AllTotJanInd The formulas in the subreport are...
  5. csm2

    Multiple Subreports

    Using CR7, Informix DB, Win95 I have a subreport(SubA) which gives statistics for 4 different locations(departments). I group on Dept. I need a subreport(SubB) that summerizes that same data. Since formulas and running totals will be the same for both subreports, I saved SubA as SubB, readit...
  6. csm2

    Two level sort

    User can request a 'ID# within Date' sort order or 'Date within ID#' sort order. How do I setup the formula(s) to achieve this? Am using CR 6 with Informix DB.

Part and Inventory Search

Back
Top