Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Derived table queries in ReportNet

Status
Not open for further replies.

devcog

Programmer
Jul 7, 2004
78
GB
Hi All,
Has anyone made use of derived table queries to create virtual tables as child tabular elements?

I am trying to create one, but I get the following error when I join both the child tabular models in Parent tabular model:
"QE-DEF-0103 Cross joins are not permitted for the user who has the identity '{Everyone, Authors, Query Users, Consumers, System Administrators}'. "

Please let me know the reason/solution for this beahvior

Thanks,
 
Go into the properties of the query and there is an option called 'Cross Product Allowed'. Set this to 'Allow' and you should be set to carry forward.
 
Hi flex,
Thanks for the reply...even I get the same error when I used sub-query as a child tabular model.
the sub-query returned only one row because it returned me the latest or MAX transaction.
And when I changed the '=' operator in the filter condition of the parent tabular model to IN, it worked.

Please let me know I would have to make the same change to the query option to avoid the error.

Thanks in advance,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top