Forums › Cached › Customization › Reporting › SuiteAnalytics Connect (ODBC)

This topic contains 1 reply, has 0 voices, and was last updated by mark petzold 18 years, 5 months ago.

  • Author
    Posts
  • June 20, 2006 at 12:47 pm #8883

    mark petzold

    We have a lot of crystal reports that use the Transaction Lines and Transactions views. As of 11.0 they are all broken.

    The TRANSACTION_ID field on the TRANSACTION_LINES view seems to be the culprit. I can no longer join TRANSACTION_ID between TRANSACTION_LINES and TRANSACTIONS. Crystal says that they are “incompatible data types”. I can browse the TRANSACTION_ID data in TRANSACTIONS but not in TRANSACTION_LINES.

    We need this fixed ASAP because this has broken about 30 reports and affects several departments.
    This is a cached copy. Click here to see the original post.

  • June 20, 2006 at 1:19 pm #8884

    mark petzold

    RE: Transaction Lines ID is broken!

    Well, it’s fixed. If you run into a similar problem, just change your enterprise reporting password and then change it back again. This rebuilds all the views.

  • Author
    Posts