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

    Creating a calendar look schedule report

    Thanks but not really what we want.
  2. kokomol

    Creating a calendar look schedule report

    The time fields are all stored as date and time together. The report pulls information from a precase start time that comes from the appointment book. The intervals can be 30 minutes apart for each room.
  3. kokomol

    Creating a calendar look schedule report

    I have a report set up right now that is driven off of the date and grouped by the room. I was hoping to find out how I can add unfilled time slots to the report when it prints. Right now, the only times that print are the ones that have been booked. The report runs from an appointment book that...
  4. kokomol

    Creating a calendar look schedule report

    We want it to have specific start and end times and display a different page for each room that is booked. For example, one room would have open and close times of 9am-5pm and spaces for new appointments every half hour.
  5. kokomol

    Creating a calendar look schedule report

    I am trying to create an interview schedule that is driven from a database known as ORSOS Onecall. I can't see any tables in the database that contain appointment book hours. I have schedules that show people that are booked for specific times but would like to create a schedule that also shows...
  6. kokomol

    Restricting inventory items based on description

    Thank you! I just tried your formula and it worked.
  7. kokomol

    Restricting inventory items based on description

    How can I use the select expert or a formula to restrict inventory items that contain a specific word in their description? I tried using "not like" but this did not work.
  8. kokomol

    Exporting time fields to Excel

    I tried doing that and it did not work, just made more Xs appear
  9. kokomol

    Exporting time fields to Excel

    I am using Crystal XI and trying to export reports that contain time fields to Excel. All of the time fields show XXXXXXXXXXXXXX in them. I am a user, not a technician and I can't figure out how to make the times show up. I know that Crystal uses TimeDate fields but I don't know how to fix the...
  10. kokomol

    Subreport placement problem

    Thank you! I unchecked the "grow" box and was able to resize.
  11. kokomol

    Subreport placement problem

    I have not worked with subreports very often and am having trouble with placement on my main report. I can move and resize the report on the design page but when I look at the preview, it is not where I want it. I tried resizing on the preview page but I am unable to resize the height on the...
  12. kokomol

    To display a field not on the table

    I think I understand your dilemma. i am working on a report and want to show the Admitting MDs name. The database file that contains this info only has the MD ID in the field. I have linked the staff file to the report in an attempt to display the name and not the ID. Unfortunately, I can't...
  13. kokomol

    "Now" function

    I verified the database and it is up to date. Here is the selection formula: {YTD_OR_STATS.REPORT_TYPE} in [3.00] and {CORP_REPORT_GROUPS.DESCRIPTION} = "SURGERY" and {YTD_OR_STATS.PERIOD} = 1.00
  14. kokomol

    "Now" function

    I am trying to figure out why my report will not show updated summary data when I change the period from period one. There are several summary formulas on the report that use YTD files. The summaries show the number of patients, the number of procedures, and the number of minutes for the period...
  15. kokomol

    "Now" function

    I am modifying an existing report in Crystal 8.5 with that provides a summary of procedures, patients, and minutes by period, quarter, and YTD. Each period represents one month of data with period one being July. When I run the report for period one, the data is correct. When I change my...
  16. kokomol

    Specific word selection

    You guys are the best!!!!! It works!!!! Thank you, thank you!!!
  17. kokomol

    Specific word selection

    Thank you so much! I am able to isolate words and create the reports I want from the description following your recommendation. I tried making a parameter too but for some reason there is no prompt and the report pops up with no data. I appreciate your help!
  18. kokomol

    Specific word selection

    I want to create reports that restrict specific words from inventory descriptions. For example, there are hundreds of different inventory descriptions and I want to look at those that are "catheters". How can I restrict the report to those descriptions that contain this word?

Part and Inventory Search

Back
Top