Recent content by dcjames

Thank you all for your responses on this.

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.

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.

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

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 )

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

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

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.

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

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

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

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.

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

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

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