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 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: *

  1. almaragni

    Convert Numbers to text in Select Expert

    I believe if you create a formula field for the zip - as previously stated - and use THAT field as the field on which the group is based - THEN the drill down will show the formatted version of the zip field in the drill down. i'm running CR8 and it appears to work as such totext({zip},0,'')...
  2. almaragni

    Active Directory User Password Change Lockout Continuously

    i downloaded it - but when i tried it, i was unable to determine exactly how to operate it - so when I was looking through the events i really didn't understand the output.
  3. almaragni

    Active Directory User Password Change Lockout Continuously

    thanks however, i have checked all mapped drives and saved logins and scheduled tasks and orphaned logins ... there appear to be none. i am confident this is related somehow to the citrix setup (we have at least 2 citrix servers) but have not yet found the cause. if you know of any other area...
  4. almaragni

    Active Directory User Password Change Lockout Continuously

    Windows Active Directory Password Change Locks Out User Posted: Jul 25, 2007 1:14 PM Rating: Not Rated Reply I have an interesting issue. There are several Windows XP desktop machines along with Windows 2003 Presentation Servers, in one domain. The PS computers have roaming...
  5. almaragni

    connecting odbc sql table and excel sheet in CR8

    well - it appears that now the length (text 255) is the issue at hand. I cannot seem to get the CR to add the database field with a length other than text 255. i'll keep on trying different manipulations of the excel column - and if i get a better result will post it. thanks to all
  6. almaragni

    connecting odbc sql table and excel sheet in CR8

    thanks millet - - that seemed to do the trick (option 3- data-convrt to text) when I linked the excel table it recognied it as text. i'll have to work on the length next (255) - but it was very helpul ... and i learned someting new. thx
  7. almaragni

    connecting odbc sql table and excel sheet in CR8

    LB thank you for your comment. My column heading is "CODE" - is there some range name or other that needs to be applied to make it "stick?
  8. almaragni

    Connecting to data on a different Server in CR 8.5

    YOu should be able to ... ADD DATABASE and then select a new connection and database table.
  9. almaragni

    connecting odbc sql table and excel sheet in CR8

    No, the inventory class is VARCHAR(10). I have been trying to format the excel column to TEXT - but it still appears as a number when I try to link in the CR. Right, I realize excel isnt the best method ... but things being as they are .. this list is maintained in this excel sheet - and it...
  10. almaragni

    connecting odbc sql table and excel sheet in CR8

    Hello, i am trying to figure out how to get an excel spreadsheet attached too a report. Report works off of the inventory class - which connects to the excel scpread sheet column A. However whenever I try to link the inventory table (inventory class code) there in no connections. (the inventory...
  11. almaragni

    Accessing Excel Data as second DBC connection

    Hello, i am trying to figure out how to get an excel spreadsheet attached too a report. Report works off of the inventory class - which connects to the excel scpread sheet column A. However whenever I try to link the inventory table (inventory class code) there in no connections. (the inventory...
  12. almaragni

    CR10 - Suppress total line for single line detail

    It is true - that I created a SUMMARY TOTAL - DISTINCT COUNT - of the detail line items and used that in the TOTAL LINE SUPPRESS OPTION. such as. CUSTOMER part 1 part 2 part 3 CUSTOMER TOTAL LINE (suppress if distinct count of part is < 2) I guess that is the way - unless there is some...
  13. almaragni

    Blank Space on Page 1 - Report Header Section

    ok - sorry i wasnt helpful but - i learned something new from your answer :) so thank you
  14. almaragni

    Blank Space on Page 1 - Report Header Section

    its got to be the header. check the fields in the header and format to assure not lengthy also - check the page size itself. is it possible the page size is very undersized or is there a blank image on the page.
  15. almaragni

    CR10 - Suppress total line for single line detail

    I'm sure this is a simple one - but it escapes me. JUst want to suppress the total (or detail) line when there is only 1 detail line. In order to shorten the report. I'm just looking for some hints. I was thinking maybe a running counter on the detail line and then using a supression formula...
  16. almaragni

    Crystal report width

    I would just change the page size - and use a landscape legal page size. that should give you many columns
  17. almaragni

    AD user continuously gets account locked out

    Well no luck yet... THe logon tool was only able to show me the accoount and reset the lockout. The log viewer showed me "675" pre-authentication failure audits - but these were coming all from my citrix box .. which indicates that they are most likely the result of the lockout - not the cause...
  18. almaragni

    AD user continuously gets account locked out

    Thanks everyone so far. GOt some good leads. Got a login watcher- downloaded - and trying to figure out how to use. Also looked at security log and found hidden under system user - PRE-AUTHENTICATION errors ... KRBTGT service.. am checking into this first

Part and Inventory Search

Back
Top