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!

Recent content by almaragni

  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

Part and Inventory Search

Back
Top