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 dencom 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: dcjames
  • Content: Threads
  • Order by date
  1. 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.
  2. 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.
  3. 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.
  4. 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...
  5. 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.
  6. 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...
  7. dcjames

    LDAP LDIF DATA SOURCE

    What is required to created to an LDIF file? Any info is appreciated. Thanks
  8. 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...
  9. dcjames

    LDIF

    Is it possible to use LDIF as a datasource?
  10. 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 :)
  11. dcjames

    Rows to Columns

    I have a crosstab query based on 3 oracle tables. Based on another thread I have set the following options 1). Set Summarized field to Max for the column 2).Under Customized Style Selected "Suppress Row Grand Totals" and "Suppress Column Grand Totals" ** Group Name is being used in the...
  12. dcjames

    Parameter Query

    In using Crystal 11, I created the following formula: (if{?Business_Segment} = '*' then {USR.USR_UDF_ORGANIZATION} like '*' else {USR.USR_UDF_ORGANIZATION} = {?Business_Segment}) and (if{?Loc_Code} = '*' then {USR.USR_UDF_LOCAT_CODE}like '*' else {USR.USR_UDF_LOCAT_CODE} = {?Loc_Code}) and...
  13. dcjames

    IF Formula

    I know I should probably know the answer to this, but I can't seem to get a formula to work correctly. I have a field with spaces in the values ( e.g. "New User" "Old User" "Medium User") When I try to do the following I get an error If (field name) in ("New User", "Old User) then "User" else...
  14. dcjames

    instr help

    Our database has a memo field called description (example below) "Smith Joe User Object Details Lan Id: Location: example Employee Number: 1111111 Manager: 2222222 Group: Division Code updated successfully in OIM User Info after processing user in OIM Smith Joe User Object Details Lan Id...

Part and Inventory Search

Back
Top