Sage 100

 View Only
  • 1.  Crystal gives varying data dependent on machine

    Posted 07-30-2019 11:34
    Updated a customer from 2014 -> 2019. On running an AR custom report I get correct data when it is run from the server but missing data when run from workstations. Never seen anything like this before.

    ------------------------------
    Zalmi Berger
    Elxee LLC
    ------------------------------


  • 2.  RE: Crystal gives varying data dependent on machine
    Best Answer

    Posted 07-30-2019 11:43
    Does the report use a custom DSN?  If so, the workstation may be pointing somewhere else.

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



  • 3.  RE: Crystal gives varying data dependent on machine

    Posted 07-30-2019 13:33

    I would look at ODBC settings first

     



    ------Original Message------

    Does the report use a custom DSN?  If so, the workstation may be pointing somewhere else.

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


  • 4.  RE: Crystal gives varying data dependent on machine

    Posted 07-30-2019 22:55
    Thanks guys. I will follow up tomorrow.

    ------------------------------
    Zalmi Berger
    CEO
    Elzee Business Systems
    Boca Raton FL
    (845) 418-5055
    ------------------------------



  • 5.  RE: Crystal gives varying data dependent on machine

    Posted 07-31-2019 20:56
    Thank you. I did make a custom DSN and it was pointing to 2014 folder.

    ------------------------------
    Zalmi Berger
    CEO
    Elzee Business Systems
    Boca Raton FL
    (845) 418-5055
    ------------------------------