Issue with Drilldown Report when Parent Report Contains a Calculated Column

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered

I'm having an issue with my Drilldown Report showing no records when my Parent Summary Report contains a Calculated Column.  The Parent Summary Report indicates a qty of items exist for a particular row/column, but when the link is clicked the embedded drilldown report shows no records.

I believe the problem is related to the Calculated Column in the Parent Report.  The Calculated Column in the Parent Report is used as a filter and that filter is passed down to the Drilldown Report.  However, the Calculated Column formula is NOT passed down to the embedded Drilldown Report, so Calculated Column is undefined in the filter.

Has anyone else seen this issue and is there a fix?

Photo of GGuilbeaux

GGuilbeaux

  • 80 Points 75 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
no problem.  I hate calculated columns. Make a real field.
Photo of GGuilbeaux

GGuilbeaux

  • 80 Points 75 badge 2x thumb
Yes, thanks.  That does work and it does solve the problem.  Of course, a more elegant solution would be for the Quickbase team to properly pass down the Calculated Column formula to the Drilldown report.