Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

ODBC views and OLEDB commands in same rpt?

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Phil Simon
Veteran Member
Posts: 135
Veteran Member
8/13/2007 5:45 PM
    Hello

    CRXI
    OLEDB 9.0.3

    I doubt that the answer is 'yes', but can you create views in SQL Server 2005 and link them on the same report to OLEDB commands? If you do this, then are there any visibility issues with the data?

    Thanks.

    ps
    Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
    John Henley
    Posts: 3353
    8/13/2007 6:32 PM
      Actually, that can be done, and it works quite well...
      (see this thread:
      www.lawsonguru.com/Forums/tabid/96/...fault.aspx)
      Thanks for using the LawsonGuru.com forums!
      John