Is it possible to create Multiple Tabular references in one query?
I have three seperate reports that cannot be in one query and i need to reference a total value fronm each of the reports and add thyem together.
I have achieved this by creating the three original queries then adding a fourth query that has three tabular models with the same detail to calculate the totals. I am then able to sum the values.
What I would like to do is add three tabular references to one query this would ensure the underlying data in each query is correct.
:-[
Yes, you can. Create a tabular model under the Query. In the Children section of the tabular model, drop as many tabular references as you like.
Having said that, do you need to join the tabular references on a particular data item or are you just using a calc summarized to the report level? If you need to join them, it will be a bit more complicated.
It's kind of an ugly process; I will go into more detail if you need it.
Thanks MDXpressor
I have tried that however i get an error when running the repot saying that the field is not available. :(
I get this even if i only have one tab ref in the tab model
QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The running query contains a reference to at least one object '[].[ADJ $]' that does not exist.
Trace back:
WPBIBusMethod.cpp(197): WPDataRetrievalException: CCL_CAUGHT: WPBIBusMethod::runRequest
WPReportExecutionMethod.cpp(175): WPDataRetrievalException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions
WPExecuteRequestThread.cpp(169): WPDataRetrievalException: WPExecuteRequestThread::checkException
WPEngine.cpp(1028): WPDataRetrievalException:
WPController.cpp(263): WPDataRetrievalException: CCL_RETHROW: WPController::executeRendering()
LWDataRetrievalEngine.cpp(320): WPDataRetrievalException: CCL_RETHROW: LWDataRetrievalEngine::prepare
LWDataRetrievalEngine.cpp(1842): WPDataRetrievalException: CCL_THROW: LWDataRetrievalEngine::runQSQuery
Source/QE_QsApi.cpp(3384): QSException: CCL_THROW: QE
In this report just need to sum three field
I am interested in the join part (but later if i get this to work)
The empty brackets [] are the clue - you need to name the tabular model of you target query, then edit the data items and fill in the brackets (or delete and recreate them).
Steve