Could anyone have a look at the SQls attached and give me some ideas on what the problem could be? These are SQLs of two reports - one from fullclient and one from WebI. Apart from one being developed in full-client and the other in WebI, the reports are the same - accessing the same columns and calculating the same measures. The fifth item in the Select clause is the measure that is causing me the problem. The full-client report runs perfectly. But in the WebI report, the fifth item in the Select statement also appers in the Group By clause in the end, even though the item being selected has been defined as a measure in the universe! This gives me an SQL error everytime I run the report. Why does this happen in WebI? WebI SQL.txt (4.0 KB) Full Client SQL.txt (4.0 KB)
Hi DD…Well, I already tried that approach! It seemd like the most logical thing to do so i did try using a max/min to settle the problem. But although that didnt give me the SQL error, the report was split into 2 SQL queries which did not combine correctly. So altho i got the right values the number of rows were doubled, ie, 2 rows for September, 2 rows for October etc.(see attachment). Any suggestions?.. Doc.doc (87.0 KB)
Upgrading is another option. 6.1.x could not correctly build a multi-SQL statment report. Although it would build the multi-SQL, it would create separate blocks no matter what. You could drag the objects around after and build the correct report.
Hi Steve…Looks like upgrading is the only option!!Unchecking the “Use Multiple SQLs” is something that wont work at all for the rest of my reports!..Thanks and have a great New Year…
(BOB member since 2002-06-17)
(BOB member since 2002-06-25)