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 gkittelson 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. RedSparks

    CR XI release 2 - Error 723 error in file. Failed to retrieve data

    Yes, she does. I would not be asking this question without having checked this out first.
  2. RedSparks

    CR XI release 2 - Error 723 error in file. Failed to retrieve data

    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...
  3. RedSparks

    Can large text fields be combined into a new field?

    Select (Note + case when Note is not null then '| 'end + Goal_Note + case when Goal_Note is not null then '| ' end + Intervention_Note + case when Intervention_Note is not null then '| ' end + Plan_Note) as All_Notes From dbo.FD__CASE_MGMT_NOTE a Set CONCAT_NULL_YIELDS_NULL OFF I pulled this...
  4. RedSparks

    Can large text fields be combined into a new field?

    Why do you have the isnull for each field? I don't want to combine null fields. Also, from this information I'm still not able to combine 4 text(memo) fields and combine into the one "Note_All" text field.
  5. RedSparks

    Can large text fields be combined into a new field?

    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.
  6. RedSparks

    Formula to pull start and end times between start and end Dates

    {@Day2}= DateAdd ("d",1,{?StartDate}) {@DayofWk2}= WeekdayName (DayOfWeek ({@Day2}),True) What else do you need to know in order to be able to assist me with this issue?
  7. RedSparks

    Formula to pull start and end times between start and end Dates

    This is not helping to bring back the appropriate records between start and end dates. How do I force it to read my criteria and bring back the correct times between the start and end dates?
  8. RedSparks

    Formula to pull start and end times between start and end Dates

    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...
  9. RedSparks

    Variable work days & hours combined into a Timesheet by Day & Date

    For each day of the week the individual time is provided by denoting the time they will work from and to and then the day of the week is check off that this time will apply too. Example: Time from: 9am Time To: 11am Days checked that this applies to: x Mon Tue Wed x Thu Fri Time from...
  10. RedSparks

    Variable work days & hours combined into a Timesheet by Day & Date

    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...
  11. RedSparks

    Using the Results of a query/view to Update a Table

    This is what I did. Update FD__Agency_Admission Set FD__Agency_Admission.Discharge_Date = '12/31/2004' FROM FD__AGENCY_ADMISSION RIGHT OUTER JOIN (Select FamilyKey From TLV_ES_AgencyDischargeDates)h on FD__Agency_Admission.FamilyKey = h.FamilyKey The FamilyKeys listed in the...
  12. RedSparks

    Using the Results of a query/view to Update a Table

    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...
  13. RedSparks

    Comparing a prior row to the next row and to criteria

    The query runs, but it is still bringing back familykeys that are enrolled in other programs beside program 6. Any other suggestions?
  14. RedSparks

    Comparing a prior row to the next row and to criteria

    I put this in: Select t.FamilyKey, t.ProgramCode from TLV_NullDischargeDate t From(Select FamilyKey from TLV_NullDischargeDate Group by FamilyKey having count(FamilyKey) = 1) a on t.FamilyKey = a.FamilyKey Where t.ProgramCode = 6 And got this: Server: Msg 156, Level 15, State 1, Line 2...
  15. RedSparks

    Comparing a prior row to the next row and to criteria

    I'm receiving this error. Server: Msg 147, Level 16, State 1, Line 1 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference. Any suggestions?
  16. RedSparks

    Comparing a prior row to the next row and to criteria

    I want to have it left out of the returned data. We are closing all clients enrolled in program 6 at the end of the year. The Update function will be used to set their Agency Discharge Date at 12/31/04. However, if they are enrolled in any other program, we don't want to give them this date...
  17. RedSparks

    Comparing a prior row to the next row and to criteria

    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...
  18. RedSparks

    Checking a condition on Multiple fields & Returning Multiple Comments

    This is what I wrote: WhilePrintingRecords; StringVar MyString := ""; (If {FD__ADS_NEGOTIATED_SRVC_AGRMNT.SF_B_FS} = "T" Then MyString := "Self"); (If {FD__ADS_NEGOTIATED_SRVC_AGRMNT.ADS_B_FS} = "T" Then if mystring <> "" then mystring := mystring + ", "; MyString := mystring + "ADS"); (If...
  19. RedSparks

    Checking a condition on Multiple fields & Returning Multiple Comments

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

Part and Inventory Search

Back
Top