Search results for query: *

I'm sorry I may have confused you with the wording. {table.timepoint} is not a time but is a name of a stop in my system (i.e. E. 30th & St. Clair Ave) The report is to display the time that each bus hits the stop (timepoint) for each block & its adherence. The top row is the stop...

{table.timepoint} is a string

I have a report that I need to look like this Timepoint1 Timpoint2 Timepoint3 Triptime & Block 1 Arrival time Arrival time Arrival time Triptime & Block 2 Arrival time Arrival time Arrival time Triptime & Block 3 Arrival...

There is no possible way for me to alter the data model.

Version 8.5 Database Oracle I am working on a report that calculates the number of misses that an employee has. This report is a letter that is kicked out of the system if they have a miss entered on the current day. They cannot have 8 or more misses. One miss can come off of their record...

Thanks lbass. It worked!

CR 8.5 Oracle I am working on a report that counts the number of absences each operator has. The number of absences is dependent upon the number of working days between absences. If an operator has less than 30 working days between absences then the absence is count if more than 30 then the...

Crystal V10 SQL database I have a bar chart that graphs each clinician's caseload in a particular program. Each program has its own maximum caseload allowance. I created a custom line to represent this number, but I want this line to automatically adjust itself based on the program the that...

I am using Crystal v10 on an SQL database I want to be able to create a report based on Clinician billable hours and to create a bar graph chart comparing the clinician's hours. I had to use variables in order to total the correct hours per clinician. I went to the Crystal website and...

Thanks! It worked! Connie D

I am running Crystal 8.5 on an SQL server. I am creating a report that lists clients that are assigned to a specific provider. I want the report grouped by provider with the following setup: GrpHdr Provider A 10 Clients Client Last date # Days...

Is there an easier way to create dates without creating a table? My skills are not as advanced as that.

I am using Crystal 8.5 on an SQL dbase and am having problems with charting data. I am trying to create a stacked bar chart of the total number clients in a treatment program. Using the following tables and fields Client ClientID AdmitReason Fullname Report should look as such Group...

I am trying to create a report which would produce a chart for services recorded in 15 minute increments. These are the fields that I am using: Recorded_Service.Starttime Recorded_Service.EndTime Service_Item.ServiceItemDescription @hours (formula for the difference between the Start and End...

I am creating a report that counts the number of clients that were admitted to a program during certain date parameters. I want all records to return even null values but I can't seem to get any null values to print. I created a distinct count of the client's ID grouped within the AdmitReason...