Skip to main content
Question

Drill down of summary report shows no records found

  • July 30, 2019
  • 0 replies
  • 32 views
I have a summary report by client name. When I click on a client name from that report, it used to bring up the records for that client. Now it shows no records found. If I edit the drill down report and change Client Name EQUALS to Client Name CONTAINS, I get results. Any suggestions?
    This topic has been closed for replies.

    You might check to see whether the field has some extra characters in it... either spaces or non-printing characters at the beginning or end.
    Is this for all Client names or just certain ones with strange characters in their name.
    Equals" matches the exact full name in the field, "contains" matches only the word in the field - not sure whether that is creating the difference in your search
    Did you mess up the drill down report which is set for that Summary report to use?  Try leaving as the default report and see if it works and then debug from there.  The target report for the drill down normally would not have a filter by client. 
    Terms & ConditionsAccessibility statement