Sage 100

 View Only
  • 1.  Multiple ODBC Connections in Crystal - v2019

    Posted 08-14-2019 11:15
    Hello Crystal Gurus..

    This is such a PITA at times.....  Added a a PR report to the Custom Forms menu which added the PII Wrk file.  Now I have two data sources. 

    Is there an easy way to clean this up?  Seems to be a recurring issue for me but I have never nailed down an exact procedure for clean up.  More hit or miss when it happens.

    Thanks in advance.




    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: Multiple ODBC Connections in Crystal - v2019

    Posted 08-14-2019 11:21
    Database - Verify Database.
    Database - Set Datasource Location
    Click the one you want to change (upper section), and try to Update using the different active connections in the lower section (which show with the little plugged-in icon).


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Multiple ODBC Connections in Crystal - v2019

    Posted 08-14-2019 11:54
    Once you save it and go back in it will likely link together.  It doesn't necessary hurt anything.

    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------



  • 4.  RE: Multiple ODBC Connections in Crystal - v2019

    Posted 08-14-2019 15:13
    I usually link it to the SOTAMAS90 connection for both. They will get a new connection once they run it.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------