How to display a record in summary report even if there is no item in it?

  • 2
  • 2
  • Question
  • Updated 2 years ago
  • Answered
Please look at the below screenshot. You see how "2- Significant" is missing in the summary table? It is because there are no records with that entry. I still want it to display with a "-"

To be clearer, Risk Impact is a multiple choice text field, so is Risk Probability 

Photo of Chinmay Dhandhania

Chinmay Dhandhania

  • 224 Points 100 badge 2x thumb

Posted 2 years ago

  • 2
  • 2
Summary reports are not setup to show rows with no records being summarized. The only way that you would be able to do this is to have Risk Impact as its' own table. On that table, you would then do one summary field for each Risk Probability, using the filter in the Summary to limit the records to that Risk Probability. Once you have that done, you can do a Table Report with the Risk Impact as the Row and the summary fields as the columns.