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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LAD

  1. LAD

    Help with Date Ranges and Arrays.

    Actually the dates are not outside the range. I need to get this information for each day for every day of the month. I don't want to have to run a separate report for each separate day. Thanks,
  2. LAD

    Help with Date Ranges and Arrays.

    The following the record selection statementin my report. {HPD:HelpDesk.Assigned To Group+} like &quot;*DC*&quot; and ({HPD:HelpDesk.Create Time}<{?Date} and {HPD:HelpDesk.Status} <> &quot;Closed&quot;) or {HPD:HelpDesk.Assigned To Group+} like &quot;*DC*&quot; and ({HPD:HelpDesk.Create...
  3. LAD

    Append a List of Detail Strings into one Line where the first several

    I need to append a List of Detail Strings into one Line where the first several of the detail Strings are 254 characters long. The field I am working with is a comments field. In the database once the comments text field reaches 254 characters a new comments record is created. I need to...
  4. LAD

    SQL Server 16 char Text field truncating.

    I misrepresented the data type. In MS SQL the data type is refered to as text with a length of 16. The defintions of the data type is as follows TEXT Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server...
  5. LAD

    SQL Server 16 char Text field truncating.

    Is there any way to display more than 254 characters for a memo field in Crystal Reports? I am working with a Microsoft SQL server and the datatype for the field is 16 char Text field. I a have changed the format so that the field can grow in Crystal but the information is still being...

Part and Inventory Search

Back
Top