I have a DESKI report which has 6 objects and couple of filters. when I run the report it generates 2 separate select statements. They are not identical. The second select statement has only 2 objects and one of the critical conditions is added to this select statement.
When I run the report I’m not getting the expected result. But when I take the first select statement and run it in backend, I get the expected result.
On what basis BO created 2 separate Select statements?
Will BO combine the result set from both select statements and display in the report?
Can we specify which query to run thro DESKI?
when I add object(s) from a specific class, BO splits the report into two tables and create two seperate select statements. Even though I have data in the DB, report didn’t show data for the newely added column.How can I fix this.
Ok so you have objects in your query from multiple contexts? If Yes then make sure the contexts are defined properly.
You said you have a seperate query when you choose the new Object you added. Does this object belong to a table whose join is not included in the context.
Also Check if this… Open designer and in universe parameters>sql,
see if Multiple sqls for each measure is checked. If this is not desired then uncheck it and test your sql.
(BOB member since 2008-09-15)
(BOB member since 2005-12-20)