It's all about the answers!

Ask a question

RRDI creating cascading parameter retrieve Cross-join error

Milan Krivic (9809171139) | asked Jan 22 '13, 8:50 a.m.
edited Jan 22 '13, 8:51 a.m.

When creating cascading report parameter in RRDI, getting the following error:

Cross joins (between query subjects... (in my case: different query subjects)): are not permitted for the user who has the identity '*'.

Actually, for report data, I am using one query, and for reporting parameter, I am using other query.

I tried to build Cascading parameter regarding Projects and it's categories. When I test it before displaying data, it populate project categories based on selected project, but on displaying data, it displays mentioned error about cross joins not permitted.

When I remove Project cascade from Category parameter in options, everything works well.

Any idea how to solve this?

One answer

permanent link
Alanna Zito (1.3k3) | answered Jan 22 '13, 11:52 a.m.
Hi Milan,

This technote - - has some information about what this error message means, and how you can enable cross joins for your query.

Your answer

Register or to post your answer.