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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: lorri
  • Order by date
  1. lorri

    SQL Command in Crystal XI

    I am pulling all the fields that I want - I guess I can take out some that I don't need I didn't know if there was a better way to write the statement - I want to have both tables linked so I can write multiple reports off of the same statement - like having a dictionary or one tabel - you know?
  2. lorri

    SQL Command in Crystal XI

    Query in full SELECT "gci_requests"."id","gci_requests"."category_name", "gci_requests"."persid", "gci_requests"."ref_num", "gci_requests"."summary", "gci_requests"."description", "gci_requests"."open_date", "gci_requests"."last_modified_date", "gci_requests"."close_date"...
  3. lorri

    SQL Command in Crystal XI

    I want to use crystal for the rest of my grouping, parameters, etc. I am running this over an ODBC connection. Since I need to join the tables by modfiying a field - this is the only way I came up with this statement Thoughts
  4. lorri

    SQL Command in Crystal XI

    I have to use a SQL command in order to write a crystal report and join 2 tables. The reason for this is that I need to link 2 fields but remove a few letters at the beginning or one to get them to link FROM "mdb_rpt"."dbo"."gci_requests" "gci_requests" LEFT OUTER JOIN...
  5. lorri

    2 fields to join as one in formula Crystal XI

    Hi All - So I am having a problem with a report I am trying to create in crystal XI I have 2 fields - Reported by and Assigned To I want to total the Incident numbers with a distinct count for the Analyst that would either be Reported By or Assigned To I also want a distinct Count of the number...
  6. lorri

    Crystal XI formula to shorten text

    when you're good - you're good Thanks a bunch =)
  7. lorri

    Crystal XI formula to shorten text

    now getting an error at the part after else that this array must be subscripted for example array [i ??? can't get it to work....
  8. lorri

    Crystal XI formula to shorten text

    that gives me an error a subscript must be between 1 and the size of the array if I take out the txt 2 it works but shortens it too much....thoughts? Thanks
  9. lorri

    Crystal XI formula to shorten text

    what if I am getting an error that reads string length is less than 0 or not an interger? If I take out the -1 then it works ok but still leaves on too much text.I only want text.text. can I do this?
  10. lorri

    Crystal XI formula to shorten text

    I have a field that is being pulled that I want to summerize. For example I have one field that pulls a drill down of categories ex) Server.NetApp Filer Telecommunications.Account Management I want to write a formula to stop the text at the second period and group totals by that Is there a...
  11. lorri

    SMS 2003

    Hi All - Is there a way to use SMS to find out registry information on a users machine like printer information, network drives.......
  12. lorri

    inno setup - silent install

    Hi All - I have an inno setup .exe that I am running silently by /silent - in the install I am getting an install of a toolbar. Is there a command to either record my install or put a command in to do not install the toolbar? thanks
  13. lorri

    Script to rename a shortcut

    so where do I fit this in? Set objFileSys = CreateObject("Scripting.Filesystemobject") Set objShell = WScript.CreateObject("WScript.Shell") strStartMenu = objShell.SpecialFolders("AllUsersStartMenu") If Not objFileSys.FileExists("c:\Program Files\Microsoft Office\OFFICE11\OIS.EXE") Then...
  14. lorri

    Crystal Reports 8.5 time formual

    I gotcha now..........Thanks SO much!
  15. lorri

    Script to rename a shortcut

    Hi All - what is the syntax to rename a shortcut on your desktop? help is apprecaited Thank -L
  16. lorri

    Crystal Reports 8.5 time formual

    is there a way to get this as a prompt though? I need one for date range and then a hard code for the time range - you know what I mean?
  17. lorri

    Crystal Reports 8.5 time formual

    I am just getting a true/false value when I use that
  18. lorri

    Crystal Reports 8.5 time formual

    Hi - I have a field that is unix time (View_Request.open.date). The field is a number and I have converted to a date/time by the formula dateadd("s",{View_Request.open_date}-14400,#01/01/1970#) what I need to do is run a report by time range, for example all Incidents opened between 5pm and 7am...
  19. lorri

    Adding Network Folders to Outlook 2003

    I don't get that option. I am Outlook 2003 and it is set up as Exchange. But I don't get the options that you are speaking of - I am unable to get any options when I right click on the shortcut bar - I can select add a new group or a new shortcut - but that brings me into Outlook folders , etc...
  20. lorri

    Adding Network Folders to Outlook 2003

    Hi All - Is there a way to add a network folder to Outlook 2003? Also - Can you set up shortcuts to My Documents and stuff too?

Part and Inventory Search

Back
Top