Build the solution · 4 / 5

Deliver separate workbook sheets

Package the job list and prepared note as a useful workbook.

YOUR TASK

Make this happen

3 steps

Add a workbook output and Jobs/Handover sheets reading jobs and summary. Preserve the CSV output.
Keep the working capabilities from the previous lesson and connect the new pieces to the same solution.
Check the complete solution, then inspect any unmet requirements.

THE IDEA BEHIND IT

What this step adds

Add a workbook output and Jobs/Handover sheets reading jobs and summary. Preserve the CSV output.

Files to work in

main.cococo, outputs.cococo, sheets.cococo. Other files are the working baseline. New files include named resource skeletons and TODO guidance. Complete their fields and connect them using the objectives, schema completion and reference guide.

Different readers, one data snapshot

The same run supplies data to multiple outputs. A workbook can use up to sixteen named sheets. Each points at a dataset; sheet names must be unique.

Choose one workbook shape

Use sheets or a single dataset on a workbook output, never both. Database output storage is bounded; larger files belong in managed FILE storage.

Local checks validate native report models and lesson requirements. SQL execution, permission checks, Lua preparation and PDF rendering run on the platform. PDF XML remains a separate authoring format; no PDF virtual model is invented.

Files to change: main.cococo, outputs.cococo, sheets.cococo

What you’re building: Deliver a production handover pack that people can read as CSV, workbook or PDF.

This step starts with the earlier solution and one new challenge. Each lesson keeps its own draft.

Read the starter files

main.cococo

report_document "weekly" {
  schemaVersion = 1
  snapshotRetentionDays = 30
  sources = [report_source.jobs]
  outputs = [report_output.csv]
  parameters = [report_parameter.show_note]
  preparationScript = file("prepare.lua")
}

source.cococo

report_source "jobs" {
  name = "jobs"
  kind = "MICRO_SQL"
  query = "SELECT jobs.name, jobs.status FROM jobs ORDER BY jobs.name ASC LIMIT 100"
}

outputs.cococo

report_output "csv" {
  name = "jobs.csv"
  format = "CSV"
  storage = "DATABASE"
  dataset = "jobs"
  columns = ["name", "status"]
}

parameters.cococo

report_parameter "show_note" {
  name = "showNote"
  label = "Include handover note"
  type = "BOOLEAN"
  required = false
  defaultValue = false
}

prepare.lua

input.datasets.summary = {{ message = "Production handover" }}
return input

sheets.cococo

report_sheet "jobs" {
  name = "Jobs"
  # TODO: add dataset — see the task above.
  # TODO: add columns — see the task above.
}

report_sheet "summary" {
  name = "Handover"
  # TODO: add dataset — see the task above.
  # TODO: add columns — see the task above.
}

Reference: reports · getting-started reports · sql-authoring reports · values reports · preparation reports · pdf-templates reports · operations reports · reference