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.
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...
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
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...
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 :)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.