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 Mike Lewis 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. dcjames

    Source File Date Modified

    Thank you all for your responses on this.
  2. dcjames

    Source File Date Modified

    I've created a report based off an excel spreadsheet and would like to display the "Date Modified" value for the spreadsheet. Is this possible? Any help and/or comments is appreciated.
  3. dcjames

    Active Directory

    I've reviewed various articles and have tried multiple suggestions but still can't seem to create a connection to AD that will allow me to query on. Any advice that can be offered on how to connect to AD successfully is appreciated.
  4. dcjames

    Parsing Data from string

    Thank you all for the responses! You made this a lot easier on me :)
  5. dcjames

    Parsing Data from string

    FireGeek - This looks great! One last thing ( sorry )...I noticed that the CN= before the first and last name is still appearing...I was hoping to parse out just the full name ( CN=FirstName LastName,OU=Container,DC=Container,DC=Container )
  6. dcjames

    Parsing Data from string

    FireGeek21, thanks for the follow up. The If statement appears to work fine but when I go to run the report I get "String Length is less than 0 or not an integer" I thought by accounting for the null values this problem would of been resolved...not sure where to go with it now
  7. dcjames

    Parsing Data from string

    This looks great...what can I do in the case that there is no data in the field? I'm getting an error when running the report and it appears that's due to some fields missing data
  8. dcjames

    Parsing Data from string

    I have a field that contains the following information: CN=FirstName LastName,OU=Container,DC=Container,DC=Container What I'm needing to do is to parse out just the FirstName and LastName values. Any help is greatly appreciated.
  9. dcjames

    Joins

    Hoping someone may have a solution for a problem that I'm having. I have 2 text files that contain an ID and a Host Name in both files. I'm looking to have returned only those Host Names that appear in 1 file but not the other. Here's an example File A File B...
  10. dcjames

    Exporting to Excel and not being able to Filter

    Good point Skip...I may start doing that also
  11. dcjames

    Exporting to Excel and not being able to Filter

    I routinely export to excel with the 97-2003 (xls) format and am able to open it in 2007.....
  12. dcjames

    Exporting to Excel and not being able to Filter

    I have tried saving the results of a report to an .xls file as well as exporting the results to the application. For some reason once the file is open in Excel ( 2007 ) I cannot filter or sort ( grayed out). Just wondering if anyone had any ideas what might be going on.
  13. dcjames

    Parameter Fields

    I want to create a report where the user can determine the field order of the report. What I've come up with so far is... if {?First Field} = 'USER ID' then{USR.USR_LOGIN} else if{?First Field} = 'FULL NAME' then{USR.USR_DISPLAY_NAME} else if{?First Field} = 'OIM USER STATUS' then...
  14. dcjames

    alternate row or group shading

    In the detail section expert click on the color tab and then the x+2 and enter the following If remainder(recordnumber,2) = 0 then crsilver else crNoColor
  15. dcjames

    alternate row or group shading

    This may work for you.... If remainder(recordnumber,2) = 0 then crsilver else crNoColor
  16. dcjames

    LDAP LDIF DATA SOURCE

    What is required to created to an LDIF file? Any info is appreciated. Thanks
  17. dcjames

    Parsing Field

    Pete, Thank you very much! This was exactly what I needed. David
  18. dcjames

    Parsing Field

    I have a field with the following data 0 10 12 ? * 2,3,4,5,6 * What I'm looking to do is get only the info between the *. Ultimately I would like to do some sort of if statement e.g. If {field name} in ['1','2','3'] then "Weekly" else "" Thought that would work but unfortunately it...
  19. dcjames

    LDIF

    Is it possible to use LDIF as a datasource?
  20. dcjames

    Insert Value

    A vendor is asking that a predefined field and value be added to a file. The field and value are not in the database being used. I know you can manually add a text field as a place holder but is there a way to insert a value ( e.g. the word Today ) in that field? Hope this makes sense :)

Part and Inventory Search

Back
Top