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 Chriss Miller 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: RepRider
  • Content: Threads
  • Order by date
  1. RepRider

    compare name fields and return mismatches only

    I have ONE table where there are 3 independent name fields: name (lastname, first name) lname (last name) fname (first name) I am looking for ALL mismatches whatever they are. Using Crytal Reports XI will the following work (research for a friend)? {TABLE1.NAME} <> {table1.lname} + " , " +...
  2. RepRider

    Suppressing field in page header

    CRXI and SQL database I have similar reports with varying lengths of detail pages but the last 2 pages are filled with summary crosstabs where I do not want a specific field in the page header to display. I have tried suppressing with the following formula: OnLastRecord and...
  3. RepRider

    Crosstab Percent Decimals... Again

    MonoSpaced Text CRXI and SQL I have read various threads on this but my brain can never figure out what to do with my crosstab to make this work. My report is an insurance profile that runs each month and shows the type of insurances, the number of clients with that insurance and the percent...
  4. RepRider

    Calculating Recidivism days

    CRXI with SQL I have a report that is grouped by ConsumerID and EpisodeEndDate that shows the number of times a person was discharge within a Fiscal Year and some detail about types and number of services provided. I have a formula for the LOS (length of stay) for each episode of care for each...
  5. RepRider

    Supress page header field if group footer present

    CRXI and SQL I have a report that is group by supervisors and report specific data for employees under them. I have the employee name visible in the header with their data displaying on their own page. Sometimes there would be an extra page at the end of the group so I put in a formula to...
  6. RepRider

    Parameters and a simple report

    CRXI with SQL database I have no experience with parameters but I am trying to create a simple report and I am lost. Using one table with client information I would like to create a simple report that will display the clients case number and date of birth after the user has specified the...
  7. RepRider

    Selecting records by future schedule date

    CRXI and SQL Server I have a report that I want to select records by the appointment dates in our scheduler tables. I want to automate it to run on a wednesday but choose all the clients who are scheduled for Dr. appts for the next week (M-F). It is run now by a person manually selecting the...
  8. RepRider

    Grouping Order

    SQL and CRXI A current report shows a variety of demographic data by client that is used for verification and updating at our "fornt window." The only problem is a particular grouping of information re: contact information repeats out of order and I dont know how to make it stay together. It's...
  9. RepRider

    Count of client with only one episode

    CRXI and SQL I am using the Hamady Case Flow report that shows for a given time period the number of open cases at the start and at the end of the report time period. It also shows cases opened and closed during the report time period. There are also parameters for the user to define the...
  10. RepRider

    Report Processing Time

    CRXI and SQL My question is about being able to shorten report processing time. I have a report that has 7 groupings and displays a current case load per provider. It is 63 pages long and sorts by "team" and "provider." It has 10 coumns of information pertaining to each person listed on the...
  11. RepRider

    Modifying a stored procedure

    CRXI and SQL 2000 I have the following stored procedure which works fine except for a small detail I need. I did not write this nor have I worked with SPs much. Any help is appreciated! This currently creates 12 months of data that I display in a crosstab. However the column heading only...
  12. RepRider

    Sort report by two columns

    CRXI and SQL I have a report that shows various providers and the services they perform. It is currently sorted ascending by the average # of days to service documentation 0 days to 14 days. there are additional columns of data one which shows the total number of services during the same time...
  13. RepRider

    rows with null fields being excluded from report

    CRXI using SQL database This report shows certain types of appointments for the day with the Provider, appt type, client name, time, anc various associate fields related to authorizations (auth ID number, name of auth cluster, start date, end date, units authorized, units left. Currently all...
  14. RepRider

    Crosstabs zeros

    CRXI with SQL I have a crosstab that displays a productivity percentage for each employee. It has 12 monthly columns. When staff are hired or leave there may be 0.0 for several months as their productivity percentage. Since they were not employed those months 0.0 would not be correct. Is there...
  15. RepRider

    Crosstab Total: How to get an average of the column field data

    Using CRXI - SQL I have created a crosstab that shows 5 colums of data and subtotals by group. The first four columns totals SUM the respective column data. The 5th column is a productivity percentage created by embedding a formula from the report data into the text header of the crosstab...
  16. RepRider

    2 reports - Same Field - Different Field Types?

    CRXI and SQL I have two reports with same table in both. One field start_date is datetime in one report and just date in the second report. I tried changing it to datetime for the second report but it does not give me the option to do this. How is this possible? I need datetime for both reports.
  17. RepRider

    Auto Title with date range

    CRXI - SQL server I currently us the above as a formula that displays in the report header. However, I need it to be the actual date range selected for the report. With my formula it shows the min and max of data within the date range. My current forumla is @DateRange: "For the Period " +...
  18. RepRider

    filter out multiple episodes

    CRXI with SQL Svr I have a report that shows a graph of all initial assessments per month. All consumers have a unique ID but may have several episodes of care. Each episode of care includes an initial assessment. Each episode also has a unique ID. This first report is just fine for its purpose...
  19. RepRider

    Auto Underline all dates 2 months from report run month

    I received help with this previously but that thread is now closed. I needed to underline all annual assessment dates in a report that were in due during the next month. The report is run at the first of the month (such as November) but the annual assessment dates that occur during December...
  20. RepRider

    count occurance of text from a formula

    Crystal XI with SQL database I have the formula below in a report to act as a prompt to a provider to close a consumer based on various lapse times from a last service. I now want to count how many records have been flagged as a total count and also to show what percentage of all of the...

Part and Inventory Search

Back
Top