Hi,

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?