How to create a dynamic report header with parameters display in Metabase

1

Hello Metabase Community,

I'm trying to recreate a report header similar to what we had in our legacy Progress/4GL system.

I need to display input parameters at the top of my report like this:

┌─────────────────────────────────────────────────────┐
│ SUIVI DES REMBOURSEMENTS - TOUTES AGENCES │
├─────────────────────────────────────────────────────┤
│ MOIS: 05 │
│ ANNEE: 2024 │
│ DEPUIS LE: 01/05/2024 │
│ JUSQU'AU: 31/05/2024 │
└─────────────────────────────────────────────────────┘

My requirements:

  • Display 4 filter parameters: Month, Year, Start Date, End Date
  • Show them as a formatted header before the actual data rows
  • Parameters should be visible in exports (PDF, Excel)

What I've tried:

  • Using UNION ALL to combine header rows with data rows
  • Creating a text visualization, but it doesn't show parameters

Questions:

  1. What's the best practice for displaying filter parameters in the report output?
  2. Can I create a static header row that shows the current filter values?
  3. Is there a way to use custom formatting or a text block above SQL results?
  4. Should I use a dashboard with separate text cards instead?

I'm using Metabase version [X.XX] with PostgreSQL.

Any help or examples would be greatly appreciated!

Thank you!

2

So these were input parameters to some transform process that creates the table the dashboard is querying? Can you put them in another table somewhere and query them with a separate card?

You forgot to fill in the Metabase version you were using from the template Claude generated for your post.