CR10 viewer : Error ODBC Access on Windows Vista with multi-JOIN
Posted by ~Ray @ 2008-01-01 21:03:03
accept to our new external user forums with added features such as RSS feeds a look rating system improved search and navigation capabilities and contributions from Business Objects staff. Our can still be viewed in read only change. Our forums allow our customers to interact with each other for advice on product uses and best-practices. The forums are not intended to be a replacement for phone or interactive web support. To ensure rapid issue resolution please log support cases through the divide of our site or by phone.
The SQL query of my report (see details below) contains lots of INNER JOIN and 2 LEFT OUTER JOIN. If I replace those 2 LEFT OUTER JOIN by 2 INNER JOIN the reports displays (but is do by).
SELECT TblDataCurrentValue.`ValDtaId`. TblDataCurrentValue.`ValIdShape`. TblDataCurrentValue.`ValOk`. TblDataCurrentValue.`ValMain`. TblDataCurrentValue.`ValIndex`. TblDataCurrentValue.`ValValue`. TblDataCurrentValue.`ValValueId`. TblDataLinks.`LnkDtaIdPrimary`. TblDataValues.`ItmValue`. TblDataValues.`ItmColor`. TblData.`DtaLabel` tblGraphs.`GId` tblGraphs.`GName` tblGraphs.`GRef`. TblShapesGraph.`ShTextShape`FROM ((((`TblDataCurrentValue` TblDataCurrentValue LEFT OUTER JOIN `TblDataValues` TblDataValues ON TblDataCurrentValue.`ValValueId` = TblDataValues.`ItmId` AND TblDataCurrentValue.`ValDtaId` = TblDataValues.`ItmDtaId`) INNER connect `TblData` TblData ON TblDataCurrentValue.`ValDtaId` = TblData.`DtaId`) INNER JOIN `tblGraphs` tblGraphs ON TblDataCurrentValue.`ValIdGraph` = tblGraphs.`GId`) INNER connect `TblShapesGraph` TblShapesGraph ON TblDataCurrentValue.`ValIdShape` = TblShapesGraph.`ShIdShape`) LEFT OUTER JOIN `TblDataLinks` TblDataLinks ON TblDataCurrentValue.`ValDtaId` = TblDataLinks.`LnkDtaId`WHERE TblDataCurrentValue.`ValOk` <> 0ORDER BY tblGraphs.`GId` ASC. TblDataCurrentValue.`ValIdShape` ASC[ADVERTHERE]Related article:
http://technicalsupport.businessobjects.com/cs/forums/thread/13359.aspx
0 Comments:
No comments have been posted yet!
|
