Search results for query: *

We are running this report from a 3rd party applications. We have one person who when logged in as herself receives this error. I have verified the database location on this report and removed the select distinct records only. Unfornuately it still doesn't run under her log in. Does anyone...

I have 4 Text fields that I need to combine into one new text field. Can this be done? If so, how do I go about making this happen. Note Goal_Note Intervention_Note Plan_Note Note_All I need the first 4 note fields combined into the last "Note_All" field. I am using SQL Server 2000.

Crystal 8.5 I have created a timesheet that with formulas determines the dates and days for a pay period. Next, I need to pull in the scheduled times that relate to those timesheet dates. Each individuals schedule may change at any time. If I have an individuals who's schedule changes during...

Crystal 8.5 I am creating a timesheet form based on the scheduled hours our foster grandparents work. They can have flexible schedules. It's the flexible schedules I'm having a problem with. My timesheet section is only picking up the last detail line. I need it to pick up and evaluate every...

I want to update the table FD__Agency_Admission with the results from a sql select query saved it as a View called TLV__ES_AgencyDischargeDates. I want to do something like this: Update FD__Agency_Admission Set Discharge_Date = '12/31/2004' Where Discharge_Date is null How do I use the...

I am trying to write a SQL statement that will compare one row to the next, then eliminate the rows not needed. Example: Table: TLV_DischargeDates FamilyKey Program 5723 2 5830 3 8473 5 8473 6 8493 1 8930 3 14710 5...

I am wanting to create a formula/loop? that will check for a true condition on multiple fields and then return a comment for each field who's condition equals true. The if statement doesn't work because it will only return the first true statement it hits. I'm working in Crystal 8.5 Example...

I have used the Nth Most Frequent to display each the top 10 most frequent items in a Report footer. Now I need to display the count next to each Nth Most Frequent listed. How do I go about listing this side by side? Nth Most Frequent Count 1. Drug #1 23 times 2. Drug #2...

I am creating a form where the user will input the beginning and ending date for the week they are wanting printed out. The form needs to print for each day and displaying the date and the day of the week on seperate pages. (ie. date: "11/10/03" and the Day of the week is...