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