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!

Register Log in
  • Congratulations derfloh 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: scottpdann
  • Content: Threads
  • Order by date
  1. scottpdann

    Integration Manager Problem

    I get the following error when running an integration. I've run it before and had no issues. DOC 1 ERROR: Non-alphanumeric characters were found in the 'Account Number' field of the 'Entries' recordset I can see no problems with my account numbers. Has anyone else run into this? Scott P...
  2. scottpdann

    Integration Manager v10 Functionality

    What happened to the option to "Save As" to copy an existing integration? Is there a way to get it back? Thank you, Scott P. Dann
  3. scottpdann

    Formula to summarize yearly date on same row.

    I want to summarize my data as follows: Donor|2007 Contributions|2008 Contributions|2009 Contributions What is the formula to put each year's summarized contributions in a column? Thank you for your help.
  4. scottpdann

    PO Commitments

    Does anyone know how to get a summary report of PO commitments by GL Number? I know how to look up an individual account by going Inquiry-->Purchasing-->Budget v. Actual & Committed. This is a great tool for a budget manager. The problem is us bean-counters need to know how much is committed...
  5. scottpdann

    Suppressing Duplicate Data

    I am using Crystal XI. The Zip code data base (drawing from Oracle) has multiple cities linked to the same Zip Code. When trying to pull records, a duplicate record is displayed for every City associated with each Zip Code. E.G. for Zip 44139, a record for Cleveland and Solon show up, for...
  6. scottpdann

    Frx Exporting to Excel

    We recently upgraded to Great Plains 9.0 and Frx 6.7 and we have been unable to export reports with multiple reporting units (and multiple pages in excel). Does anyone have any suggestions how to fix this problem? Thank you. Scott P. Dann, Jewish Community Center of Cleveland
  7. scottpdann

    Speed issues Crystal Reports X

    It is taking an unbearably long time to read the records for this report. Is there anything I could do better in the record selection formula? {ARF.SQL_TRANS_DATE} in Date (2005,01,01) to Date (2005, 12,31) and isnull ({FAMILY.SQL_DEACTIVATION_DATE})and {ARF.SQL_BILL_CODE} in ["0001"to...
  8. scottpdann

    ODBC Connectivity

    I am having trouble getting my IBM Universe ODBC data accessed in Crystal versions 9 and 10. Any thoughts? Thank you.
  9. scottpdann

    IBM Universe ODBC Connectivity

    We recently upgraded our IBM/Informix Universe ODBC connection and the interface to Crystal no longer works. Does anyone have the same issues? Thank You, Scott P. Dann Jewish Community Center of Cleveland
  10. scottpdann

    Check Register Data Table

    I want to be able to download my check registers automatically using excel or Acesses data functions. Any thoughts on how to do this? What tables should i look at?
  11. scottpdann

    Error message when trying to Print

    I just loaded SP6 on Version 7.5 I am getting two error messages: "Error in Equation 'cyDebitAmount' or "Error Registering Table GL_ACCT_MSTR" Any thoughts on how to correct this?
  12. scottpdann

    Smartlist Problems--Historical Transaction Amount

    Is there a way to get historical payables information in Smart List. There is no field with historical transaction amounts. Thanks for any help.
  13. scottpdann

    Great Plains Data File Location

    We run 7.5 MSDE. My boss wants me to restore a backup to a Test company. I created the test company. Where should I look for the data for both the existing (so that I can identify it on the backup tape) and the Test company (so that I know where to restore it to. Thanks you, Scott P. Dann
  14. scottpdann

    Smartlist Problem

    Is there a way to get historical payables information in Smart List. It seems to produce only Current data. Thanks for any help.
  15. scottpdann

    Linking Subreports

    I have a field that matches in both my sub report and main report. The subreport has another field that I want to match to the main report. I.e. I want my main report to look up the field in the sub report an put the other field next to it. Any thoughts?
  16. scottpdann

    How can I link the data in my sub report in my main report

    I want to set up a link between my main report fields and my subreport fields. How do I do it?
  17. scottpdann

    How do I shorten a string

    I have a field with values like B7527*2*2004 B7527A*2*2004 Is there a formula to convert it so that every character from the first * and right disappear. Looking like this B7527 B7527A Thank you.
  18. scottpdann

    IF Statements

    I created a formula comparing dates, divided it by 365, and it told me the year between the two dates. It is blank if there is no second date. I need to create a formula where if this earlier # is >1.25 I want to list it as "former" , if it is greater than Zero, and 1.25 or less, it...
  19. scottpdann

    Passwords

    I am using Great Plains 7.5 for MSDE, When I tried to chage a user's password, it wouldn't let me. I then deleted her and tried to add her as new record, and it wouldn't let me enter a password at all. It used to work fine. Any thoughts?
  20. scottpdann

    I want only to include certain records.

    In a membership organization, we ran a special from January 20th and later. For those who renewed. I want to find out their prior transaction date. I can only get the report to include either just the Current transactions, or a 1000+ page report including all of the transactions. I want to scope...

Part and Inventory Search

Back
Top