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

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

    AD user continuously gets account locked out

    I have a user who's account is continuously getting locked out. I've checked the security logs and cannot seem to find anything special. We use some sharepoint and citrix. any ideas? thanks
  6. almaragni

    How to connect to a different databases using same report

    we have a 3rd party report web page product - which allows setup of report criteria, parameters and scheduled running. very nice. one feature i liked was the ability to setup and run the same report with different options - including database however, now i am told the v10 version of CR is...
  7. almaragni

    where selection excludes NULL values

    Can you help me with this question please. I'm not a formally schooled DB/SQL person, and reading the help info just confused me more so. i have - what i thought - was a simple query select * from orders where status <> 'HOLD' the actual statement is more complex -with joins and such...
  8. almaragni

    Sub query using IN clause doesn't evaluate

    Looking for some help on a issue that's bugging me hardy. I am trying to create a subquery with values created from text string. ie.. ======================================= declare @templist varchar(100) -- temp var of text strng SELECT @templist = '''' +...
  9. almaragni

    reference table twice in same report different key

    I thought i had this easy - but i guess it is not so. i have a single table (master) that needs to be referenced more than once by (plan) table. plan table has parent and child on each row. Master has information for each parent or child - as they are both considered items in the master...
  10. almaragni

    sales order invoice printing

    Do you know where or how i can modify the sales order/print invoice? or the sort sequence for the invoices? These are the invoices that are printed in the distribution module (sales orders) instead of AR module. thank you
  11. almaragni

    dos v9.1 - REBUILD IC255-1 Error reading message - index

    Any help deeply appreciated - with instructions on how and which files to rebuild / reindex in this 9.1 version. Getting this error in payroll ENTER details in TIMMNA program. TIMTRX00.DAT or TIMTRX00.IDX files are bad - i think. But cant seem to get the proper reindex command working...
  12. almaragni

    merging data base companies

    do you have a checklist/quideline document that would cover the issues that may come up during an attempt to merge two separate data base companies into one? do you have a document that might have some good discovery questions that would help determine the account setup? such as .. do you...
  13. almaragni

    remove fixed assets

    We recently brought up a location on ebackoffice. Although we had our test data base cleared out as the source data base for our production/go live db - apparently our consultants forgot all the junk/test assets in the asset management system. Can you tell us how (i.e. which tables) we could...
  14. almaragni

    use multiple databases in stored procedure

    Hello - I am looking for confirmation help on an issue. I am trying to report from tables out of 2 separate databases ... creating temp table to pull from one - then insert records from another ... but I am getting error 154 - that the USE command cannot be issued in a SP. Is it as simple as...
  15. almaragni

    OLE OBJECTS

    Ok - i got the hang of OLE objects. But there is little or no documentation on using this feature more rigorously. Does anyone have a cheat sheet on the function of all those other fields in the OLE OBJECTS screen? THank you
  16. almaragni

    Data access - ASP - ODBC - using sample app

    I am using CR8 on IIS with ASP. Got everyting loaded to make simple report run - using MSAccess . However, when I try to use one of my simple reports using an oDBC to SQL svr . i get the errors - user session expired, an error occured on the server accessing the db, failed to connect ... yada...

Part and Inventory Search

Back
Top