Print this page

Why can’t I drill down to the report for the selected State/Province or Country?

Knowledge Article Number 000214226
Description
  1. Create a summary report and group it with “Billing State/Province” field
  2. Run the report and select one or more values of the groupings and click on Drill down.
  3. It takes back to the customize report page rather than drilling down to the selected records or groupings.
The same behavior is observed when we group or drill down with “Billing Country” field.
 
Resolution This behavior is observed only in those Salesforce instances where State and Country Picklist feature is enabled and all states are not configured with the State Code.
To be able to drill down to the selected record we can use following workaround.
  1. Create a report and group it with “Billing State/ Province (Text only)” field.
  2. Run the report and select one or more values of the groupings and click on Drill down.
  3. It will drill down to the selected records or groupings.
     
The field “Billing State/ Province (Text only)” is available only when we enable state and country picklist.
  • The field contains old state and country text values that you specified before picklists were enabled. Or,
  • The field contains the integration value that you specified as a picklist value.
It is suggested to use the picklist fields rather than these text fields for the consistent data but when we want to drill down to the report using the state or country fields, we need to use these texts fields for the Drill down function to work correctly.

If we closely observe the report, we understand that when we drill down to the report with state or country fields it actually filters the report with the state code or country code respectively. If all the states and countries are not configured with the correct state and country codes then drill down functionality do not work in those Salesforce instances.
Hence to make this report work correctly, we need to use the “Text only” fields for State/Province or Country.




promote demote