RRDI creating cascading parameter retrieve Cross-join error
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?
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?