Support Article
No results returned in SummaryView Report with joins
SA-21919
Summary
Summary View report "ActionPerforamceTimeIC" retunrs zero results when two join conditions are specified
Error Messages
No error message. Zero results returned.
Steps to Reproduce
1.Go to Summary View report "ActionPerforamceTimeIC".
2.Add two join condition.
3.Save and run the report.
Root Cause
Collected SQL query formed for the join condition and executed in the database and there are no results returned. That means the conditions performed in the join are having no result to display in the report.
Resolution
Inorder to get the required result from the report, include a proper class in the join condition upon which you want to fetch the results.
Published April 14, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.